sqlplus中如果属性名超出了30个字符该怎么使用啊

林小魅

如题，在sqlplus中一条查询语句
select * from record where rec_id="QQQQQQQ....QQ";
QQQQQQQ....QQ长度超过30个字符了
这样还可以使用sqlplus吗？
有什么解决办法？

Minsic

这个问题和shell啥关系

楼主的描述不够详细，包括错误信息之类的详细情况没有么？

林小魅

错误信息就是这个呀
ORA-00972: identifier is too long
变量长度太长
可是变量的长度又不能更改

Minsic

回复 3# 林小魅


    稍微测了下，行的啊，楼主是不是哪里搞错了？

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE    9.2.0.8.0       Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

SQL> desc test      
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
X                                                  VARCHAR2(20)

SQL> select * from test where x='QQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQ';

no rows selected

SQL> select length('QQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQ') from dual;

LENGTH('QQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQ')
--------------------------------------------------
                                                40

SQL>

注：总共40个Q

林小魅

select * from record where REC_ID="2010/02/25/ff681126708709584.WAV";
我就这么写的，


SQL> select * from record where REC_ID="2010/02/25/ff681126708709584.WAV";
select * from record where REC_ID="2010/02/25/ff681126708709584.WAV"
                                  *
ERROR at line 1:
ORA-00972: identifier is too long

林小魅

是我弄错了，真抱歉，
identifier is too long是指标示符过长，不是具体的值

libin1983

貌似需要將雙引號換為單引號.
"" -> ''

Minsic

楼上的眼尖

libin1983