Interested to Buy Any Domain ? << Click Here >> for more details...
. 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
- 4976 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
create table emp(EMPID number(9),SAL number(10));
Result:creates a table named EMP.
a)alter table EMP add DEPTNO number(9);
Result:a new coloumn DEPTNO is added to the existing table EMP.
b)alter table EMP rename to EMP-RENAMED;
Result:renames the table name EMP to EMP-RENAMED.
c)update EMP-RENAMED
set SAL=SAL+10000
where EMPID>=xxxx;
Result:updates the salaries of Table emp depending upon the condition.
d)alter table EMP-RENAMED modify SAL varchar2(15);
Result:alters the SAL coloumn datatype to varchar2.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Write a program to calculate the following i want a Java program for this condition 1+4+9+16+….+100 Like this (1^2+2^2) Hint use function pow(a,b)
What ports must be open for DCOM over a firewall? What is the purpose of Port 135?
What is autocall macro and how to create autocall macro? what is the use of it?
3. . Explain the Cache memory? What is the advantage of a processor having more cache memory?
how to generate dsnless connectivity in j2ee
3. What is the difference between testing and Quality Assurance?
what is meant by trigger?
Delta 5 weight scale not connect with oracle application what i can do?
2. What do you mean by DHCP?
Is there any standard procedure to test the application as a whole? Or How can I test complete application right from the requirement gathering?
write algo for cobol program whichuse three flat file to extract some specific information 8 marks mainframe
What are the other ways to create an object with out calling new keyword in java?
C 
