ORACLE SQL

//계층형
select * 
  from 테이블 
 start with 최상위 컬럼 조건 
 connect by prior 자식 컬럼 = 부모컬럼  ORDER SIBILINGS BY 각 계층별로 정렬


////컬럼
//컬럼 추가
ALTER TABLE 테이블명 ADD 컬럼이름 VARCHAR2(100) NOT NULL;

//컬럼 타입 변경
ALTER TABLE emp MODIFY editid VARCHAR2(4);

//컬럼 이름 변경
ALTER TABLE emp RENAME COLUMN editid TO edit_id;

//컬럼 조회
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME LIKE '%PROJ_CD%';


//합계, 소계 
GROUPING SETS

//누적 합계
select SUM(sal) OVER(ORDER BY empno) AS sal_sum from FROM emp

//계층형
//https://coding-factory.tistory.com/461

//코멘트 comment 조회 
//https://jwklife.tistory.com/45

//합계, 소계 
//https://gent.tistory.com/279

//누적 합계
//https://gent.tistory.com/476