oracle 一空行 返回 1,oracle中sqlplus肿么剔除一列中没有数据的空行

You can use a script to do this , I have a demo for you :

D:\>type user.sql

set termout off

set feedback off

set verify off

set echo off

set pagesize 0

spool d:\user.lst

select username from dba_users;

spool off

D:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on 星期二 10月 21 11:24:26 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

连接到:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

SQL> @user.sql

SQL> exit

从Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production中断开

D:\>type user.lst

SYS

SYSTEM

DBSNMP

EYGLE

REPADMIN

SCOTT

OUTLN

WMSYS

-Eygle

取消

评论