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
How to pass a cursor variable to a procedure?
What is a oracle database?
What is recovery manager(rman) backup in Oracle?
 How to use an oracle sequence generator in a mapping?
Explain a private synonyms?
What is index-organized table in Oracle?
Why packages are used in oracle?
How to delete a column in an existing table in oracle?
what is the difference between data migration and production migration.
What is the difference between postgresql and oracle?
How can I create database in oracle?
What is an oracle function?
Difference between inner join vs where ?
How to create a table interactively?
What is the quickest way to fetch the data from a table?