In Oracle - create nother table with new column 2. insert complete data in

How can we add a column to a table without altering the
same?

Question Posted / devraj

Answer Posted / devraj

In Oracle - create nother table with new column
2. insert complete data into this
3. drop orignal table
4. rename the created table to orignal table

Is This Answer Correct ?

12 Yes

26 No

Please Help Members By Posting Answers For Below Questions

Explain bind cache?

942

Explain relationship between jdbc and sybase.

904

How can you change to get the decimal separator as comma instead of the decimal point (.)?

856

What is open server in sybase?

817

Is sybase relational database?

884

What do you mean by mainframe connect tool in sybase?

896

Explain update statistics.

854

What is replication server?

923

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

947

List the types of locking?

1001

Explain procedure cache?

957

What is the depth of triggers?

977

What is the role of replication server in sybase?

959

Which version of open client works with which ase in sybase?

917

What you need to do is issue an ase kill command on the connection then un-suspend the db?

935