I have to replace a particular value say "_" with a space in particular column of a table, kindly provide me the query how to achieve this.
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?
Latest Answer: Pre-query trigger fires only ones while post-query trigger fires each time.the Post-Query trigger fires each time Form Builder fetches a record into a block.RegardsPawan Ahuja ...
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 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
What are the types of triggers in PL/SQL and in forms?in pl/sql, My guess is:row level, statement level,before,after,insert,update,deleteare there any triggers i missed, let me know?Thanks in advance.
If anyone asks in interviews, about "what are the types of triggers" then my ans is likerow level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.and can i even mention instead of triggers,database trigger and schema triggers
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 )
What is differance in defining constraints at table level and column level what is main pupose of making constraints at table level....pls ans me
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
