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
- 5105 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Write a pseudo code to evaluate a number to any base given (2...16) based on the input. Number greater than 9 should be given as A-F for 10-15.
any drawback are there in mantis?
can any method return type may be constructor , or that method name allow
Have you used callsymputx? what points need to be kept in mind when using it?
what is difference between object oriented programming structure and object oriented programming system?
What is abstract Method i want the exact definition and is there any possibility to declare class as abstract without any abstract methods in that class?If it is possible then tell me why and how?
In OB52 , How to define two open posting period, Like only 5 and 8 posting should be open.. should not open 6 and 7..period..
What is test execution and when will we start execution please send me one example for this question
WS-NUM PIC S9(05)V(02) SIGN TRAILING SEPARATE MOVE '0050000+' TO WS-NUM The value stored is 00500,00+ MOVE '0050000-' TO WS-NUM Then what is the value will be stored in WS-NUM? Am getting '-00500,00'.....>>> What should I declare to WS-NUM so that I can get correct values for both + & - signs.
what is the use MDM(Master Data Management)and meaning
How does the type system works when there is interoperability between a COM and .Net, i mean what exactly happens there
we create a pf with 3 fields.2 is defined as keyfields.we lock it with alcobj command.how we find out whether the file is locked or not?is it dspfd??/
In JCl , we have COND parameter.This holds comparison code and condition.It also has only and even parameters. ex: COND((4,GE),EVEN).what the comma mean here. is that 'and' or 'or'.
what is technical system, business system, logical system in sap pi7.0
What is dialog programming?
