what is the syntax of ALTER command?

Answer Posted / sandeep

alter table <table_name> add column <Data type of the column>;

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between formal parameters and actual parameters?

543


How a tablespace is related to data files?

581


Explain the use of Merge statement in oracle 11g

592


What is hot backup and logical backup?

606


What happens if you use a wrong connect identifier?

500






Explain what are the different type of segments?

576


How to define a cusotmer as a supplier in ORACLE R12

1726


How to create a new table by selecting rows from another table?

550


How to use attributes of the implicit cursor in oracle?

560


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2391


What are the four Oracle system processes that must always be up and running for the database to be useable?

589


Why does Oracle not permit the use of PCTUSED with indexes?

1950


How to load excel data sheet to oracle database

584


how to clone 9i Database on to 10g Database.

1822


What is an Oracle Instance?

685