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

what is the syntax of ALTER command?

Question Posted / sandeep

8 Answers
14115 Views
I also Faced
E-Mail Answers

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

How to change user password in oracle?

1029

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2277

What is oracle rownum?

954

What is the data pump export utility?

1084

How do I connect to oracle database?

1121

What is the difference between view and materialized view in Oracle?

1156

What is a directory object?

1099

What is the difference between alert log file and tarce file ?

2172

How to import one table back from a dump file?

1025

Please explain drop constraint oracle?

1112

What is the best way to do multi-row insert in oracle?

1067

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1950

What is set operator oracle?

983

What is a database table in oracle?

1023

What is archive log in Oracle?

1134