. 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
- 3750 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
If i have a dataset queried from Sql and I would like to insert the dataset into a specific node in an xml document how do I do this
how pseudo column works?
What is SOLID Principle in Programming Language?
how many types of operating system are avaliable?
Differevce between arrays and array builders?
it is a language or tools?
What is web.configuration? how is it work? & wht is use this?
Mainly Related to Oracle, DBMS , Oracle Stored Procedures, Functions, Oracle 9i Architecture, Redo logs..., Views,
What is ur porject Architecture? If anyone ask what i have to specify here..
Given an array of size n. It contains numbers in the range 1 to n. Find the numbers which aren?t present.
Suppose we are doing 4 operations on database using service, first operation is successful but due to some reason remaining 3 operations are failed. I) is this transaction successful or not? ii) How can you give that error message to user?
3 members in a pf.how we read 3 members without using ovrdbf.using rg pgms....
i want to improve my english vocab for racking campus written exam plz tell me best book for prepration......
What is the meaning of client-server application. The purpose of Client-Server Application. with description.
I HAVE DONE TESTING TOOLS COURSE,NOW I AM FRESHER,I AM NOT GETTING ANY CALLS,I WANT TO DO THE PROJECT ,WHERE I HAVE TO MEET TO DO THE PROJECT,I AM GOING WITH FAKE EXPERIENCE,SO WHAT I HAVE TO DO.
