alter table <table name> modify (columnname newdatatype (size))

what is the syntax of ALTER command?

Question Posted / sridevi

Answer Posted / sridevi

alter table <table name> modify (columnname newdatatype
(size))

Is This Answer Correct ?

18 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How many types of synonyms in Oracle?

1121

how can we store any pdf file in oracle

2164

What is set operator oracle?

978

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1661

How can I introduce multiple conditions in like operator?

986

How to check the server version in oracle?

1092

What is where clause in oracle?

1026

Why is oracle so popular?

994

How to pass parameters to procedures?

1034

Difference between open_form and call_form in oracle.

1158

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4519

How to unlock the sample user account in oracle?

1016

interview questions with answer for cts

2581

What is difference between sid and service name in oracle?

956

What is a package in oracle?

1100