 Related Questions How to query to know, that dbms_rowid package contains ROWID_OBJECT, rowid_block_number ,etc procedures or functions in it. Latest Answer : no difference ... Read Answers (9) | Asked by : Suyog How can i get the procedure's, function's name from a package if it is wrapped(both spec & body). Read Answers (2) | Asked by : biswajit 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 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 What is mutating trigger? How do you resolve it?If a trigger body is trying to update dependent tables, will it get a mutating error? Read Answers (9) | Asked by : be17be Latest Answer : right click on package and choose [execute]elseexecute package_name; ... Latest Answer : Yes thats true...It will be private. ... What is the difference between a package and a module? Latest Answer : Module is a collection of Package ... User Interface accepts the Employee information and this data needs to be compared with the existing data and the differences needs to be populated through a Pl/SQL table.Create a type (EMP_DATA) to populate
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
