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 |
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
What is program global area (pga) in oracle?
What is SQL Tuning Advisor in Oracle?
Why do we use bulk collect in oracle?
What is a trace file and how is it created in oracle?
Can the default values be assigned to actual parameters?
In what script is snap$ created? In what script is the scott/tiger schema created?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to write text literals in oracle?
What is the difference between a user and a schema in oracle?
How do I reset a sequence in oracle?
Why we use bulk collect in oracle?