Technical Blog
Pages
(Move to ...)
Home
Oracle DBA
ERP
Oracle Apps
Data Warehouse
Java
UNIX
Hadoop
JOBS4U
▼
Showing posts with label
extract()
.
Show all posts
Showing posts with label
extract()
.
Show all posts
Oct 29, 2014
Some Good SQL
›
Query to convert comma separated values into rows with test as (select '1,2,3' col1 from dual) select regexp_substr(col1, ...
Feb 27, 2009
Oracle Text - Part 2
›
Oracle Text offers the CTX_CLS.CLUSTERING package for building clusters. Optimizer Hints We can also "hint" the database optimizer...
Jan 9, 2009
To get diff data 's of similar id in a row
›
----------- create or replace type string_agg_type as object ( total varchar2(4000), static function ODCIAggregateInitialize(sctx IN ...
›
Home
View web version