a little philosophy in code
Public Synonyms By creating a Public Synonym you allow the user to reference the table name without using the schema owner prefixed on the record name (i.e. SYSADM.PS_VENDOR). This also eliminates the need to perform…
Combine Sub Queries in Oracle PL/SQL Separate Sub Queries Most of us do this when we need the most effective date with the most effective sequence.
1 2 3 4 | SELECT * FROM PS_SOMETABLE S1 WHERE EFFDT = (SELECT MAX(EFFDT) FROM PS_SOMETABLE S2 WHERE S1.EFFDT = S2.EFFDT) AND EFFSEQ = (SELECT MAX(EFFSEQ) FROM PS_SOMETABLE S2 WHERE S1.EFFSEQ = S2.EFFSEQ) |
Combined Sub Queries
1 2 3 | SELECT * FROM PS_SOMETABLE S1 WHERE (EFFDT, EFFSEQ) = (SELECT MAX(EFFDT), MAX(EFFSEQ) FROM PS_SOMETABLE S2 WHERE S1.QUALIFIER = S2.QUALIFIER) |
This reduces the number…
What is a PeopleSoft Application Package? The top most level of an Application in PeopleSoft is the Application Package. An Application Package is a container for one or more Application Classes. Application Packages should only…