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
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
6. Display the client name and order date for all orders using the traditional method.
Please explain oracle left join with an example?
What is a sub query? What are its various types?
How to test null values?
Can you create a synonym without having a table?
How to start instance with a minimal initialization parameter file?
What are the parameters that we can pass through a stored procedure?
How to see free space of each tablespace?
What is a table index in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Give the different types of rollback segments.
Is oracle a language?
Is java required for oracle client?
How to invoke the original export import utilities?
How to define a cusotmer as a supplier in ORACLE R12