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

答案:3 悬赏:60 手机版

解决时间 2021-12-26 06:49

提问者网友：寂寞撕碎了回忆
2021-12-25 17:53

最佳答案

五星知识达人网友：怀裏藏嬌
2021-12-25 18:33

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

全部回答

1楼网友：上分大魔王
2021-12-25 19:30

限制条件列不为空

2楼网友：西岸风
2021-12-25 18:40

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

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息