Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 4749 Views
- I also Faced
- E-Mail Answers
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
What is an oracle database table?
What happens if recursive calls get out of control?
How a database is related to tablespaces?
What is bind variable in oracle 11g?
various types of hints and their usage
How to load data through external tables?
How to use "in" parameter properly?
How to synchronize 2 schema's objects?
Can select statements be used on views in oracle?
How to drop an index in oracle?
What are the restrictions on external table columns?
What types of joins are used in writing subqueries?
Will you be able to store pictures in the database?
How to bring a tablespace offline?
How can we delete duplicate rows in a table?
