ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • [SQL] 오라클 출력 포멧 맞추기
    Database 2023. 7. 9. 22:43
    CREATE TABLE employees( 
          employee_id    NUMBER(6)
          first_name     VARCHAR2(20),
          last_name      VARCHAR2(25),
          email          VARCHAR2(25),
          hire_date      DATE,
          job_id         VARCHAR2(10),
          manager_id     NUMBER(6),
          department_id  NUMBER(4)
        ) ;
    INSERT INTO employees (employee_id, first_name, last_name, email, hire_date, job_id, manager_id, department_id )  VALUES (100, 'King', 'kim', 'SKING', '14-FEB-2011', 'AD_PRES', 100, 90);
    INSERT INTO employees (employee_id, first_name, last_name, email, hire_date, job_id, manager_id, department_id )  VALUES (101, 'Kochhar', 'choi', 'KOCH', '21-SEP-2015', 'AD_VP', 100, 90);
    INSERT INTO employees (employee_id, first_name, last_name, email, hire_date, job_id, manager_id, department_id )  VALUES (102, 'Hann', 'pack', 'LDEH', '13-JAN-2017', 'AD_VP', 102, 90);
    set linesize 130
    
    col employee_id format 99999999
    col first_name format a8
    col last_name format a8
    col email format a8
    col hire_date format a11
    col job_id format a11
    col manager_id format 9999999
    col department_id format 9999999
    
    SELECT * FROM employees;

    'Database' 카테고리의 다른 글

    [SQL] where 절 연산자  (0) 2023.07.13
    [SQL] 롤포워드/롤백  (0) 2023.07.09
    [SQL] SQL 처리과정  (0) 2023.07.06
    [SQL] 옵티마이저  (0) 2023.07.06
    [SQL] 소프트 파싱 / 하드 파싱  (0) 2023.07.05
Designed by Tistory.