Skip to content

Programmer Philosophy

a little philosophy in code

  • Home
  • Projects
  • Reading List
  • About
Public Synonyms in Oracle PL/SQL
public

Public Synonyms in Oracle PL/SQL

  • by Andy
  • Posted on March 12, 2018May 20, 2021
  • in SQL

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…

Read More

Combine Sub-Queries in Oracle PL/SQL
combine

Combine Sub-Queries in Oracle PL/SQL

  • by Andy
  • Posted on March 8, 2018June 11, 2021
  • in SQL

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…

Read More

PeopleSoft Application Class Basics
house blueprint

PeopleSoft Application Class Basics

  • by Andy
  • Posted on March 5, 2018May 20, 2021
  • in PeopleSoft

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…

Read More

Recent Posts

  • Process Profile defined for user ID is invalid (65,111)
  • Reading Lists and Life Changes.
  • Calling App Engine from PeopleCode
  • Public Synonyms in Oracle PL/SQL
  • Combine Sub-Queries in Oracle PL/SQL

Categories

Archives

  • August 2019
  • February 2019
  • June 2018
  • March 2018
  • February 2018
  • January 2018
  • November 2017
  • April 2017
  • February 2017
  • January 2017
  • December 2016
  • October 2016
  • September 2016
  • June 2016
  • March 2016
  • December 2015
  • July 2015
  • June 2015
  • May 2015
  • February 2015
  • December 2014
  • November 2014
  • September 2014
  • June 2014
  • January 2014
  • October 2013
  • September 2013
  • August 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • October 2012
  • September 2012
  • June 2012
  • December 2011

Posts navigation

«Previous Posts 1 2 3 4 … 23 Next Posts»
Copyright © 2022 . All rights reserved.
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT