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 |
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
can anyody please send me the dump for Oracle 10g certifications for DBA path?
can a table has a column that has only view data and in other columns we can change data?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
What is a named program unit?
What different of iner joint & outer joint with example
How to filter out duplications in the returning rows using oracle?
What is the difference between substr & instr functions?
ABOUT IDENTITY?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
How to delete an existing row from a table in oracle?