 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 Latest Answer : 1)Using DBMS_JOB package,we can schedule the job.There are number of built-in functions in that package to schedule a job.Ex:DBMS_JOB .SUBMITDBMS_JOB .RUN.2) Using DBMS_SCHEDULERTHIS I SYNTAX FOR CREATING JOBdbms_scheduler.create_job(ob_name ... Read Answers (6) | Asked by : kishorebabu 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 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 Can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures? How do you get the return values in pl/sql when u exec them be sides assigning the values to Bind variables Read Answers (1) | Asked by : srini 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 : Yes you can pass the whole select statement of the cursor dynamicaly, see ref_cursors.There is also a system package sys.dbms_sql which allows everything to make dynamically. ... Read Answers (5) | Asked by : sweety Latest Answer : First create a Trigger and with Procedure you insert records.The :new will take the new values.So use Triggers in Procedures. ... Read Answers (1) | Asked by : p
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
