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
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 |
In what script is snap$ created? In what script is the scott/tiger schema created?
Explain the use of control file?
How to create lov dynamically at runtime & attach to text field?
What is a sub query? Describe its types?
WHAT IS ecc 6.0
How to do paging with oracle?
What are the original export and import utilities?
How to unlock the sample user account in oracle?
How to install oracle database 10g xe?
What are a query and state the different types of queries and their uses?
What is Database Link ?
What is a table in oracle?