. 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
- 4072 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 |
How to rename A1-A30 datasets into B1-B30 using macros?
smal talk is pure object oriented or not?
through which algorithm does the garbage collector works? how the garbage collector will understand that the object will going to be deleted?
we can use parameters in cl and rpg pgms...etc.in particular i think when we use data area or datastructure or data queue .i think this means which one====in my question...parameters cannot be passed in which one????hope understand my qstn???
is it possible to learn sap from book without any tutorial. if yes please mention the beginner,s book of sap and also make your valuable advice for self study of sap .
how to fin top two miximum values in sql? not 2nd both max value of 1st and 2nd both have to find out
what is log files in qtp what is use
5.Call by value and Call by reference with program?
how much fee for deccan soft institute .how to block seat for sandeep sir class reply soonnnn
What is WEB 3.0? What are the features their in WEB3.0
hoe to data grid use in sql server 2000?
Colors specified with the notation
C 
