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
- 4446 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 do you mean by redo log file mirroring?
How to create a new user account in oracle?
What is the maximum number of triggers that can be applied to a single table?
What are data pump export and import modes?
Explain the difference between a procedure and a function?
How to define a specific record type?
List out the types of joins.
How to omit columns with default values in insert statement in oracle?
what is a Nested Loop join?
What are named parameters?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What are the general rules on data consistency?
How many categories of data types in oracle?
How oracle handles dead locks?
what is the difference between functional dependecy and multilevel dependency?
