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
- 4362 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 |
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
What is difference between SUBSTR and INSTR?
What is self-referential integrity constraint ?
Is truncate autocommit in oracle?
What are the arithmetic operations?
How can I see all tables in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to write a left outer join with the where clause in oracle?
Explain rename?
How to resolve the ORA-39133 error in Oracle?
Explain the use of record length option in exp command.
how can we write trigger in trigger???????? can we write one trigger on two table???
Oracle General 
