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
- 4383 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
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What are the differences between char and nchar in oracle?
How to join two tables in a single query using oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Explain overloading. Can functions be overloaded?
What is the difference between view and materialized view in Oracle?
Explain the function of optimizer in oracle?
What is the difference between substr and instr?
Explain what are the advantages of views?
What happens to the current transaction if the session is killed?
How to define a variable of a specific record type?
What is the difference between postgresql and oracle?
How to store only time; not date and time?
Can you drop an index associated with a unique or primary key constraint?
