1.What is bulk collect?2.What is instead trigger3.What is the difference between Oracle table & PL/SQL table?4.What R built in Packages in Oracle?5.what is the difference between row migration & row changing?
Latest Answer: create table new_employeesas (select e.employee_id, e.first_name, e.last_name, d.department_name, d.department_id,c.location_id, c.city from employees e, departments d, locations cwhere e.department_id = d.department_idand d.location_id = c.location_id); ...
I want to tune the below query for performance issue can u please help me the query is SELECT DISTINCTA.BUSINESS_UNIT,A.CUST_ID,A.ASOF_DTFROM PS_ITEM_ACTIVITY A WHERE A.BUSINESS_UNIT = '1100G'AND A.ITEM LIKE 'OA%' AND A.PO_LINE = 0AND A.ENTRY_REASON 'CLEAR'AND A.ASOF_DT > '01-JAN-1900'AND A.USER1 = ' 'UNIONSELECT DISTINCTA.BUSINESS_UNIT,A.CUST_ID,A.ASOF_DTFROM PS_PENDING_ITEM A WHERE A.BUSINESS_UNIT = '1100G'AND A.ITEM LIKE 'OA%'
Suppose thr are 10 DMLs(insert,update,delete ) in the main section of the PL/SQL block .The exception in them is handled as a whole in the exception handling section .....The error may occur in any of this DMLs ,so how can we understand that which DML has failed ??
1)any one can tell me,suppose we have 1000 of records,ok.then we want to update only 500 records,how can we solve this problem?2)how many types of "explicit cursors" we have?
If there is an index including three columns A, B and C. And if we issue a query in which where clause uses only column B....will the index be useful??and what if the where clause only has coulmn A..will the index b useful??
Latest Answer: session variable can not be declared in package, variable declared in package are called global variables. create package mypack isnum number := 7;num2 number;end ;here num, num2 are global variable when ever you wnt to use them. you have to use ...
Latest Answer: define is use for predefine variable its depends on user. You can use char or number ...
Latest Answer: select max(sal) from emp a where &n = (select count(distinct sal) from emp where sal >= a.sal); ...
Hi Friends!! Can anybody answer what are the constraints on Mutating tables? How to remove the mutating errors in triggers? Urgent plzzzzzzzzzzzzzzzzThanks in Advance..Thanks&RegdsRamki,TCS
View page << Previous 9 10 11 12 [13] 14 15 16 17 18 Next >>
Go Top
