 Related Questions 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 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 : 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 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 ? Hi Guys,i have an interview question. can anyone help me reg this.i have a table called "phone" and filed as "phone number" and table have values like 2489078905,2345678909now i want the result as (248)9078905,(234)5678909 into another table called phone2. Read Answers (7) | Asked by : dev Hi How do I call procedures which have ref cursors as parameters and print the elements in the ref cursor in PL/SQL Developer ?I executed the following code in PL/SQL Developer : CREATE OR REPLACE PACKAGE EMP_PACK ASTYPE EMPCURTYP IS REF CURSOR RETURN EMP%ROWTYPE;PROCEDURE EMP_PROC( EMP_CUR IN OUT EMPCURTYP);END EMP_PACK;CREATE OR REPLACE PACKAGE BODY EMP_PACK ASPROCEDURE EMP_PROC(EMP_CUR IN OUT EMPCURTYP) ISBEGINOPEN EMP_CUR FOR SELECT * FROM EMP;END EMP_PROC;END EMP_PACK;/When I executed the following View Question | Asked by : Divya Hi 1.What is difference between procedure and function?1. procedure may or may not return values whereas function must return value2. we can call the function in the sql statements whereas we can't call the procedureExcept these two, is there any difference between these two.2. What is pl/sql table and what is use of it. In which case, we can use it3. What is ref cursor, what is the use of it.4.how the function will return multiple values. Pls give me with examples Hi all I wrote a procedure to send email via plsql procedure, It was compiled sucessfully but not working ....here is the code (actuly i added the dbms output like step1 ,step 2 to see in which step the control is going on )create or replace PROCEDURE send_test_messageIS mailhost VARCHAR2(64) := 'mail.cmcltd.com'; sender VARCHAR2(64) := 'akash.sharma@cmcltd.com'; recipient VARCHAR2(64) := 'lalit.mohan@cmcltd.com'; mail_conn utl_smtp.connection;BEGIN Tags : DBMS Hi,1. Iam looking for sample program for ref cursor. ref cursor can be associated with many select statements and we can use the ref cursor to return the multiple value from the procedure or function. Latest Answer : Hi,Let me answer your second questin first. Why ref cursor instead of %ROWTYPE.%ROWTYPE is used for fetches record/row of a single table.OR in case of columns of different tables then you have to create a RECORD and then used %ROWTYPE.But ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0