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

Explain the use of consistent option in exp command.

546


Explain what are the uses of rollback segment?

580


What is a data lock in oracle?

607


What is the difference between alert log file and tarce file ?

1630


How to create a table interactively?

556






How to best split csv strings in oracle 9i?

584


Explain the use of indexes option in imp command.

562


What are the benefits of ordbms?

619


What is oracle sid?

505


Explain the use of record length option in exp command.

554


What is the difference between translate and replace?

554


How to define a sub function?

662


Can we write dml statement in function in oracle?

632


how to do daily transactions with out sql* loader control file regesterd in apps?

1221


What is sequence?

622