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
- 3799 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 select all columns of all rows from a table in oracle?
How to write a left outer join with the where clause in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the sql query to concatenate column values from multiple rows in oracle?
What is recovery manager in Oracle?
What is a nested table and how is it different from a normal table?
what is the difference between data migration and production migration.
How to speed up webrick?
How oracle handles dead locks?
What is difference between cartesian join and cross join?
types of indexes and the rationale behind choosing a particular index for a situation.
How to convert characters to times in oracle?
What is system global area (sga) in oracle?
How to find out what oracle odbc drivers are installed?
