. 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.
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 |
Delta 5 weight scale not connect with oracle application what i can do?
I want Ada programming language books. Could anyone post me any link for that?
How to find out the user exit for va01.
iam confused among testing ,.net and java. can anybody help me.
Hi All, Can any one please send me the difference between informatica 7i and 8i versions, Thanks in advance. vinod
Please anyone tell me coding to print prime numbers from 1 to 5000 in c#....
Given an array of size n. It contains numbers in the range 1 to n. Find the numbers which aren?t present.
Definition of Singleton Class? what is the Purpose of it? what is the advantage?
Who is the Best SAS/Clinical Trainer in Hyderabad
This is the portal and portlet interview question API: is JSR 168 API Server: is ibm web sphere portal server6.0 IDE: is RAD 7.0 Question:In normal struts what is the actionservlet? Ans:org.apache.struts.action.ActionServlet. But What is the actionservlet in strutsportlet?
how does database connection using ADO.NET?
Wats the name of the first os