i have a table and it has constraints and i want to get
"ALTER TABLE table_name
ADD CONSTRAINT constraint_name constraint type" this code
must be in string type
please help me
if you want, i can give more explainings

Answer Posted / dinesh a.

if table has already constraint then why you want to get
Alter table table_name "ADD" constraints


What do you want ? describe in detail

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

558


What are the extensions used by oracle reports?

579


Explain the difference between a procedure and a function?

561


How to drop an index?

548


What are the ansi data types supported in oracle?

523






How to export several tables together?

572


What is the disadvantage of User defind function?

1839


What is the difference between $oracle_base and $oracle_home?

589


Please explain oracle left join with an example?

589


List out the components of logical database structure of oracle database.

586


Explain the use of record option in exp command.

543


What is catalog in Oracle?

656


Give the various rollback segment states.

583


What is Undo Management Advisor in Oracle?

618


How to export your connection information to a file?

601