. 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
1. Write a program to create a sentence at runtime and count number of vowels in it ? 2. Write a program to get a string and to convert the 1st letter of it to uppercase ?
what is the use MDM(Master Data Management)and meaning
In loading programs into memory, what is the difference between load-time dynamic linking and run-time dynamic linking?
How to call dll API sub routine in VB Form.
why we need to take u?
How to call a C++ function which is compiled with C++ compiler in C code?
can we retrieve only integer/String type columns from a table,if yes how?
Diff between IF and where ?
define profiler???
why not instantiating servet using new operator?
< DL Compact > tag is used for
how to fin top two miximum values in sql? not 2nd both max value of 1st and 2nd both have to find out
how to data grid use in data bind?
Diffrence between 2.0,3.0,3.5,4.0. versions of .net?
9.Difference between even and odd signals?explain with the diagram?