Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAI..

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

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAI..

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

Post New Answer

More Oracle General Interview Questions

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

3 Answers   Satyam,


how to get count of tables in particular database in Oracle?

3 Answers  


What are named parameters?

0 Answers  


Can a property clause itself be based on a property clause ?

1 Answers   Oracle,


How many categories of data types in oracle?

0 Answers  






1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,


What are the varoius components of physical database structure of oracle database?

0 Answers  


What is the use of aggregate functions in oracle?

0 Answers  


How different is ms access and oracle?

0 Answers  


What are the factors causing the reparsing of SQL statements in SGA?

2 Answers  


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers  


when loggined as SYSTEM,how to display all the users of database using sql query?

2 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)