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
- 4871 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
List the types of joins used in writing subqueries?
what is the scenario where you take the database to NoArchivelog mode?
How to drop a stored procedure in oracle?
How to define an oracle cursor variable?
Whether any commands are used for months calculation? If so, what are they?
What is procedure overloading in oracle?
How to get maxsal , minsal, ename department wise in single query
What is query image?
How to recover a dropped table in oracle?
Is there a combination of "like" and "in" in sql?
Why does for update in oracle 8 cause an ora-01002 error?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is oracle host variable?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Please explain drop constraint oracle?
