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

What is asa in sybase?

1008

How to start sybase database in windows?

1198

What do you mean by mainframe connect tool in sybase?

945

What are the different types of (all page) locks in sybase?

863

What is a good example of a transaction in sybase?

1109

How to view the log files in sybase?

990

What measures are there to increase the db space?

959

How do you use workspace in sybase?

968

What are the advantages that you can get from mainframe connect in sybase?

908

How do I pipe the output of isql to a file in sybase?

937

Explain open server?

976

What is trace flag definitions in sybase?

987

What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

944

How do I open a sybase database?

1053

How would you lock a table in sybase? What text command will you use for it?

938