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
- 4863 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
5. Which of the following can you do with DB2 Express- C? Query databases with SQL Query databases with XML using XQuery and XPath Use SQL in Xquery and Xquery in SQL All of the above
When will you use shell script/Perl ahead of C/C++?
How do i find out the number of parameters passed into function?
how many types of operating system are avaliable?
How can we develop a multi-tier application in Java?
along with oracle which language will be beneficial to have knowledge with,java,.net,since i m doing oracle have appeared for 8th sem BEIT,plz suggest
what is technical system, business system, logical system in sap pi7.0
in network security,how we identified threat?some one say we found threat according to it's signature,but how we get signature or pattern of the virus?
how to study PHP my own? i reffered many sites.. but as being a fresher i couldnt follow those... which site will be the best one?
how to convert infix expression to prefix expression?
design a counter with the following repeated binary sequence: 0, 1, 2, 3, 4, 5, 6, 7, 8 using JK Flip Flop.
How to know we are in home page of a web application using QTP
Iam using Microsoft Visual Studio to create a system for mobile store I want to know how to calculate mobile price that the customer buy and how to reduce quantity from the data base that we have for mobile .And also how to calculate revnue for each mobile and revnue for the total mobile
You are given some denominations of coins in an array (int denom[])and infinite supply of all of them. Given an amount (int amount), find the minimum number of coins required to get the exact amount. What is the method called?
5. How do you round the addition or subtraction of two numbers in assembler?
