WITH WITH_IND_COLUMNS AS ( SELECT TABLE_OWNER, TABLE_NAME, INDEX_OWNER, INDEX_NAME , MIN(CASE WHEN COLUMN_POSITION = 1 THEN COLUMN_NAME || ' ' || DESCEND END) || MIN(CASE WHEN COLUMN_POSITION = 2 THEN ' + ' || COLUMN_NAME || ' ' || DESCEND END) || MIN(CASE WHEN COLUMN_POSITION = 3 THEN ' + ' || COLUMN_NAME || ' ' || DESCEND END) || MIN(CASE WHEN COLUMN_POSITION = 4 THEN ' + ' || COLUMN_NAME || ' ' || DESCEND END) || MIN(CASE WHEN COLUMN_POSITION = 5 THEN ' + ' || COLUMN_NAME || ' ' || DESCEND END) || MIN(CASE WHEN COLUMN_POSITION = 6 T...
댓글
댓글 쓰기