Oracle Apps Technical Stuff
Saturday, March 30, 2013
SQL to Delete Duplicate Rows in a Table
›
DELETE FROM xx_table WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM xx_table GROUP BY col1, c...
Convert LONG datatypes to LOB's or Query on the Long Data type Columns
›
CREATE TABLE XX_LOG_STG(C1 NUMBER, C2 LONG) / INSERT INTO XX_LOG_STG VALUES (1, 'LONG data to convert to CLOB') / -- Inser...
Tuesday, March 26, 2013
Working with Nested Objects
›
DECLARE l_return_status VARCHAR2 (2000); l_msg_count NUMB...
Tuesday, March 12, 2013
API to Create the Extensible Attributes in TCA for Organization using API HZ_EXTENSIBILITY_PUB
›
This Scripts explains how to create the extensible attributes for the Organization In TCA Architecture using API HZ_EXTENSIBILITY_PUB. F...
‹
›
Home
View web version
