How to write a test case in PL/SQL
Hi Experts, How to write a test case in PL/SQL to check whether the parameter of a procedure (eg email iddress) takes only lower case ,i did this way in my procedure If(emailadd) <> lower(emailadd)then raise_app_error_ But this can be checked n test case please guide me with pseudo code thanks n advance

Answer Question   |  January 9, 2009  10:59 AM
Oracle SQL, PL/SQL, Procedural Language/Structured Query Language

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 [...]

Answer Question   |  December 10, 2008  9:05 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL block, PL/SQL Unique Constraints, Procedural Language/Structured Query Language

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

Answer Question   |  December 16, 2008  7:49 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL attributes, PL/SQL block, PL/SQL Table, Procedural Language/Structured Query Language