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

How to add a new column to an existing table with a default value?

797


What are the uses of synonyms?

858


What is pragma autonomous transaction in oracle?

793


How to add a new column to an existing table in oracle?

871


Why should I use oracle database?

773


How do I use unicode codesets with the weblogic jdriver for oracle driver?

806


How do I uninstall oracle client from windows?

764


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

813


How to assign values to data fields in record variables?

797


What are the numeric comparison operations?

875


How much memory your 10g xe server is using?

838


Explain oracle 12c new features for developers?

788


How to create a new table by selecting rows from another table?

849


Explain the types of exception?

873


How can I introduce multiple conditions in like operator?

760