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
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
please explain.. DB architecture ...
What is data block in Oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What are the execution control statements in oracle?
What is meant by recursive hints in oracle?
What is a dead lock in oracle?
What are the differences between char and nchar in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How do I recompile a procedure in oracle?
What do you mean by redo log file mirroring?
What is transport network substrate (tns) in oracle?
How to define a sub function?