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
- 4368 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
Compare and contrast between sql and sql server and explain its various functions?
How to create a table in a specific tablespace?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is data file?
How to delete a column in an existing table?
What are the numeric comparison operations?
How to convert times to characters in oracle?
What privilege is needed for a user to create views in oracle?
How to use "if" statements on multiple conditions?
How to loop through a cursor variable?
How to use an explicit cursor without open statements?
How to load excel data sheet to oracle database
can u plz provide me oca sql dumps please i need them
Why do you use stored procedures and state some of its disadvantages?
