. 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
- 4380 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 |
given a height balanced tree. If we add one more node , how many nodes gets unbalanced ?
Is CTS company do serious backgroung check?
What is meant by spooling
What for decision coverage and modified condition decision coverage are used? Wat is the difference between them?
When we use Windows authentication mode
can any method return type may be constructor , or that method name allow
how to run servlets in eclipse 3.3.2....if we choose file->new->servlet then after that it is showing javax.servlet.* ...cannot be resolved.......to avoid this error any external jar file is to be added? please help me regarding this issue........thank u
when will triggars the at new event in abap and web dybn pro?
Indentify the essential difference between GUI and a command line operating systems?
1 Answers Deloitte, Infosys, Wipro,
Difference of Console, web & windows applications?
1.Describe about your project?
plz send me NIC Scientific Officer /Engineer-SB(Programmer) previous question paper or syllabus
C 
