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
- 4156 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
What is transport network substrate (tns) in oracle?
What is procedure overloading in oracle?
How to count groups returned with the group by clause in oracle?
what are archived logs?
How to convert a date to char in oracle? Give one example.
How to loop through a cursor variable?
How would you go about verifying the network name that the local_listener is currently using?
How to define a variable to match a table column data type?
Is oracle a relational database?
How to check the server version in oracle?
How to connect to a local oracle 10g xe server?
How to check your oracle database 10g xe installation?
How to define an anonymous procedure with variables?
What is snapshot is too old? Give and example for better understand.
What is ADDM Advisor in Oracle?
