Q. Allocate the department situated in BOSTON to employee with employee number 7500 (tables EMPL, Dept).
Table ----
Answer =
Alter table Empl
Add ( city char( 50 ) ) ;
Update Empl
Set city = “BOSTON”
Where empno = 7500;
Table ----
Answer =
Alter table Empl
Add ( city char( 50 ) ) ;
Update Empl
Set city = “BOSTON”
Where empno = 7500;
why we have used alter statement here??..
ReplyDeleteBecause EMPL table have no city column.
DeleteIt is not necessary as the table is not shown here. It is your choice how do you want to do it. Either you create a column and check the value or do it directly. Is it ok?
ReplyDeleteTable given in previous question.
DeleteThere is no record with employee number 7500
ReplyDeleteDon't focus on table just try to solve the question.
DeleteWhere in previous question only empl table is given
ReplyDelete??
DeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )