오라클(oracle) vs MSSQL vs 티베로(Tibero) 문법 비교

• 날짜 데이터 리터럴 사용:
  오라클: DATE '2023-11-17'
  MSSQL: CAST('2023-11-17' AS DATE)
  티베로: TO_DATE('2023-11-17', 'YYYY-MM-DD')

 

• 페이징 쿼리:
  오라클: SELECT * FROM (SELECT rownum AS rn, column1, column2 FROM table_name) WHERE rn BETWEEN start_row AND end_row
  MSSQL: SELECT column1, column2 FROM table_name ORDER BY column1 OFFSET start_row ROWS FETCH NEXT (end_row - start_row + 1) ROWS ONLY
  티베로: SELECT * FROM (SELECT ROWNUM AS rn, column1, column2 FROM table_name) WHERE rn BETWEEN start_row AND end_row

 

• 문자열 연결:
  오라클: SELECT column1 || ' ' || column2 FROM table_name
  MSSQL: SELECT column1 + ' ' + column2 FROM table_name
  티베로: SELECT column1 || ' ' || column2 FROM table_name

 

• NULL 값 처리 (COALESCE 또는 ISNULL):
  오라클: SELECT COALESCE(column1, column2) FROM table_name
  MSSQL: SELECT ISNULL(column1, column2) FROM table_name
  티베로: SELECT COALESCE(column1, column2) FROM table_name

 

• 현재 날짜 및 시간 가져오기:
  오라클: SELECT SYSDATE FROM DUAL
  MSSQL: SELECT GETDATE()
  티베로: SELECT SYSDATE FROM DUAL

 

• 문자열 길이 계산:
  오라클: SELECT LENGTH(column1) FROM table_name
  MSSQL: SELECT LEN(column1) FROM table_name
  티베로: SELECT LENGTH(column1) FROM table_name

 

• 문자열 대소문자 변환:
  오라클: SELECT UPPER(column1), LOWER(column1) FROM table_name
  MSSQL: SELECT UPPER(column1), LOWER(column1) FROM table_name
  티베로: SELECT UPPER(column1), LOWER(column1) FROM table_name

 

• 서브스트링 추출:
  오라클: SELECT SUBSTR(column1, start_position, length) FROM table_name
  MSSQL: SELECT SUBSTRING(column1, start_position, length) FROM table_name
  티베로: SELECT SUBSTR(column1, start_position, length) FROM table_name

 

• UNION 연산자 사용:
  오라클: SELECT column1 FROM table1 UNION SELECT column1 FROM table2
  MSSQL: SELECT column1 FROM table1 UNION SELECT column1 FROM table2
  티베로: SELECT column1 FROM table1 UNION SELECT column1 FROM table2

 

• 문자열 비교 (대소문자 구분 없이):
  오라클: SELECT column1 FROM table_name WHERE UPPER(column1) = UPPER('value')
  MSSQL: SELECT column1 FROM table_name WHERE UPPER(column1) = UPPER('value')
  티베로: SELECT column1 FROM table_name WHERE column1 ILIKE 'value'