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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the usage of synonyms?

569


How do we create privileges in oracle?

572


What is a nvl function? How can it be used?

547


Can we store images in oracle database?

535


What is varray?

576






What is snapshot is too old? Give and example for better understand.

1086


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?

1452


What is a cursor in oracle?

633


Explain rename?

535


How to call a stored function in oracle?

561


List the types of joins used in writing subqueries?

562


How to use "in out" parameter properly?

607


How to drop an index?

533


What are the data types in oracle?

541


What is Segment Advisor in Oracle?

654