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
- 5024 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 system global area (sga) in oracle?
What are the differences between date and timestamp in oracle?
Why should I use oracle database?
How to unlock the sample user account in oracle?
Can I create users through internet explorer in oracle 10g?
What is a trace file and how is it created in oracle?
How to login to the server without an instance?
How to delete a user account in oracle?
How do I uninstall oracle 11g?
How to bring a tablespace offline?
How to write numeric literals in oracle?
How to select an oracle system id (sid)?
How to drop a stored function?
interview questions with answer for cts
In oracle there is column command, how will you explain that?
