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
- 4913 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 to convert characters to numbers in oracle?
What is memory advisor in Oracle?
Hi Can any one tell me what are the API's used in requisition import.
What is a Data Segment ?
How do we get field detail of a table?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
What are Schema Objects ?
what is integrity constrains?
what is the syntax of INSERT command?
When does a Transaction end ?
How to assign data of the deleted row to variables?
what is the syntax of CREATE command?
Oracle General 
