. 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.
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference between SCAN AND CHECK,LOKUP AND XFOOT? where we can use thease opcodes? Can any body tell me real time senariao with example?
I am looking for NIC Sample papers or any patern of questions/ syllabus plz, send me on hamid.khan135@yahoo.in Regard
Tag for turning an image into a hyperlink is
Find out the list of authorization objects which contains activity as a field? Thanks in advance.
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?
What is test execution and when will we start execution please send me one example for this question
< DL Compact > tag is used for
can any one suggestion me present which course(except java,.net) has huge demand in the market?
is it possible to desable particular parameter of the normal orcle report based on some condition ?????? if yes,wht is the function for desabling a parameter...
kindly send interview materials
how to add a new table with variables and thier values into a imported file uisng proc import?
3 members in a pf.how we read 3 members without using ovrdbf.using rg pgms....
could u please also write an example of a code that involves instances from an abstract class just as u did for interfaces because u said it could also work which i really doubt. thanks
iam confused among testing ,.net and java. can anybody help me.
can u send some model papers how computer awareness questions are asked in goverment jobs(oriental insurance)to my mail id me.priyankapadma@rediff.com