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
- 5030 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dinesh a.
if table has already constraint then why you want to get
Alter table table_name "ADD" constraints
What do you want ? describe in detail
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
what is difference between table and view? where to use views? thanks in advance!
What is the usage of control file in oracle?
How to recover a dropped table in oracle?
How to use "out" parameter properly?
Why use resource manager in Oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to create a new oracle data file?
Explain about functional dependency and its relation with table design?
3. Display all the client numbers in the ORDER table. Remove duplicates.
what is dynamic SGA and static SGA
In the oracle version 9.3.0.5.0, what does each number shows?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
Oracle General 
