Interested to Buy Any Domain ? << Click Here >> for more details...
. With the help of above table EMP, perform the following
operation is sql.
a) Add the new column “DEPTNO”
b) Rename the table
c) Update table
d) Modify the table if column ‘SAL’ whose data type is
number (10) and you want to enter varchar2 (15) . For
example $USD 20 etc.
- 2 Answers
- 4868 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
create table emp(EMPID number(9),SAL number(10));
Result:creates a table named EMP.
a)alter table EMP add DEPTNO number(9);
Result:a new coloumn DEPTNO is added to the existing table EMP.
b)alter table EMP rename to EMP-RENAMED;
Result:renames the table name EMP to EMP-RENAMED.
c)update EMP-RENAMED
set SAL=SAL+10000
where EMPID>=xxxx;
Result:updates the salaries of Table emp depending upon the condition.
d)alter table EMP-RENAMED modify SAL varchar2(15);
Result:alters the SAL coloumn datatype to varchar2.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / arvind agrawal
if want a column in table emp then perform above operation
sql>add deptno into emp;
| Is This Answer Correct ? | 0 Yes | 0 No |
7.x=10; y=20; x<<2=? x<<1=? y>>2=?
What is algorithm in SCD Type2(SAS DI Studio Transformaton)?
which one is the best practice using synchronization method or synchronization block
What is procedural oriented language language..? give some examples of this language....?
This is a puzzle question .... The warden meets with 23 new prisoners when they arrive. He tells them, "You may meet today and plan a strategy. But after today, you will be in isolated cells and will have no communication with one another. "In the prison is a switch room, which contains two light switches labeled A and B, each of which can be in either the 'on' or the 'off' position. I am not telling you their present positions. The switches are not connected to anything. "After today, from time to time whenever I feel so inclined, I will select one prisoner at random and escort him to the switch room. This prisoner will select one of the two switches and reverse its position. He must move one, but only one of the switches. He can't move both but he can't move none either. Then he'll be led back to his cell. "No one else will enter the switch room until I lead the next prisoner there, and he'll be instructed to do the same thing. I'm going to choose prisoners at random. I may choose the same guy three times in a row, or I may jump around and come back. "But, given enough time, everyone will eventually visit the switch room as many times as everyone else. At any time anyone of you may declare to me, 'We have all visited the switch room.' and be 100% sure. "If it is true, then you will all be set free. If it is false, and somebody has not yet visited the switch room, you will be fed to the alligators." What is the strategy they come up with so that they can be free?
What is a must for multitasking? a) Process preemption b) Paging c) Virtual memory d) None of the above
what are all the ant command options
What is the output of the following x = "abcdef" i = "a" for i in x: print(i), a) no output b) i i i i i i … c) a a a a a a … d) a b c d e f
why Java is not purely object oriented?
How to update a data for the views in the relational data base schema
what is the difference between Windows application and Unix application?
What's the difference b/w Table & Templete in Smartform?
C 
