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
- 4922 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Give the various exception types.
How to update values on multiple rows in oracle?
How to convert characters to numbers in oracle?
Can we call procedure inside function in oracle?
Explain the use of rows option in imp command.
What is a Garbage Collection? and what is full recursive Garbage collection?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Explain overloading. Can functions be overloaded?
how the indexes are stored in the Oracle Database?
How many anonymous blocks can be defined?
What is the maximum limit on the number of columns in a table?
Hi Can any one tell me what are the API's used in requisition import.
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
what is the dual table in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
