- 论坛徽章:
- 2
|
本帖最后由 antyison 于 2015-02-28 13:54 编辑
表结构:
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|
我想要输出去除字符串结尾的空格,变成这样:
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|
请问如何设置才能达到这个效果,因为实际字段很多,所以不想使用 col ... format a...
|
|