Oracle Apps Technical Stuff
Saturday, February 15, 2014
Function to get the list of Sting with covered with Quotes for individual columns in the List.
›
CREATE OR REPLACE FUNCTION get_not_in_clause ( p_list_of_columns IN VARCHAR2 ) RETURN VARCHAR2 IS ------...
Scrpt to get the Nth Occurrence of a string in the String
›
User below script to get the Nth occurrence of the string within a string separated by any string separator. Ex.. i have a string like ...
Wednesday, February 12, 2014
How to split comma separated string and pass to IN clause of select statement/ Create Comma Separated String using Select statement
›
SELECT COLUMN_NAME , COLUMN_ID FROM DBA_TAB_COLUMNS WHERE TABLE_NAME = :P_TABLE_NAME AND OWNER = :P_OWNER AN...
How to Search a String for a LONG/CLOB datatype column
›
CREATE OR REPLACE FUNCTION apps.xx_search_long( p_obj_type IN VARCHAR2 , p_obj_name IN ...
Thursday, February 6, 2014
Sample Scripts to Convert the Rows into One Column with seperator
›
SELECT header_id, RTRIM(EXTRACT(EXML,'//ordereditem/text()'),',') ORDERED_ITEM FROM (SELECT E.header_id, xm...
‹
›
Home
View web version