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 the features of sybase.

906

What is replication server in sybase?

833

Can I run any transact-sql command on a partitioned table in sybase?

846

What is the difference between db-lib and ct-lib in sybase?

832

Differentiate between ltm and repagent?

992

Explain coalesce.

942

What do you mean by mainframe connect tool in sybase?

898

Is sybase sql?

894

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

926

How would you replicate col = col + 1 in sybase?

1056

How do I correct time slice -201?

953

What is replication in sybase?

885

How to change varchar(m) to varchar(n) in sybase?

962

How do I open sybase control center?

956

How to connect to sybase database from linux?

992