. 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
- 3762 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
why we use mantis? what u mean mantis in IT trends? addvantages of mantis?
3 members in a pf.how we read 3 members without using ovrdbf.using rg pgms....
what is the difference between uservariables and systemvariables (in Environmental variables)???
19. Given a system that is described with the following equation, X=A+(B.(A̅+C)+C)+A.B.(D̅+E̅) a) Simplify the equation using Boolean Algebra. b) Implement the original and then the simplified equation with a digital circuit. c) Implement the original and then the simplified equation in ladder logic.
Write a program to find duplicate number from array in minimum time complexity.
In mainframe SDSF, Can we copy the list of jobs currently executing in SDSF in to a seperate DATASET...?
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 class module in vb6? what it's use? with example..
what are the activities you enjoy most and How do you see these Developing in the Future with Reference to in your work life and in your personal life
Differevce between arrays and array builders?
What is the purpose of
Why did you ever become involved in QA/testing?
I m new to the dbms. Recently i came across words clustered indexes & nonclustered indexes but i dont know what is this all about & whats the difference between them.. So please help me!!!!!!!!
Hi All, Can any one please send me the difference between informatica 7i and 8i versions, Thanks in advance. vinod
when will triggars the at new event in abap and web dybn pro?
