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

what is the syntax of ALTER command?

Question Posted / guest

8 Answers
13765 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about integrity constraint?

1077

what's query optimization and without use of IN AND Exist can we get another way data from query

2086

What are the numeric comparison operations?

1051

How do I know if oracle client is installed on windows?

953

How to bring a tablespace online?

994

When do you get a .pll extension in oracle?

1077

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1955

Why oracle is used?

995

How to insert multiple rows with one insert statement in oracle?

1020

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1788

What is a user role in oracle?

1064

What is PL/SQL ?

1902

How to start your 10g xe server from command line?

999

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1826

Compare and contrast between sql and sql server and explain its various functions?

917