Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Oracle SQL

Using functions in WITH clause in Oracle 12c

  • by Yogesh Pachpute
  • Posted on August 31, 2017August 31, 2017
  • Oracle SQL

The WITH Clause, or Subquery Refactoring If you haven’t heard of the WITH clause, let me take a moment to explain what it is. The WITH clause is a clause in SQL that allows you […]

Read More

How to Replace Special Characters in Oracle SQL

  • by Yogesh Pachpute
  • Posted on August 31, 2017August 31, 2017
  • Oracle SQL

Options for Replacing Special Characters In Oracle SQL, you have three options for replacing special characters: Using the REPLACE function Using the REGEXP_REPLACE function Using the TRANSLATE function Each of them has their pros and […]

Read More

Return multiple value from a function in oracle plsql

  • by Yogesh Pachpute
  • Posted on August 22, 2017August 22, 2017
  • Oracle SQL

Normally when we came across the difference between function and procedure, we say that function always returns value(e.g single) where as procedure may or may not. But we can use OUT parameter to return multiple […]

Read More

How to handle a single quote in Oracle SQL

  • by Yogesh Pachpute
  • Posted on April 4, 2017April 4, 2017
  • Oracle SQL

Problem: I have a column containing certain expressions stored as a text string which include single quotations, such as ‘missed transaction’ (INCLUDING the quotations) How can I use a where clause with such an occurrence? […]

Read More

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Cloud Enterprise Structure (2)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Cost Management (1)
  • Fixed Asset (23)
  • General Ledger (25)
  • GRC (6)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Cutover Tasks (1)
  • Oracle Cloud Fusion Financial (12)
  • Oracle Cloud Security (2)
  • Oracle Database (2)
  • Oracle Fusion HCM (10)
  • Oracle Fusion HCM Technical (5)
  • Oracle Fusion Technical (10)
  • Oracle Installations (3)
  • Oracle Inventory (2)
  • Oracle SQL (4)
  • Order Management (2)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (17)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • RMCS (1)
  • SubLedger Accounting (26)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Calendar

Calendar

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Jan    
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 35 other followers
    • Already have a WordPress.com account? Log in now.
    • Enterprise Resource Planning and Integrations BlogSpot
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar