Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4368 Views
- I also Faced
- E-Mail Answers
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 retrieve data from an explicit cursor?
How to check the oracle tns settings?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain the use of ignore option in imp command.
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is a tns file?
what are bitmap indexes? How does they work?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Who developed oracle & when?
What is a system tablespace?
How to pass parameters to procedures?
What types of joins are used in writing subqueries?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to start your 10g xe server?
How many types of database triggers exist?
