表结构:
CREATE TABLE t_student (
f_id char(3) NOT NULL Primary Key,
f_name char( 8 ) NOT NULL ,
f_sex char(1) NOT NULL ,
f_birth date NULL ,
f_department char(5) NULL ,
f_class int NULL
);
我的设置:
set colsep '|'
set head off
set echo off
set headsep off
set newp none
set long 2000000000
set longchunksize 32767
set linesize 32767
set numw 32
set pagesize 0
set sqlblanklines off
set trimspool on
set termout off
set feedback off
set numw 32
set verify off
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
SELECT F_ID , F_NAME ,F_SEX , F_BIRTH ,F_DEPARTMENT , F_CLASS||'|' FROM T_STUDENT;
001 |张三 |m |1984-08-01 00:00:00|CS |1|
002 |李四 |f |1986-05-11 00:00:00|PHY |3|
003 |王五 |m |1983-06-17 00:00:00|CS |1|