. 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
- 4073 Views
- I also Faced
- E-Mail Answers
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 to data grid use in data bind?
write algo for cobol program whichuse three flat file to extract some specific information 8 marks mainframe
HOW TO FIND NUMBER OF TWOS IN N!(N FACTORIAL)??
Given a Binary Search Tree, write a program to print the kth smallest element without using any static/global variable. You can?t pass the value k to any function also.
THERE ARE 4 SOURCE FILES WHICH CONTAINS SAME METADATA CREATE A TARGET THAT SHOULD DISPLAY THE FILE NAME ALONG WITH THE RECORD PLEASE SEND THE ANSWERFOR THIS QUESTION WITH MAPPING
what is the difference between read the data from table and infotype
Code for display the images from drive using vb 6.0?
what are importance in problem tracking
difference between mantis and other tools?
is it acceptable if we declare multiple exceptions in same overridden method.
hii I inntrested abt scjp certification but i dont knw abt scjp plz send details abt scjp exam and syllabus.
what are the 3 forms of a prolog term
in cobol,wat is the difference in using 'set index in occurs clause' ....and 'occurs depending-on clause'
how will you code the subfile which is in editing mode (multiple case subfile)?
what is the software to run the GSM gate opener program
