SELECT 
          ...
FROM    tbla a, (SELECT * FROM tblb WHERE ROWNUM <= 10) b

이것을

SELECT
          ...
FROM    tbla a, (SELECT * FROM dual CONNECT BY LEVEL <= 10) b

+ Recent posts

티스토리툴바