[SQL]테이블 확인,생성,삭제,삽입

/*테이블 확인*/
SELECT * FROM TAB;
SELECT * FROM TABS;
 
/*테이블 생성*/
CREATE TABLE DEPT_TEMP
AS SELECT * FROM DEPT;
 
/*테이블 삭제*/
DROP TABLE DEPT_TEMP;
 
/*데이터 삽입 */
INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC)
VALUES (50,'DATABASE','SEOUL');
 
/* NULL데이터 삽입*/
INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC)
VALUES (70,'WEB',NULL);
INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC)
VALUES (80,'MOBILE','');
INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC)
VALUES (90,'COMPUTER','');
 
/*테이블의 구조만 가져오기:WHERE */
CREATE TABLE EMP_TEMP
AS SELECT * FROM EMP
WHERE 1<>1;
 
/*테이블 구조와 내용까지*/
CREATE TABLE EMP_TEMP2
AS SELECT * FROM EMP;
 
/* INSERT INTO */
INSERT INTO EMP_TEMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES (9999,'홍길동','PRESIDENT',NULL,'2001/01/01',5000,1000,10);
SELECT * FROM EMP_TEMP;
 
/*실습 10-14 서브쿼리로 여러데이터 추가하기*/
INSERT INTO EMP_TEMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
SELECT E.EMPNO,E.ENAME,E.JOB,E.MGR,E.HIREDATE,E.SAL,E.COMM,E.DEPTNO
FROM EMP E, SALGRADE S
WHERE E.SAL BETWEEN S.LOSAL AND S.HISAL
AND S.GRADE =1;