- 论坛徽章:
- 0
|
字段名包括双引号: "level",如何select出来这个字段名字.
程序或者sqlplus下执行:
- SELECT level,subcount FROM sv_sms_sndreqstat
复制代码
都报错:ORA-01788 CONNECT BY clause required in this query block .
键表语句如下
- DROP TABLE SV_SMS_SNDREQSTAT CASCADE CONSTRAINTS;
- /*==============================================================*/
- /* Table: SV_SMS_SNDREQSTAT */
- /*==============================================================*/
- CREATE TABLE SV_SMS_SNDREQSTAT (
- REGION VARCHAR2(5) NOT NULL,
- TRANSDATE VARCHAR2(8) NOT NULL,
- "LEVEL" NUMBER(3) NOT NULL,
- SUBCOUNT NUMBER(20),
- CONSTRAINT PK_SV_SMS_SNDREQSTAT PRIMARY KEY (REGION, TRANSDATE, LEVEL1)
- );
复制代码
兄弟门情帮帮忙,如何写语句:
我试过 SELECT \'level\',subcount FROM sv_sms_sndreqstat
SELECT \"level\",subcount FROM sv_sms_sndreqstat
都不行
[ 本帖最后由 hmilymb 于 2007-1-11 09:08 编辑 ] |
|