oracle中sqlplus怎么剔除一列中没有数据的空行
3个回答
推荐于2016-01-21 · 知道合伙人数码行家
huanglenzhi
知道合伙人数码行家
采纳数：117538
获赞数：517189
长期从事计算机组装，维护，网络组建及管理。对计算机硬件、操作系统安装、典型网络设备具有详细认知。
向TA提问 私信TA
关注
![]()
展开全部
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
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;
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
