Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

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 ?

3681


what is the use MDM(Master Data Management)and meaning

2428


In loading programs into memory, what is the difference between load-time dynamic linking and run-time dynamic linking?

2213


How to call dll API sub routine in VB Form.

2363


why we need to take u?

2119


How to call a C++ function which is compiled with C++ compiler in C code?

1305


can we retrieve only integer/String type columns from a table,if yes how?

1935


Diff between IF and where ?

2051


define profiler???

2057


why not instantiating servet using new operator?

1967


< DL Compact > tag is used for

1957


how to fin top two miximum values in sql? not 2nd both max value of 1st and 2nd both have to find out

1921


how to data grid use in data bind?

2027


Diffrence between 2.0,3.0,3.5,4.0. versions of .net?

3160


9.Difference between even and odd signals?explain with the diagram?

3398