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 use of file param in imp command?

644


What is Virtual Private Database in Oracle?

624


What are the types of partitions in oracle?

541


What is an oracle cursor variable?

611


What is a initialization parameter file in oracle?

584






Explain how are indexes update?

623


What is oracle database client?

557


How index is implemented in oracle database?

596


Differentiate between translate and replace?

630


How a tablespace is related to data files?

583


What is oracle rownum?

522


Why packages are used in oracle?

540


How to best split csv strings in oracle 9i?

590


Can a formula column referred to columns in higher group ?

2087


What is user managed backup in Oracle?

615