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 Posted / 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 |
Post New Answer View All Answers
What are the different types of trigger and explain its various uses and functions?
How to get maxsal , minsal, ename department wise in single query
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is Virtual Private Database in Oracle?
What is blob data type in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to sort the query output in oracle?
How oracle handles dead locks?
State all possible different index configurations a table can possibly have?
How to create a stored function in oracle?
How would you change old and new values in an insert, delete and update triggers?
What are the various types of snapshots ?
Difference between cartesian join and cross join?
How to define a data source name (dsn) in odbc manager?
How many types of cluster table in Oracle?