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
- 4857 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
How to see free space of each tablespace?
can u plz provide me oca sql dumps please i need them
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to create id with auto_increment on oracle?
Are truncate and delete commands same? If so why?
What are triggers in oracle?
what are bitmap indexes? How does they work?
How data locks are respected in oracle?
Explain temporal data types in oracle
How to define an anonymous procedure with variables?
What are the restrictions on external table columns?
What are the different types of database objects?
Explain the use of rows option in imp command.
In the oracle version 9.3.0.5.0, what does each number shows?
What is materialized view in Oracle?
