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
- 4493 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
What is the difference between a hot backup and a cold backup in oracle?
Why do you create or replace procedures rather that drop and recreate.
How does Oracle guarantee data integrity of data changes?
How to manage transaction isolation level?
Can you have more than one content canvas view attached with a window ?
What do you mean by a tablespace?
How to select some rows from a table in oracle?
How to create tables for odbc connection testing?
How to execute a stored procedure in oracle?
What do you mean by a deadlock?
What is recycle bin in Oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is an oracle function?
What is the usage of merge statement?
What is the best way to do multi-row insert in oracle?
