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
- 4917 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 |
Describe the types of sub query?
Describe an oracle table?
how to find the n'th highest salary from emp ?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
What is Data Block ?
Is oracle a language?
How to write a query with a full outer join in oracle?
What is concurrency in oracle?
How to write a left outer join with the where clause in oracle?
What is null value in oracle?
Explain what are synonyms used for?
How to create additional tablespaces for an new database?
Oracle General 
