Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Train_Database
oracle procedure example
function to check if reverse of a string s1 is a superstring of string s2.
Srinivas
bcom
Display the number value in Words
[Manutenção] Prova Supero - Oracle
Aufgaben laut Benutzer durchsuchen
max of 2(function)
1