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
- 3797 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is difference between truncate and delete?
How data locks are respected in oracle?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
How to assign query results to variables?
How many memory layers are in the shared pool?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
List the various oracle database objects?
How can Oracle users be audited?
What is partitioned table in Oracle?
how to insert data into partitioned table partition done by Range partition
What suggestions do you have to reduce the network traffic?
Oracle General 
