■예 1_1_1  ||  집합 생성 예제
SELECT SABUN
FROM INSA
WHERE SABUN LIKE '201212%'
ORDER BY SABUN DESC;

■예 1_1_2  ||  유한 집합의 생성 예제
SELECT SABUN
FROM INSA
WHERE SABUN BETWEEN '2012123101' AND '2013010501'
ORDER BY SABUN DESC;

■예 1_1_3  ||  프로젝트에 참여 정보 조회
SELECT T4.PJT_NAME, TS1.SABUN, TS1.CMP_REG_NO, TS1.CMP_NAME
,TS1.NAME, T3.SABUN PJT_SABUN
FROM  INSA_EMP_PJT T3, INSA_RECT_NOTICE T4,  
(
SELECT T2.SABUN, T1.CMP_REG_NO, T1.CMP_NAME
,T1.CMP_KIND, T2.NAME                              
FROM INSA_COMPANY T1, INSA T2                  
WHERE T1.CMP_REG_NO=T2.CMP_REG_NO
) TS1
WHERE T3.RECT_REG_NO=T4.RECT_REG_NO
AND TS1.SABUN=T3.SABUN
ORDER BY T3.RECT_REG_NO;

■예 1_1_1.4  ||  차집합의 예
SELECT SABUN, ENG_NAME, ADDR1, JOIN_GBN_CODE
FROM INSA
WHERE ADDR1 LIKE '서울%'
MINUS
SELECT I.SABUN, I.ENG_NAME, I.ADDR1, I.JOIN_GBN_CODE
FROM INSA I
WHERE REGEXP_LIKE(JOIN_GBN_CODE,'(CMP|FRE|CNT)');

■예 1_1_1.5  ||  VIEW 생성 예제
SELECT T2.CMP_NAME
,NVL(COUNT(T1.SABUN),'0') AS SAWON_COUNT
,MAX(T2.CMP_REG_NO) AS CMP_REG_NO
,MAX(T2.DIS_YN) AS DIS_YN          
FROM____ INSA T1, INSA_COMPANY T2
WHERE T1.CMP_REG_NO(+) = T2.CMP_REG_NO
GROUP BY T2.CMP_NAME
ORDER BY CMP_REG_NO;