Oracle Apps Technical Stuff
Wednesday, October 2, 2013
Query to get the Concatenated Line Number on the Sales Order
›
SELECT oh.org_id , order_number , ol.line_number || '.' || ol.shipment_number ...
Friday, September 27, 2013
How to handle the Exception in FORALL statement 11G Feature
›
The below mentioned way of handling the exceptions for FORALL statement is available in Oracle 11g DB version. -- Temporary table...
Tuesday, September 24, 2013
How to Load Images Into BLOB Columns
›
1. Create a table as mentioned below. CREATE TABLE xx_load_images_into_blobs ( ID NUMBER, blob_col BLOB ); 2. Create a log...
Script to Create the Instance in Install Base and Creation of relationship With Other Instance In Install base
›
DECLARE x_instance_rec csi_datastructures_pub.instance_rec; x_ext_attrib_values ...
‹
›
Home
View web version