Mevlüt Becerikli

Önce bir tablo yaratalım;

CREATE TABLE tablo (sutun1 VARCHAR2(1), sutun2 VARCHAR2(1), sutun3 VARCHAR2(1));

Sonra sürun isimlerini user_tab_columns View’ inden elde edelim;

SELECT column_name FROM user_tab_columns WHERE table_name=’TABLO’

COLUMN_NAME
————-
SUTUN1
SUTUN2
SUTUN3

Şimdi bu sütunları yan yana elde edelim;

WITH test_data as (

SELECT column_name FROM user_tab_columns WHERE table_name=’TABLO’

)
SELECT *
FROM ( SELECT LTRIM(SYS_CONNECT_BY_PATH(column_name, ‘,’), ‘,’) AS deger
FROM ( SELECT column_name, LAG(column_name) OVER (ORDER BY column_name) AS prev_column_name FROM test_data )
START WITH prev_column_name IS NULL
CONNECT BY prev_column_name = prior column_name
ORDER BY 1 DESC
)
WHERE ROWNUM = 1

DEGER
———-
SUTUN1,SUTUN2,SUTUN3

Umarım faydalı olmuÅŸtur…

Ä°yi Çalışmalar…