Technical Blog

Pages

▼
Showing posts with label Stragg. Show all posts
Showing posts with label Stragg. Show all posts
Feb 21, 2009

Instead of Stragg /// Allow Duplicate

›
SELECT deptno, LTRIM(SYS_CONNECT_BY_PATH(ename, ','), ',') employees FROM ( SELECT deptno, ename, ...
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
Powered by Blogger.