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
- 4923 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 |
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
waht is the difference between primary key and super key?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What are the most common interview questions on ETL Testing for experience?
What is hot backup and logical backup?
types of indexes and the rationale behind choosing a particular index for a situation.
What is a server parameter file in oracle?
What are the original export and import utilities?
How to turn on or off recycle bin for the instance?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
What are the various types of snapshots ?
What types of joins are used in writing subqueries?
Oracle General 
