1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / ron

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


Please Help Members By Posting Answers For Below Questions

Why is oracle used?

557

How is it different from a normal table?

582

What is an Oracle index?

1177

What is Reduced List of Values?

1706

What is flashback in Oracle?

581




What is a database schema in oracle?

624

Name the various constraints used in oracle?

564

How to revoke create session privilege from a user in oracle?

559

Calculate difference between 2 date / times in oracle sql?

572

How can I see all tables in oracle?

542

What are group functions in oracle?

585

How to create an oracle database manually?

568

How to retrieve values from data fields in record variables?

569

What is the database name in oracle?

534

What is data block in Oracle?

618