• Skip to main content
  • Skip to primary sidebar
  • Home
  • Connect
  • Contact
  • About Us

BareFoot PeopleSoft

Oracle PeopleSoft Tips and Tricks

SQL

Tip 070: Additional SQL Functions

October 28, 2018

SQL | A miscellaneous collection of useful Oracle SQL functions.

Tip 059: Table Locks

May 21, 2018

SQL | Understanding table locks and setting an exclusive lock

Tip 056: Data Scrambling

May 21, 2018

SQL | Using the SQL ‘Random’ function to scramble sensitive data

Tip 049: Finding the Portal Location

March 21, 2018

SQL | Finding out the portal location for a component or page

Tip 047: Regular Expressions in SQL

March 21, 2018

SQL | Using regular expressions to carry out pattern matching

Tip 044: SQL Decode and Case Statements

March 21, 2018

SQL | Using the ‘Decode’ and ‘Case’ statements in queries.

Tip 021: Comma Separated List of Fields in a Record

March 21, 2018

SQL | Creating a comma-separated list of all the fields in a record

Primary Sidebar

Categories

  • Administration
  • Application Engine
  • BI Publisher
  • COBOL
  • Data Mover
  • PeopleCode
  • PeopleTools
  • PS Query
  • Security
  • SQL
  • Utilities

Copyright © 2023 Elimbah Consulting Ltd