How can we add a column to a table without altering the
same?
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 |
Post New Answer View All Answers
What is asa in sybase?
How to start sybase database in windows?
What do you mean by mainframe connect tool in sybase?
What are the different types of (all page) locks in sybase?
What is a good example of a transaction in sybase?
How to view the log files in sybase?
What measures are there to increase the db space?
How do you use workspace in sybase?
What are the advantages that you can get from mainframe connect in sybase?
How do I pipe the output of isql to a file in sybase?
Explain open server?
What is trace flag definitions in sybase?
What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?
How do I open a sybase database?
How would you lock a table in sybase? What text command will you use for it?