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


Please Help Members By Posting Answers For Below Questions

What are the different types of trigger and explain its various uses and functions?

746


How to get maxsal , minsal, ename department wise in single query

1308


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2015


What is Virtual Private Database in Oracle?

830


What is blob data type in oracle?

821


In what script is snap$ created? In what script is the scott/tiger schema created?

2475


How to sort the query output in oracle?

812


How oracle handles dead locks?

813


State all possible different index configurations a table can possibly have?

783


How to create a stored function in oracle?

832


How would you change old and new values in an insert, delete and update triggers?

772


What are the various types of snapshots ?

777


Difference between cartesian join and cross join?

769


How to define a data source name (dsn) in odbc manager?

770


How many types of cluster table in Oracle?

791