Judy's Note

*해당하는 컬럼에 영문 대소문자 및 숫자가 포함된 데이터만 출력 SELECT * FROM ( SELECT '123' AS column_name FROM DUAL UNION ALL SELECT 'test' AS column_name FROM DUAL UNION ALL SELECT '한글' AS column_name FROM DUAL UNION ALL SELECT 'test123' AS column_name FROM DUAL UNION ALL SELECT 'TEST' AS column_name FROM DUAL UNION ALL SELECT '필터링 후' AS column_name FROM DUAL UNION ALL SELECT 'TEST123' AS column_name FROM DUAL UNION ALL..

WITH A_TB AS (SELECT 'I''m A' AS column_name FROM DUAL) , B_TB AS (SELECT 'I''m B' AS column_name FROM DUAL) SELECT A.column_name, B.column_name FROM A_TB A FULL OUTER JOIN B_TB B ON A.column_name = B.column_name ; *Oracle 9 이상 지원됨.