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
- 4070 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 |
Why do you create or replace procedures rather that drop and recreate.
can you explain performance tunning in oracle(sql,PL/SQL)
Can a formula column be obtained through a select statement ?
what is insert all statement in sql
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How do we know whether an index is created on a table ???
what is the difference between oracle enterprise edition and oracle express edition?
if i am using dml statement in function. then i am writing select statement what was the output
What is difference between cartesian join and cross join?
What are triggers?Where are they used?
What is RULE-based approach to optimization ?
Explain coalesce function?
Oracle General 
