. 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
how can we implement locks in plsql?
through which algorithm does the garbage collector works? how the garbage collector will understand that the object will going to be deleted?
ok how would i do the following extract from a file i have ssns = 267907230 which are in column 7 into a separate data set then create a 2nd job step to extract from the data set created the following "fund code" which is in column 31 and is 113 into yet another data set
can any one suggestion me present which course(except java,.net) has huge demand in the market?
what are resources in case of Threads
Write a program to find whether a given number is prime or not.
I want Ada programming language books. Could anyone post me any link for that?
write a sql qwery which include joining of two tables 4 marks mainframe
8.In DSP,Define Signal and System?and various type of signals.
i want to improve my english vocab for racking campus written exam plz tell me best book for prepration......
What is WEB 3.0? What are the features their in WEB3.0
Which language they use during interview?
what is the BAM? where we can use it in BizTalk server?
what is the main usage of an abstract keyword?please follow the program class A { void display() { System.out.println("hai"); } void print() { } } class B extends A { void print() { System.out.println("Hello"); } } In this program i was gives the implementation of print() according to my requirements in subclass.And there is no definition in superclass then why we can use abstract keyword before a method that i want to gives definition in other classes,is any mistakes in the above usage of method?
hi i m deepak my shedule for NIC pi is 17 Apr please contact me if anybody has interview on same day or give me some idea who have faced