How can we add a column to a table without altering the
same?
Answer Posted / sanjay rawat
In oracle,
1. take data in new table from existing table
2. add a new column in new table by using alter command
3. drop existing table
4. rename new table with existing table name
5. Check by select query
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is coalesce in sybase?
The secondary truncation point is on. How would you clear the logsegment?
Explain data cache?
What is the drawbacks of normalization?
What command helps you to know the process running on this port, but only su can run this command?
What do you mean by mainframe connect tool in sybase?
How would you check the long running transaction?
What is asa in sybase?
What sybase central?
Explain defncopy and it's usage?
Explain the features of sybase.
Differentiate between replication server and sql remote?
Is there any advantage of last_name varchar(50) over this last_name varchar(255)?
How do I connect to a sybase database?
What is cis and how can I use it?