 Related Questions Latest Answer : Cursor is a private Sql area which is used to execute sql statements and store Processing information, Where as Refcursor is a data structure which points to an object which inturn points to memmory LocationThe advantage Refcursor over Normal Cursor is1.We ... Latest Answer : By using cursor parameters we can pass the value dynamically. So that cursor can fetch data as per parameter ... Read Answers (4) | Asked by : Kishorebabukm What is cursor? Explain the types of cursor and write one implicit cursor program to check how many records deleted from table? Read Answers (6) | Asked by : indranil What is the Scalar Data type in PL/SQL?what is the forward decleration in packages?what is the usage What is the Scalar Data type in PL/SQL?what is the forward decleration in packages?what is the usage of IN,OUT,INOUT parameters in Procedures or functions? Read Answers (5) | Asked by : chiranjeevi reddy Hi,i want to know that,Will the functionality of these two statements:EXEC SQL SET TRANSACTION READ ONLY END-EXECEXEC SQL SET TRANSACTION READ WRITE END-EXECare same as “EXEC SQL SET TRANSACTION REPEATABLE READ END-EXEC”Give me the replacement for the above 2 sql statements.thanks in advance,rashmi Read Answers (1) | Asked by : rashmi Hi, in Cursors this is the Scenario.if i am manipulating the data of a table which has 10 records,i need to go to the 5th record.how is it possible?What is the Exact usage of Ref Cursor? Read Answers (1) | Asked by : murthy Latest Answer : %type will use for to define at column level.%rowtype is used to define for one or more than one columns ( like row or record or tuple ) means its user define type which hold one or more than one columns along with it. and generally it used with Cursor. ... Can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures? Latest Answer : Ref cursor is like a pointer to the cursor variable which is opened at the servecr side and pass the data as a whole and not one by one . ... Latest Answer : Hi,Use the V$OPEN_CURSOR view to know how many cursors are currently open in the database.Guna Sagar Challa ... Read Answers (1) | Asked by : Amitava
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
