oracle sql格式化

-- format.sql - SQL*Plus 格式化腳本
SET ECHO OFF
SET FEEDBACK ON
SET VERIFY OFF
SET HEADING ON
SET PAGESIZE 50
SET LINESIZE 200
SET TRIMSPOOL ON
SET TAB OFF
SET NULL "NULL"

-- 常用列格式預設
COLUMN object_name FORMAT A30
COLUMN owner FORMAT A20
COLUMN created FORMAT A20
COLUMN status FORMAT A10
COLUMN bytes FORMAT 999,999,999
COLUMN tablespace_name FORMAT A20

-- 員工表相關格式
COLUMN employee_id FORMAT 99999 HEADING "EMP_ID"
COLUMN first_name FORMAT A15 HEADING "FIRST_NAME"
COLUMN last_name FORMAT A15 HEADING "LAST_NAME"
COLUMN email FORMAT A25 HEADING "EMAIL"
COLUMN phone_number FORMAT A20 HEADING "PHONE"
COLUMN hire_date FORMAT A12 HEADING "HIRE_DATE"
COLUMN job_id FORMAT A15 HEADING "JOB_ID"
COLUMN salary FORMAT $999,999.99 HEADING "SALARY"
COLUMN commission_pct FORMAT 0.99 HEADING "COMM_PCT"
COLUMN manager_id FORMAT 99999 HEADING "MGR_ID"
COLUMN department_id FORMAT 999 HEADING "DEPT_ID"

-- 部門表相關格式
COLUMN department_name FORMAT A20 HEADING "DEPT_NAME"
COLUMN location_id FORMAT 99999 HEADING "LOC_ID"

PROMPT SQL*Plus 格式化已加載...

-- 設置列顯示格式
COLUMN column_name FORMAT A20      -- 字符列，寬度20
COLUMN sal FORMAT 999,999.99       -- 數字列，千位分隔符
COLUMN hiredate FORMAT A12         -- 日期列

-- 示例
COLUMN employee_name FORMAT A30
COLUMN salary FORMAT $999,999.99
COLUMN hire_date FORMAT A10

-- 查看當前列格式
COLUMN

-- 清除列格式
COLUMN column_name CLEAR

-- 設置每頁行數
SET PAGESIZE 100

-- 設置每行長度
SET LINESIZE 200

-- 關閉分頁顯示
SET PAGESIZE 0

-- 關閉列標題
SET HEADING OFF

-- 關閉反饋信息
SET FEEDBACK OFF