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
- 4748 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 |
What is the use of aggregate functions in oracle?
What is the use of oracle?
Difference between inner join vs where ?
How can I get column names from a table in oracle?
What are the major difference between truncate and delete?
What is a private synonym?
How to define a data field as not null?
What is literal?
What is a nvl function? How can it be used?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
query optmization techniques and quwry analyser+projects+ppts
What is oracle update statement with inner join ?
Oracle General 
