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

Please explain oracle left join with an example?

591

How to write a query with a right outer join in oracle?

633

What are the different pseudo commands? Explain in general?

553

What is a database table in oracle?

580

What is the difference between formal parameters and actual parameters?

555

What is oracle data type?

565

Explain a data segment?

660

What is a nested table?

639

What is the difference between a primary key & a unique key?

597

What are the different types of modules in oracle forms?

568

What is system global area (sga) in oracle?

584

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1705

What are the general rules on data consistency?

597

Explain about integrity constraint?

617

How to find out what oracle odbc drivers are installed?

588