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
- 4905 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 SQL access advisor in Oracle?
Is primary key indexed by default in oracle?
How to define default values for formal parameters?
How to get the Installed Oracle Version Information ?
List the various oracle database objects?
what is IDE,DMV in sql server?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the scope of a local variable?
How do I recompile a procedure in oracle?
What is the maximum number of triggers that can be applied to a single table?
What language does oracle use?
What is tns name?
How to rename a column in an existing table?
What are the tools for Oracle ?
What are the components of logical database structure in oracle database?
