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

How do I bcp null dates in sybase?

846

How to remove row affected and dashes?

832

What is ceiling()?

897

What are the best monitoring tools for the sybase database?

761

You need to multiply all values of a single column. How would you do that?

810

How do I configure the burn factor in sybase?

831

How to swap a db device with another?

821

Explain locking. List its types.

856

What sybase central?

771

List the merits of index covering.

838

We have lost the sa password, what can we do?

811

Why not max out all my columns sybase?

787

A single operation is failing to escalate?

763

How do I open a sybase database?

899

Explain the difference between numeric and decimal data types in sybase.

816