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
- 3176 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 |
Can select statements be used on views in oracle?
What are the differences between date and timestamp in oracle?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
How to convert a date to char in oracle? Give one example.
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
what is pragma?
What is a Temporary Segment ?
How to revoke create session privilege from a user in oracle?
What is the dynamic sql in oracle?
Explain an index segment?
Why does oracle 9i treat an empty string as null?
What is an oracle?
Oracle General 
