i must get table name, constraint type, constrain name with
using concads "||" and it must be in string type, then with
join processes i need code
please help immidiately
Answer / dinesh a.
Please create a query using user_cons_columns and
user_constraints table you will get
table_name||constraint_name||constraint_type
| Is This Answer Correct ? | 3 Yes | 1 No |
Why is oracle used?
How to connect ms access to oracle servers?
How to rename a column in an existing table?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is the difference between I and G in Oracle?
What is a cursor and what are the steps need to be taken?
What is meant by joins?
How to create a new user account in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain the use of record option in exp command.
how to find out second largest value in the table
Differentiate between pre-select and pre-query?