Showing posts with label PL/SQL. Show all posts
Showing posts with label PL/SQL. Show all posts
Tuesday, June 9, 2015

Oracle Apps : Apply AP Invoice Hold using API

›
The hold codes can be extracted from query below. SELECT *   FROM ap_hold_codes  WHERE hold_type = 'INVOICE HOLD REASON'; Belo...
Monday, April 13, 2015

How to use plsql collections in select statment

›
Step 1 : Declare Collection type Globally For Example:  Test_Coll can be declared globally as "TYPE  Test_Coll IS TABLE OF INTEGER...
Friday, August 22, 2014

Ref Cursor in Oracle PL/SQL

›
A REF CURSOR is basically a data type.  A variable created based on such a data type is generally called a cursor variable.  A cursor varia...
Wednesday, August 20, 2014

Nested Table in PL/SQL

›
Nested Table:   Nested table is a collection of rows, represented as a column within the main table. For each record within the main table...

Merge, Exists and Non-Exists in PL/SQL

›
Exists: ------------- The EXISTS condition is considered "to be met" if the subquery returns at least one row. The syntax fo...
Tuesday, August 19, 2014

Where Current of : PL/SQL

›
WHERE CURRENT OF clause is used in some UPDATE statements. The WHERE CURRENT OF clause is an UPDATE or DELETE statement states that the ...

Rank Function in PL/SQL

›
Rank : In Oracle/PLSQL, the rank function returns the rank of a value in a group of values. The rank function can be used two ways - a...
Thursday, July 10, 2014

Variants of NVL and Branching techniques in SQL

›
NVL NVL gives you the flexibility to choose an alternate path if your current value is null. For Example Select NVL(dept,'Bench...
Wednesday, July 2, 2014

RECORDS in PL/SQL

›
Introduction Record is a data-structure which can hold differnt type of datatypes. Record can be imagined as a database table with multi...
Friday, June 27, 2014

Create Custom Queue in Oracle and use as pre-queue to other queue

›
In our scenario we setup a JMS queue which will be used a pre-queue to ECX_INBOUND queue. Below are the steps to achieve the same. Queue...
Saturday, May 17, 2014

Few Examples on Dynamic SQL

›
Dynamic SQL ------------------------------------------------------------------ DECLARE v_table_name varchar2(100) := 'test_dept...

Convert CSV to Rows in Oracle

›
Query SELECT substr(csv,               instr(csv,                     ',',                     1,                     lev) +...