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 / ron

looks like you need to generate create / alter statements
from database data dictionary.

you need to run oracle package:
exec dbms_metadata.get_ddl(.....);

following the link for examples:

http://blogs.ittoolbox.com/database/solutions/archives/ddl-generationoracles-answer-to-save-you-time-and-money-7590

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to pass a cursor variable to a procedure?

541


What is a oracle database?

584


What is recovery manager(rman) backup in Oracle?

598


 How to use an oracle sequence generator in a mapping?

541


Explain a private synonyms?

607






What is index-organized table in Oracle?

548


Why packages are used in oracle?

524


How to delete a column in an existing table in oracle?

569


what is the difference between data migration and production migration.

1785


What is the difference between postgresql and oracle?

489


How can I create database in oracle?

543


What is an oracle function?

568


Difference between inner join vs where ?

583


How to create a table interactively?

532


What is the quickest way to fetch the data from a table?

542