Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
0607-3
SELECT VAL , GRP_NO , ST , COALESCE(ED, ST) ED , CFR FROM ( SELECT COLUMN_VALUE VAL FROM TABLE( SYS.DBMS_DEBUG_VC2COLL( 1, 2, 3, 5, 6, 9)) ) MATCH_RECOGNIZE ( --partition by num ORDER BY VAL MEASURES match_number() AS GRP_NO , STRT.VAL AS ST , LAST(IN_SEQ.VAL) AS ED , CLASSIFIER() AS CFR --ONE ROW PER MATCH ALL ROWS PER MATCH PATTERN (STRT IN_SEQ*) DEFINE IN_SEQ AS (VAL = PREV(VAL)+1) ) \\
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
get circle params
scott
Oracle Test1
sss
PL/SQL Control Statements
create table
DBMS
DECODE() example
function to check if reverse of a string s1 is a superstring of string s2.
Emp
stackse - search stackoverflow differently
Please log in to post a comment.