select 'N ' as IS_RETURN , 'N ' as IS_DPL , 'N ' as IS_DPR , FISCAL as PAY_FISCAL ,FIS_PERD as PAY_FISPERD , FISCAL as BAL_FISCAL , FIS_PERD as BAL_FISPERD from uf_gkgz; 没有办法,只能加空格
你用的是那个版本的数据库,我这没有出现这个问题 SQL> select 'N' as sssss from dual;SSSSS ----- N
不会吧. 我这儿没问题. 12:52:16 DBA>select 'N' as a 12:52:17 2 , 'N' as b 12:52:17 3 , 'N' as c 12:52:17 4 from dual 12:52:17 5 ;A B C - - - N N N已用时间: 00: 00: 00.00 12:52:18 DBA>
我想,这跟你的sqlplus 有关系吧 在同一个数据库下(oracle9i)1:在Linux 下SQL> select 'N' as IS_RETURN from dual;I - NSQL> 2:在windows下使用pl/sql developerSQL> select 'N' as IS_RETURN from dual;IS_RETURN --------- NSQL>
, 'N ' as IS_DPL
, 'N ' as IS_DPR
, FISCAL as PAY_FISCAL
,FIS_PERD as PAY_FISPERD
, FISCAL as BAL_FISCAL
, FIS_PERD as BAL_FISPERD from uf_gkgz;
没有办法,只能加空格
SQL> select 'N' as sssss from dual;SSSSS
-----
N
column is_return a10;
把你想定制的列都这样写一下就可以了!
我这儿没问题.
12:52:16 DBA>select 'N' as a
12:52:17 2 , 'N' as b
12:52:17 3 , 'N' as c
12:52:17 4 from dual
12:52:17 5 ;A B C
- - -
N N N已用时间: 00: 00: 00.00
12:52:18 DBA>
我想,这跟你的sqlplus 有关系吧
在同一个数据库下(oracle9i)1:在Linux 下SQL> select 'N' as IS_RETURN from dual;I
-
NSQL> 2:在windows下使用pl/sql developerSQL> select 'N' as IS_RETURN from dual;IS_RETURN
---------
NSQL>