alter table tablename add(col1 datatype,col2 datatype...); alter table tab

what is the syntax of ALTER command?

Question Posted / guest

Answer Posted / guest

alter table tablename add(col1 datatype,col2 datatype...);
alter table tablenamemodify(col1 datatype,col2 datatype..);

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain an exception?

1064

Explain a private synonyms?

1097

How can Oracle users be audited?

1171

What is hot backup and logical backup?

1112

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3246

How to execute a stored program unit?

1128

How to define an explicit cursor in oracle?

1100

How to revoke create session privilege from a user in oracle?

1068

Please explain oracle left join with an example?

1095

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2091

What are the system predefined user roles?

1099

How to update a table row with a record?

1066

What is partitioned table in Oracle?

1268

What is catalog in Oracle?

1437

What happens if you use a wrong connect identifier?

1140