What are the types of cursors apart from explicit and implicit cursors ? Explain when and where they are used ?
Latest Answer: There are only two types of cursors in oracle Pl/sql.1. Implicit cursors2. Explicit cursors We can define an explicit cursor as static or dynamic (REF CURSOR). The difference between these two is 1. ...
SELECT APE.DAT_INSERT_DATE as "Payment Entry Date", Case when APE.TXT_INTERMEDIARY_CD is null or APE.TXT_PAYER_CUSTOMER_ID APE.TXT_INTERMEDIARY_CD then (Select TXT_CUSTOMER_NAME from GENMST_CUSTOMER
Latest Answer: create or replace procedure sql_to_procedure as declare cursor c1 is SELECT APE.DAT_INSERT_DATE as "Payment Entry Date",APE.TXT_INTERMEDIARY_CD AS "Intermediary ID",APE.TXT_PAYER_CUSTOMER_ID as "CustomerID/Payer ID",TXT_CUSTOMER_NAME ...
Latest Answer: Yes using pragma autonomous_transaction as per example below for commit.we have two table employee and employee_bak of same structure (empid, emp_name, location, manager_id)--autonomous procedure will insert value in employee_bak, procedure is getting ...
When a table is in state of transition it is said to be mutating. eg :: If a row has been deleted then the table is said to be mutating and no operations can be done on the table except select.
Latest Answer: Mutate means chage. Mutating table is a table that is being modified by update, delete or insert statement. ...
Char(20) = 'name'
varchar2(20)='name'
When comparing these two values, are the spaces padded in char are considered or not? Are both values equal?
Latest Answer: Yes you can use commit or rollback in exception block;select * from test123;A----------51
Declare s varchar2(2); Begin update test123 set a = a+10; select a into s from test123 where a=20; exception when others then rollback; dbms_output.put_line('test'|| ...
Latest Answer: Using wrap utility we can encrypt source code of a function to byte code (Not a readable format). Becareful there is no decrypt utility to convert source code back to ascii format. if you aim is just ...
Latest Answer: The purity level defines what structure the function reads or modifies.the types of purity level:1)wnds--write no database stage I.e the function does not modify any database ...
Write sample code that can create a hierachical set of data without using a start with and connect by clause in PL/SQL
Latest Answer: Both are same. Right outer join returns all the reocrds that satisfy the join condtion + rest of the records from right (or second) table. ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
