728x90 반응형 분류 전체보기826 2022-06-02-oracle과-postgres-5일차-6일차-비교 01.WITH절과 CTE 01.1 비재귀적 CTE Oracle, Postgres WITH abc(userID, total) AS ( SELECT userID, SUM(price*amount) FROM buyTbl GROUP BY userID ) SELECT * FROM abc ORDER BY total DESC ; WITH abc(userID, total) AS ( SELECT userID, SUM(price*amount) FROM buyTbl GROUP BY userID ) SELECT userID AS "사용자", total AS "총 구매액" FROM abc ORDER BY total DESC ; WITH cte_userTbl(addr, maxHeight) AS ( SELECT addr, MAX(h.. 2022. 6. 13. 2022-05-30-oracle과-postgres-4일차비교 01.SELECT와 FROM Oracle SELECT * FROM employees; SELECT * FROM HR.employees; -- 원칙대로 하는법 SELECT department_name FROM departments; -- 필요한 열만 출력 SELECT department_id,department_name FROM departments; -- 여러개 열 출력 Postgres SELECT * FROM employees; SELECT department_name FROM departments; -- 필요한 열만 출력 SELECT department_id,department_name FROM departments; -- 여러개 열 출력 02.스키마이름과 철자 기억안나는 경우 Oracle SELEC.. 2022. 6. 13. 2022-05-30-oracle과-postgres-3일차비교 01.인덱스 실습전 준비 Oracle CREATE TABLE Shop.indexTBL AS SELECT first_name, last_name, hire_date FROM HR.employees; SELECT * FROM Shop.indexTBL; SELECT * FROM Shop.indexTBL WHERE first_name = 'Jack'; Postgres create table indexTBL as select first_name, last_name, hire_date from employees; select * from indexTBL; SELECT * FROM Shop.indexTBL WHERE first_name = 'Jack'; 02.인덱스 생성하기 Oracle -- 인덱스 생성 CREATE.. 2022. 6. 13. 2022-05-30-oracle과-postgres-2일차비교 01.스키마 생성 Oracle -- USER SQL CREATE USER Shop IDENTIFIED BY "1234" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; -- QUORAS ALTER USER Shop QUOTA 10M ON USERS; -- ROLES GRANT "CONNECT" TO Shop; GRANT "RESOURCE" TO Shop; GRANT "DBA" TO Shop; ALTER SESSION SET CURRENT_SCHEMA = Shop; Postgres create user Shop with password '1234'; create database Shop with owner Shop; create schema Shop au.. 2022. 6. 13. 이전 1 ··· 13 14 15 16 17 18 19 ··· 207 다음 728x90 반응형
