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
- 4163 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dinesh a.
if table has already constraint then why you want to get
Alter table table_name "ADD" constraints
What do you want ? describe in detail
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
How many types of synonyms in Oracle?
How to create a new user account in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
can any one help me with import/export options in oracle............
How to pass parameters to procedures in oracle?
Why do we use bulk collect in oracle?
What is meant by raw datatype?
What is the sql query to concatenate column values from multiple rows in oracle?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
Explain what are clusters?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
Oracle General 
