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
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 |
Find all employees in Dept “Marketing”.
How to rename an index?
What are the database administrators utilities available?
What is meant by joins? List out the types of joins.
Explain the use of indexes option in exp command.
What are the composite date types in oracle?
What is oracle and what are its different editions?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
what are Triggers?
What is the difference between an Oracle Schema and an Oracle Instance?
how to do daily transactions with out sql* loader control file regesterd in apps?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?