alter table <table name> modify(column definition...); alter table &

what is the syntax of ALTER command?

Question Posted / guest

Answer Posted / guest

alter table <table name> modify(column definition...);
alter table <table name> add(column definitions...);

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to check the server version in oracle?

620

Explain oracle’s system global area (sga).

634

How to assign values to variables?

588

How to check the oracle tns settings?

585

How to recover a dropped table in oracle?

616

What is a dead lock in oracle?

606

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1480

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1452

Why do we use bulk collect in oracle?

581

How to define a data field as not null?

640

How to export your own schema?

585

Can objects of the same schema reside in different tablespace?

598

What is a system tablespace?

614

What are the set operators union, union all, minus & intersect meant to do?

572

How to use attributes of the implicit cursor in oracle?

573