what is the syntax of ALTER command?

Answer Posted / sridevi

alter table <tablename> add column(col.name(size))

Is This Answer Correct ?    17 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is analyze command used for?

582


What would you do with an in-doubt distributed transaction?

1474


What is the purpose of tables, private synonyms and public synonyms in Oracle?

593


Explain the use of log option in exp command.

539


Why is oracle used?

557






Explain an exception?

572


Which environment variables are absolutely critical in order to run the OUI?

1664


Design database draw er diagram for a certain scenario ?

4105


Where do you use decode and case statements?

556


What is an index associated with a constraint?

554


Can you tell me how to add new column in existing views?how?How is possible?

942


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1832


How to upsert (update or insert into a table)?

541


what is insert all statement in sql

5523


What is the Tune Query

1849