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 Why would you want to combine sub-queries in Oracle SQL? There is some performance gains that could help your query run faster and be more efficient. Separate Sub-Queries Many SQL…
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…