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
- 4770 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 an Oracle sequence?
What are the components of Physical database structure of Oracle Database?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What are the differences between number and binary_float in oracle?
What happens to the current transaction if the session is ended?
How to assign a table row to a record variable?
How to recover a dropped index?
Which is better Oracle or MS SQL? Why?
What is Trace File ?
How to restrict the duplicate records in table valuesets
What is connection pooling in oracle?
What are the restrictions on external table columns?
Oracle General 
