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
How to add a new column to an existing table with a default value?
What are the uses of synonyms?
What is pragma autonomous transaction in oracle?
How to add a new column to an existing table in oracle?
Why should I use oracle database?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How do I uninstall oracle client from windows?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to assign values to data fields in record variables?
What are the numeric comparison operations?
How much memory your 10g xe server is using?
Explain oracle 12c new features for developers?
How to create a new table by selecting rows from another table?
Explain the types of exception?
How can I introduce multiple conditions in like operator?