PL/SQL Block

Formatting PL/SQL code in SQL DEVELOPER

Hi Experts, I would like to know some keyboard shortcuts and clever formating on PL/SQL codes in SQL developer Pls hlp me out with some hints for this.. thanks n advance

PL/SQL

Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and...

INSTR ()

Hi Experts, My test case s working fine for the INSTR() but the same if i use in implemenation its not raising the error giving below the pseudo code IF INSTR (v_lm,pcd,1,1) = 1 OR INSTR(vlm,pc,1,1) = 1 OR INSTR(vlm,pcn,1,1) = 1 THEN raise_application_error(...

How to implement Sleep logic not using sleep() need customized

Hi Experts, I need to implement a sleep logic in a loop i need to check for SELECT/INSERT stm if it s locked by other user i will go to sleep mode then back to earlier savepoint position eg savepoint x; INSERT/SELECT i need to check for 10 times each time sleep is for 1 sec i applied...

PL/SQL: How to handle OUT Parameter during INSERT

HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

PL/SQL: How to use EXCEPTION statement before INSERT?

Hi Experts how to use EXCEPTION statement before INSERT stm in PL/SQL Block Please help me with syntax or format is this option possilbe as well?

PL/SQL: How to check that parameter is case-sensitive?

Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,'[:lower:]','C'); as well vpos ;= REGEXP_LIKE(p_email_address,'[^[:lower:]]','C') But both says wrong type as error and p_email_address is a parameter of procedure...

How to perform Unique check in PL/SQL

Hi Experts, I need to perform a Unique check on existing record in table X for combination of field in my PL/SQL block before inserting new record into Table XX Table XX for combination of the following field list (X_ID, St1, St2, City, CP, PS, XNAME, C_ID) AND DISPLAY MODE = 0 How can i do this...

How to make or check the attribute (location) in PL/SQL block?

Hi Experts, How to make check the attribute (location) not taking the value same as city(attribute) or country(attribute) in Pl/SQL block Thanks for the help