![]() Related Questions 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 Can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures? 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 Latest Answer : no difference ... Read Answers (9) | Asked by : Suyog How do i write a function that returnsmore than 1 records from a tablefor example in sql server there is a solution as create function f1() return table asselect * from emphow do i do the same in oracle. plz help How to return multiple records from procedure?e. g. I fired a select query and I want to retun a result to ? I have written a procedure in which the cursor is fetching 2 lakh records. I would like to pass on these 2 lakh records as an in paramter to the other procedure. How can we achieve this logic? Read Answers (4) | Asked by : Srinivas Hi,We have to select some rows from a table using many conditions in the where clause. Then we have to write those selected rows to one flat file. I know that we can use UTL_FILE package to do this. Is there any better approach to do this?? Read Answers (5) | Asked by : Ritesh Hi all,thank u for ur answers.and i have an adjustment in this question.actually data is not present Hi all,thank u for ur answers.and i have an adjustment in this question.actually data is not present in a table, it's there in some file.For eg. "Data" is the file, it contains information: 2489078905,2345678909 and so on...table is also there "phone" with phoneno as a field but table is empty.now i want the result into table2.got it, Right!Let me know if u have any questions.thanks.dev Read Answers (2) | Asked by : dev Help me to write a procedure for:verify a table for record if it is exists need to update or else insert that record( using cursor write a procedure ) Read Answers (4) | Asked by : Srinivas
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||