what is the syntax of ALTER command?

Answer Posted / sridevi

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

Is This Answer Correct ?    18 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an oracle tablespace?

691


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

639


What is a user account in oracle?

726


What is the oracle implicit cursor?

681


What is a cursor and what are the steps need to be taken?

677






What are a collation and state the different types of collation sensitivity?

644


what is meant by magic query

1858


What is proxy method?

626


Explain the different normalization forms?

673


How can we create the complete backup of data in the oracle.

1777


What are the different types of partitions in oracle?

582


How to use windows user to connect to the server?

616


What are the differences between primary key and unique key?

595


Give the various exception types.

630


How do I call oracle stored procedures that take no parameters?

653