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
- 3927 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 |
Define Transaction ?
What is oracle sid?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
How to view the tablespaces in the current database?
What is a cursor in oracle?
What is ordinary table in oracle?
What is the difference between sharding and replication?
Explain what are synonyms used for?
Explain the use of compress option in exp command.
Explain an index segment?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
What is the difference between formal parameters and actual parameters?
Oracle General 
