oracle中sqlplus怎么剔除一列中没有数据的空行

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

限制条件列不为空

你好！ delete from tablename where ziduan is null; 仅代表个人观点，不喜勿喷，谢谢。