oracle 建表缺失右括号 [问题点数:40分,结帖人waimiandeshijie_8813]

Bbs1
本版专家分:0
结帖率 100%
Bbs9
本版专家分:64162
版主
Blank
GitHub 绑定GitHub第三方账户获取
Blank
进士 2017年 总版技术专家分年内排行榜第八
Blank
优秀版主 2016年10月优秀大版主
优秀小版主
Blank
银牌 2017年1月 总版技术专家分月排行榜第二
oracle时出现缺失括号问题
create table studentsrn(rn stuID number primary key,rn stuName varchar2(20),rn stuSex char(2) check(stuSex='男' or stuSex='女') default('男'),rn stuAge number(3) check(stuAge between 0 and 100) default(0),rn stuCity varchar2(20),rn classID number(4)rn constraint students_fk foreign key(classID) references classes(classID)rn);rn第5行出现<em>右</em><em>括号</em><em>缺失</em>错误。rn请大家帮忙找一下是哪里错了。rn谢谢。rnrn
Oracle提示缺失括号,求解决
[code=sql]create table teach(rn id number(8) primary key,rn item nvarchar2(10) not null,--评分项目rn criterion nvarchar2(50) not null,--评分标准rn grade number(3) not null--分值rn);[/code]rn去掉最后的分号正常执行,如果不去掉提示ORA-00907
缺失括号的问题??
[code=SQL]rn我现在有一个这样的 过程 rn但是执行总是报 <em>缺失</em><em>右</em><em>括号</em> 不知道为什么 大家帮忙看看rnrncreate or replace procedure test_p isrntype tcur is ref cursor;rnfi_cur1 tcur;rndos1 date;rndos30 date;rnbeginrndos1 := to_date('2006-01-01','yyyy-mm-dd');rndos30 := to_date('2006-11-01','yyyy-mm-dd');rn open fi_cur1 for ' select distinct mbrid from fi06rn where ( mbrid=''1000'' and dos >= '||dos1||' and dos ;rn--。。。。rnend test_p;rn[/code]
ORA-00907: 缺失括号
select ID,MAILTYPE,MAILTITLE,to_char(WRITETIME,'yyyy-mm-dd') WRITETIME from mails where ID in (select ID from mails where ISPUB=1 and ISVAIDATE=1 and ISSECRET=0 and ISCHOOSEPUB=1 order by ID desc) and rownum<11rnrnrn哪里缺<em>右</em><em>括号</em>了?rn不明白
缺失括号
例如:rncrate table a(id not null number(4)); 就会报错:缺少")"rn但是:rncreate table a(id number(4) not null); 就不会报错。rn为什么呢?rnnot null 一定要放到后面吗?
ora-00907: 缺失括号
在pl/sql里执行  报此错rnselect TEMQ_1f040dd124f08b2ce1.GW GW,rn TEMQ_1f040dd124f08b2cb2.GZRQ GZRQ,rn TEMQ_1f040dd124f08b2bd8.DH DH,rn TEMQ_1f040dd124f08b2bd8.XKHSM XKHSM,rn TEMQ_1f040dd124f08b2c83.KHZS KHZS,rn TEMQ_1f040dd124f08b2c83.KHZS - TEMQ_1f040dd124f08b2bd8.XKHSM LKHZS,rn TEMQ_1f040dd124f08b2cb2.LDZS LDZS,rn TEMQ_1f040dd124f08b2cb2.QDZS QDZS,rn TEMQ_1f040dd124f08b2cb2.QFZS QFZS,rn TEMQ_1f040dd124f08b2d20.QYTS QYTS,rn TEMQ_1f040dd124f08b2d20.MJ MJ,rn TEMQ_1f040dd124f08b2d20.JE JE,rn TEMQ_1f040dd124f08b2d20.YSJE YSJE,rn TEMQ_1f040dd124f08b2d20.QKJE QKJE,rn sum(TEMQ_1f040dd124f08b2cb2.LFZS) LFZSrn from TEMQ_1f040dd124f08b2cb2,rn TEMQ_1f040dd124f08b2bd8,rn TEMQ_1f040dd124f08b2c83,rn TEMQ_1f040dd124f08b2d20,rn TEMQ_1f040dd124f08b2ce1rn where TEMQ_1f040dd124f08b2cb2.GZRQ = TEMQ_1f040dd124f08b2bd8.DJRQrn and TEMQ_1f040dd124f08b2cb2.GZRQ = TEMQ_1f040dd124f08b2c83.GZRQrn and TEMQ_1f040dd124f08b2cb2.GZRQ = TEMQ_1f040dd124f08b2d20.QYRQrn and TEMQ_1f040dd124f08b2cb2.PK_PSNDOC =rn TEMQ_1f040dd124f08b2ce1.PK_PSNDOCrn and ((TEMQ_1f040dd124f08b2ce1.PK_CORP = '1008') andrn (TEMQ_1f040dd124f08b2bd8.PK_PSNDOC = '0001G510000000001X90') andrn (TEMQ_1f040dd124f08b2c83.PK_PSNDOC = '0001G510000000001X90') andrn (TEMQ_1f040dd124f08b2cb2.PK_PSNDOC = '0001G510000000001X90') andrn (TEMQ_1f040dd124f08b2d20.PK_PSNDOC = '0001G510000000001X90') andrn (TEMQ_1f040dd124f08b2ce1.PK_PSNDOC = '0001G510000000001X90') andrn (TEMQ_1f040dd124f08b2bd8.PK_PROJECT = '0001G510000000000E8S') andrn (TEMQ_1f040dd124f08b2c83.PK_PROJECT = '0001G510000000000E8S') andrn (TEMQ_1f040dd124f08b2cb2.PK_PROJECT = '0001G510000000000E8S') andrn (TEMQ_1f040dd124f08b2d20.PK_PROJECT = '0001G510000000000E8S') andrn (TEMQ_1f040dd124f08b2ce1.PK_PROJECT = '0001G510000000000E8S') andrn (TEMQ_1f040dd124f08b2cb2.GZRQ >= 'select trunc(next_day(to_date('rn 2009 - 10 - 30 ', ' yyyy - mm - dd '), 1) - 6) from dual') andrn (TEMQ_1f040dd124f08b2cb2.GZRQ ))rn group by TEMQ_1f040dd124f08b2ce1.GW,rn TEMQ_1f040dd124f08b2cb2.GZRQ,rn TEMQ_1f040dd124f08b2bd8.DH,rn TEMQ_1f040dd124f08b2bd8.XKHSM,rn TEMQ_1f040dd124f08b2c83.KHZS,rn TEMQ_1f040dd124f08b2c83.KHZS - TEMQ_1f040dd124f08b2bd8.XKHSM,rn TEMQ_1f040dd124f08b2cb2.LDZS,rn TEMQ_1f040dd124f08b2cb2.QDZS,rn TEMQ_1f040dd124f08b2cb2.QFZS,rn TEMQ_1f040dd124f08b2d20.QYTS,rn TEMQ_1f040dd124f08b2d20.MJ,rn TEMQ_1f040dd124f08b2d20.JE,rn TEMQ_1f040dd124f08b2d20.YSJE,rn TEMQ_1f040dd124f08b2d20.QKJErn请赐教
缺失括号问题
最近刚开始学ORACLE, 用的10gEX版本,用HR账号登陆。rn下面的语句: update jobs set max_salary = (1000+(select avg(max_salary) from jobs)) where job_id = 'AD_VP';没有问题。rn不过如果把+1000 放在后面变成:update jobs set max_salary = ((select avg(max_salary) from jobs)+1000) where job_id = 'AD_VP';rn就会提示<em>缺失</em><em>右</em><em>括号</em>。百思不得其解~~~rn分不多了,希望大家不吝赐教
ora-00907 缺失括号?????
SELECT /*+ parallel (statcmain )*/ rn sum(decode(statcmain.certitype,''P'', 1,decode(statcmain.endortype, ''19'', ''-1'', 0))) as Count, rn sum((STATCMAIN.CHGPREMIUM - STATCMAIN.CHGMIDDLECOST) * STATCMAIN.CNYEXCHRATE * STATCMAIN.COINSRATE / 100) as premium, rn sum(STATCMAIN.CHGINSURED * STATCMAIN.CNYEXCHRATE * STATCMAIN.COINSRATE / 100) as amount, rn sum(STATCMAIN.CHGLIMIT * STATCMAIN.CNYEXCHRATE * STATCMAIN.COINSRATE / 100) as limit rn FROM rep.Statcmain, rn reptest.statcogsharerate, rn rep.statdcompanylevel rn where Statcmain.Policyno = statcogsharerate.policyno(+) rn and statcmain.comcode = statdcompanylevel.comcode rn and statcmain.riskcode NOT IN (''YAB0'', ''2797'', ''2798'') rn AND STATCMAIN.CLASSCODE <> ''30'' rn group by statcmain.statdate, rn statcmain.StartDate, rn statcmain.COMCODE, rn decode(statcmain.riskcode, rn ''2700'', rn statcmain.productcode, rn statcmain.riskcode), rn statcmain.SHAREHOLDERFLAG, rn statcmain.BUSINESSNATURE, rn ((substr(statcmain.othflag, 1, 1))), rn statdcompanylevel.centercode, rn statcmain.Agentcode, rn statcmain.Handler1code, rn decode(substr(statcmain.othflag, 15, 1), rn NULL, rn ''0'', rn substr(statcmain.othflag, 15, 1)), rn statcmain.BusinessKind, rn statcmain.BusinessClass, rn CASE WHEN (statcmain.businessflag IS NULL OR statcmain.businessflag <> ''1'') THEN (''0'') rn ELSE (''1'') END, rn statcmain.businesssource, rn statcmain.constructtype,rn statcmain.channeltype,rn statcmain.servicearea,rn statcmain.agriFlag,rn statcmain.usenaturecode,rn statcmain.carkindcode,rn statcmain.toncount,rn statcmain.applitype,rn statcmain.ventureflag, rn statcmain.grouppurchaseflag;rn
ORA-00907:缺失括号
CREATE TABLE WEB_CULTURE(rnCULTURE_ID NUMBER(10),rnCULTURE_TITLE VARCHAR2(500),rnCULTURE_TYPE NUMBER(10),rnCULTURE_DATE DATE(7),rnDEPT VARCHAR2(100),rnCULTURE_CONTENT BLOB,rnCULIMG_URL VARCHAR2(256),rnCUL_TITLE VARCHAR2(128),rnCONSTRAINT WEB_CULTURE PRIMARY KEY (CULTURE_ID)rn);rn这段<em>建</em><em>表</em>语句报 ORA-00907:<em>缺失</em><em>右</em><em>括号</em>
缺失括号????
我在创<em>建</em>一个<em>表</em>时,这两行老师提示<em>缺失</em><em>右</em><em>括号</em>rn去掉这两行就没问题rn没<em>缺失</em><em>右</em><em>括号</em>呀rn这是为什么?rnrn gender varchar2(10) ck_agents_gender check((gender='m')or(gender='f')),rn cellphone nvarchar2(20) uu_agents_cellphone unique
ORA-00907 缺失括号
SELECTrnxmlid.nextval,rn''rnrnrnrnFROM user_tab_columns t WHERE t.TABLE_NAME=vtab;rnrn变量是前面存过定义好的。 rn
oracle 插入数据时缺失括号???
这是我<em>建</em>的<em>表</em>: rncreate table users(rn userid varchar2(30) primary key,rn username varchar2(30) not null,rn userpassword varchar2(30) not nullrn );rn这个没有报错,当我插入数据时,就出现了<em>右</em><em>括号</em><em>缺失</em>这个错误,大家帮帮忙吧!我是新手,很多都不懂。谢谢哈!rn这是我插入的数据:insert into users select ('1','david','123456')。
ORA-00907: 缺失括号问题!!!???
今天遇到了数据库<em>建</em><em>表</em>时的问题:ORA-00907: <em>缺失</em><em>右</em><em>括号</em>问题!!!???rnrnrn我的SQL脚本如下:rnrncreate table sys_managers(ID bigint NOT NULL PRIMARY KEY,rnname varchar(28) NOT NULL,rnsex varchar(4) NOT NULL,rnage int(3) NOT NULL,rnaddress varchar(100) NOT NULL,rnpassword varchar(18) NOT NULL,rnrole varchar(28) NOT NULL,rnflag varchar(6) NOT NULL,rnflag2 varchar(6) default null,rndegree varchar(8) not null,rnpositional_title varchar(18) default null,rndate1 date not null,rndate2 date default null,rnflag3 varchar default null,rnself TEXT default null)ENGINE=InnoDB DEFAULT CHARSET=gb2312;rnrn若在MySQL中,会出现如附图片的报错信息。rn请教各位大神该如何修改,解决问题啊?rnrnrn
java.sql.SQLException: ORA-00907: 缺失括号
String sqlTablespace = "select upper(f.tablespace_name) \"Tablespace\",d.tot_grootte_mb \"Size MB\",f.total_bytes \"Free MB\","rn + "to_char(round(f.total_bytes/ d.tot_grootte_mb * 100,2),'990.99') \"Percent Free\","rn + "d.autoextensible from (select tablespace_name,round(sum(bytes) /(1024 * 1024), 2) total_bytes,round(max(bytes) / (1024 * 1024),"rn + " 2) max_bytes from sys.dba_free_space group by tablespace_name) f,"rn + "(select dd.tablespace_name,round(sum(dd.bytes)/(1024 * 1024), 2) tot_grootte_mb,"rn + "round(sum(dd.maxbytes)/(1024 * 1024), 2) tot_tbs_mb,dd.autoextensible from sys.dba_data_files dd"rn + "group by dd.tablespace_name,dd.autoextensible) d"rn + " where d.tablespace_name = f.tablespace_name order by f.tablespace_name";
sql语句缺失括号
我是根据前台传过来的年龄段对人员<em>表</em>里的生日字段进行查询rnsql语句如下rn[code=sql] select * from BC_BCOA_PERSON WHERE PERSON_ID != 0 and PERSON_DELETE=0 and(YEAR (CURDATE()) -1 - YEAR (PERSON_BIRTHDAY) + (DATE_FORMAT(PERSON_BIRTHDAY,'%m%d') =20 AND (YEAR (CURDATE()) -1 - YEAR (PERSON_BIRTHDAY) + (DATE_FORMAT(PERSON_BIRTHDAY, '%m%d') <=100 [/code]rnrn谢谢大家
SQLSyntaxErrorException: ORA-00907: 缺失括号
select * from ( select a.*, ROWNUM rnum from ( select site_code,shop_order,target_qty,start_date,close_date,sales_order,customer_code,item_code,status ,remark,create_by,create_time,update_by,update_time from SHOP_ORDER WHERE shop_order = ? and start_date between to_date(?,'yyyy/mm/dd hh24:mi:ss') and close_date between to_date(?,'yyyy/mm/dd hh24:mi:ss') and status = ? ) a where ROWNUM < ?) where rnum >= ?nnn大神大牛帮帮忙。
ORA-00907: 缺失括号 问题!!!???
rnrn creat table xh_projectrn(rn pk_project int(4),rn project_code varchar(20),rn project_name varchar(60),rn iflock varchar(1) not null,rn ifmerge varchar(1) not null,rn ts char(19) convert(char(19),getdate(),20),rn dr smallint(2) default 0,rn constraint P_pk_xh_project primary key (pk_project)rn);rnrn 报错提示: ORA-00907:<em>缺失</em><em>右</em><em>括号</em> rn 请各位帮忙!rn 数据库使用的是 <em>oracle</em>数据库。rn rn 同样的语句 下面的创<em>建</em><em>表</em>就可以执行:rncreate table wa_qx_parameterrn(rn pk_parameter CHAR(20) not null,rn param_code VARCHAR(20) not null,rn param_name VARCHAR(100) not null,rn param_value VARCHAR(20) not null,rn approveflag SMALLINT default 0,rn mender VARCHAR(20),rn assessor VARCHAR(20),rn amend_date CHAR(19),rn remark VARCHAR(500),rn ts CHAR(19),rn dr SMALLINT default 0,rn constraint P_pk_wa_qx_paramet primary key (pk_parameter)rn); rn
sql代码缺失括号
sb.append("select MCHT_NO,MCHT_NM,LICENCE_NO,APPLY_DATE,MAPPING_MCHNTCDONE,MAPPING_MCHNTCDTW O,MCHT_STATUS,TERM_COUNT from ");rnsb.append("((SELECT * FROM TBL_MCHT_BASE_INF_TMP t1 left outer join TBL_BRH_INFO t2 on t2.brh_id=t1.agr_br ) A left outer join (select MCHT_CD,count(1) AS TERM_COUNT from TBL_TERM_INF group by MCHT_CD) B ON (A.MCHT_NO = B.MCHT_CD))");rnsb.append("where MCHT_STATUS IN ('1','3','5','6','8','R') ");rnrnrn运行的时候显示上述代码<em>缺失</em><em>右</em><em>括号</em>,但是在数据库中可以运行出来,这是什么原因
java.sql.SQLSyntaxErrorException: ORA-00907: 缺失括号
select * from ( nnselect a.*, ROWNUM rnum from ( nnselect * from SHOP_ORDER nWHERE start_date between to_date(‘2016-08-22 11:34:36’,'yyyy/mm/dd hh24:mi:ss') nand close_date between to_date('2016-09-22 11:34:36','yyyy/mm/dd hh24:mi:ss') ) a where ROWNUM< ?) where rnum >= ?nnnn求各位大神大牛帮帮小弟!!!!
oracle数据库时出现错误:缺失括号
<em>oracle</em>数据库<em>建</em><em>表</em>时出现错误:<em>缺失</em><em>右</em><em>括号</em> 这个错误一般都是用了<em>oracle</em>中没有的语法导致的,比如:identity函数是SQLSERVER中的,<em>oracle</em>中不能用;数字型定义在<em>oracle</em>中须全写number,只写num也会报这个错误。 调试方法:逐行注释
数据库的问题 ORA-00907: 缺失括号问题!!!???
报错:ORA-00907: <em>缺失</em><em>右</em><em>括号</em>问题!!!???rnrn我的<em>建</em><em>表</em>脚本如下所示:rnrncreate table sys_managers(ID bigint NOT NULL PRIMARY KEY,rnname varchar(28) NOT NULL,rnsex varchar(4) NOT NULL,rnage int(3) NOT NULL,rnaddress varchar(100) NOT NULL,rnpassword varchar(18) NOT NULL,rnrole varchar(28) NOT NULL,rnflag varchar(6) NOT NULL,rnflag2 varchar(6) default null,rndegree varchar(8) not null,rnpositional_title varchar(18) default null,rndate1 date not null,rndate2 date default null,rnflag3 varchar default null,rnself TEXT default null)ENGINE=InnoDB DEFAULT CHARSET=gb2312;rnrnrn请教各位这是什么错误啊,该如何修改捏?rnrn若在MySQL中会出现rn[img=https://img-bbs.csdn.net/upload/201309/17/1379424206_904450.jpg][/img]rn如图所示错误。rnrn请教各位这是什么错误啊,该如何修改捏?
Oracle 括号缺失
create table exchangeFund (rn tradedatee nvarchar2 not null,rn exchangeid nvarchar2 not null,rn companyid nvarchar2 not null,rn currency nvarchar2 null,rn moneyin varchar2 not nullrn);rnrnsql如上,在批量PL/SQL Developer中执行,提示错误左<em>括号</em><em>缺失</em>,求救
Oracle 缺少括号。。。
创<em>建</em>视图如下:rn......rn--主要内容:rnselect name,(case when nvl(sid,'') is null then cast(studentid as varchar(36)) else ybkh end case) as studentid rnfrom student;rn......rnrnrn创<em>建</em>的时候报错:缺少<em>右</em><em>括号</em>。。。rn请大家帮帮忙看下额。。。rncase的作用是:如果sid列为空,则显示studentid列,如果sid列不空,则直接显示
ORA-00907: 缺失括号问题整理解决
ORA-00907: <em>缺失</em><em>右</em><em>括号</em>前言        最近在开发过程中使用<em>oracle</em>数据库,在程序中进行查询数据时遇到了“ORA-00907: <em>缺失</em><em>右</em><em>括号</em>”的问题,但是如果直接把sql语句直接在数据库或PL/SQL中执行时,却又能够正常查询,为了解决这个问题,折腾了半天,查找了一些资料,所以就对各种导致出现“<em>缺失</em><em>右</em><em>括号</em>”的情况进行了整理总结。行文如下。1 union all中order by 导致
新手求教,缺失括号异常。
create table UserInforn(rn UserId number(5) primary key, ---非空 主键编号rn UserName varchar(20) unique not null , --非空 唯一用户名rn UserPwd varchar(20) not null, --非空 登录密码rn Balance number(5) not null --非空 余额rn);rnrn这段代码说是<em>缺失</em><em>右</em><em>括号</em>rn但当我把最后的分号删后rncreate table UserInforn(rn UserId number(5) primary key, --非空 主键编号rn UserName varchar(20) unique not null , --非空 唯一用户名rn UserPwd varchar(20) not null, --非空 登录密码rn Balance number(5) not null --非空 余额rn)rn这里又没事了,rn不删分号,我把前两行注释删了rncreate table UserInforn(rn UserId number(5) primary key, rn UserName varchar(20) unique not null , rn UserPwd varchar(20) not null, --非空 登录密码rn Balance number(5) not null --非空 余额rn);rn段代号也是好的,怎么回事啊????
mybatis分页查询时ORA-00907: 缺失括号
mybatis语句:rn[code=text]rnSELECT * FROMrn (SELECT rn id as id,rn appserialnumber as appserialnumber,rn who as who,rn createtime as createtime,rn operatedtype as operatedtype,rn operate as operate,rn operatedobject as operatedobject,rn description as description,rn result as result,rn ROWNUM AS row_numrn FROM server_log ROWNUM < (#startRecord+#total)) t_temprn WHERE t_temp.row_num >= #startRecordrn[/code]rnrn然后控制台打印语句:rn10:06:51,114 DEBUG Connection:27 - ooo Connection Openedrn10:06:51,442 DEBUG PreparedStatement:27 - ==> Executing: select count(*) from server_log rn10:06:51,442 DEBUG PreparedStatement:27 - ==> Executing: select count(*) from server_log rn10:06:51,442 DEBUG PreparedStatement:27 - ==> Parameters: rn10:06:51,442 DEBUG PreparedStatement:27 - ==> Parameters: rn10:06:51,630 DEBUG Connection:27 - ooo Connection Openedrn10:06:51,646 DEBUG PreparedStatement:27 - ==> Executing: SELECT * FROM (SELECT id as id, appserialnumber as appserialnumber, who as who, createtime as createtime, operatedtype as operatedtype, operate as operate, operatedobject as operatedobject, description as description, result as result, ROWNUM AS row_num FROM server_log ROWNUM < (?+?)) t_temp WHERE t_temp.row_num >= ? rn10:06:51,646 DEBUG PreparedStatement:27 - ==> Executing: SELECT * FROM (SELECT id as id, appserialnumber as appserialnumber, who as who, createtime as createtime, operatedtype as operatedtype, operate as operate, operatedobject as operatedobject, description as description, result as result, ROWNUM AS row_num FROM server_log ROWNUM < (?+?)) t_temp WHERE t_temp.row_num >= ? rn10:06:51,646 DEBUG PreparedStatement:27 - ==> Parameters: 0(Integer), 10(Integer), 0(Integer)rn10:06:51,646 DEBUG PreparedStatement:27 - ==> Parameters: 0(Integer), 10(Integer), 0(Integer)rn2014-8-1 10:06:51 org.apache.catalina.core.StandardWrapperValve invokern严重: Servlet.service() for servlet SearchServlet threw exceptionrnorg.apache.ibatis.exceptions.PersistenceException: rn### Error querying database. Cause: java.sql.SQLException: ORA-00907: <em>缺失</em><em>右</em><em>括号</em>rnrn### The error may involve com.itrus.mylog.domain.ServerLog.selectAllServerLog-Inlinern### The error occurred while setting parametersrn### Cause: java.sql.SQLException: ORA-00907: <em>缺失</em><em>右</em><em>括号</em>rnrn at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)rn at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:77)rn at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:69)rn at com.itrus.mylog.dao.impl.SearchDAOImpl.searchPagination(SearchDAOImpl.java:37)rn at com.itrus.mylog.service.impl.SearchServiceImpl.searchPagination(SearchServiceImpl.java:24)rn at com.itrus.mylog.servlet.SearchServlet.search(SearchServlet.java:53)rn at com.itrus.mylog.servlet.SearchServlet.service(SearchServlet.java:40)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)rn at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)rn at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)rn at java.lang.Thread.run(Thread.java:619)rnCaused by: java.sql.SQLException: ORA-00907: <em>缺失</em><em>右</em><em>括号</em>rnrn at <em>oracle</em>.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)rn at <em>oracle</em>.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)rn at <em>oracle</em>.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)rn at <em>oracle</em>.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)rn at <em>oracle</em>.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)rn at <em>oracle</em>.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)rn at <em>oracle</em>.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)rn at <em>oracle</em>.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)rn at <em>oracle</em>.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1116)rn at <em>oracle</em>.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)rn at <em>oracle</em>.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:597)rn at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:45)rn at $Proxy1.execute(Unknown Source)rn at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)rn at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)rn at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)rn at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:216)rn at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:95)rn at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)rn at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:75)rn ... 18 morernrn求指点,是语句哪里写错了么?
ORA-00907: 缺失括号与左括号问题总结
在创<em>建</em>数据<em>表</em>总结如下:  1.date限定字段大小的时候,会报错,比如,将date(12)去掉(12);  2.关键字顺序有误,也会报这样的错;  3.创<em>建</em><em>表</em>时,如果<em>表</em>有关键字,用双引号括起来;  4.如果创<em>建</em><em>表</em>时,未对字段中的<em>表</em>设置长度,也会报错;  5.创<em>建</em>主外键约束时外键类型跟主键类型不完全一致,也是会报错的。  ...
一存储过程,提示缺失括号问题
一个按时间做的范围分区,现做了一个通用的存储过程,代码如下:rn[code=SQL]rnrncreate or replace procedure addpart(v_tbname in varchar2,v_part in varchar2,rnv_date in varchar2,v_tabs in varchar2) isrnv_sql1 varchar2(200);rnv_sql2 varchar2(200);rnv_dtime date;rnbeginrn v_dtime:=to_date(v_date,'yyyy-mm-dd hh24:mi:ss');rn dbms_output.put_line(v_dtime);rn v_sql2:='alter table '||v_tbname||' add partition '||v_part||' values less than ('||v_dtime||') tablespace '||v_tabs||'';rn dbms_output.put_line(v_sql2);rn execute immediate v_sql2;rnend addpart;rnrn[/code]rnexec addpart('mytest','p_04','2009-04-01 0:00:00','P_TEST');--<em>表</em>名,范围分区名,时间,<em>表</em>空间rn执行的结果如下:rn01-4月 -09rnalter table mytest add partition p_04 values less than (01-4月 -09) tablespace P_TESTrnbegin addpart('mytest','p_04','2009-04-01 0:00:00','P_TEST'); end;rnORA-00907: <em>缺失</em><em>右</em><em>括号</em>rnrn现将rnalter table mytest add partition p_04 values less than (to_date('2009-04-01 0:00:00','yyyy-mm-dd hh24:mi:ss')) tablespace P_TESTrn在plsql 中执行通过 rnrnrn向各位请教,存储过程该如何改进下。。。
oracle pl/sql 插入数据缺失括号00907错误
急!!! 急!!! 急!!!rnrnCREATE TABLE mrecord (rn id NUMBER(8) NOT NULL,rn smemberid VARCHAR2(50) NULL,rn stestid NUMBER(8) NULL,rn stesttitle VARCHAR2(100) NULL,rn sdate VARCHAR2(100) NULL,rn sstatus CHAR(20) NULL,rn sscore VARCHAR2(100) NULL,rn sanswertitle VARCHAR2(100) NULL,rn sevaluation VARCHAR2(4000) NULL,rn ssuggestion VARCHAR2(4000) NULL,rn CONSTRAINT PK_mrecord PRIMARY KEY (id)rn ) ;rnrninsert into UDEMO.MRECORD (ID, SMEMBERID, STESTID, STESTTITLE, SDATE, SSTATUS, SSCORE, SANSWERTITLE, SEVALUATION, SSUGGESTION)rnvalues (1547, 'xyy', 115, '个人信息', to_date(''2010-03-17 13:37:00'', 'YYYY-MM-DD HH24:MI:SS'), 1, '', '', '', '');rnrninsert into UDEMO.MRECORD (ID, SMEMBERID, STESTID, STESTTITLE, SDATE, SSTATUS, SSCORE, SANSWERTITLE, SEVALUATION, SSUGGESTION)rnvalues (1651, 'ly', 163, '个人信息', to_date(''2010-03-18 18:00:00'', 'YYYY-MM-DD HH24:MI:SS'), 1, '60', '绩效管理与工作分析能力有待提高', '评估结果<em>表</em>明,基于这次的培训内容,您对“绩效管理与工作分析”知识和技能的掌握还有待提高,您没有很好的把所学的知识灵活运用到工作中,对于绩效管理与工作分析的重要性,以及绩效管理与工作分析的相关工作流程,您可能还需要继续学习。但绩效管理与工作分析难以操作的地方在于方法的选用与细节的操作,基于观念,让公司员工能够真正认可,是一件非常困难的事情,这需要有效的沟通;细节的操作,能够做到公平公正,科学客观,也是需要相关知识的积累与实践,在这些方面的操作,您可能需要投入更多的精力去学习与积累,只要您不断努力,您也会是最棒的! ', '');rn
oracle查询语句老是报ORA-00907缺失括号
--大家好,我有一条<em>oracle</em>查询语句老是报ORA-00907<em>缺失</em><em>右</em><em>括号</em>的错误,能不能帮我看一下,谢谢:rn--统计毕业班等级考试最佳成绩rnselect distinct e.xy 学院,rn e.xzb 班级,rn e.xh 学号,rn e.xm 姓名,rn a.cet3 英语三级,rn b.cet4 英语四级,rn c.cet6 英语六级,rn d.computer 计算机rn from ((select xh, xm, djksmc, max(cj) cet3rn from xsdjksbrn where djksmc = '英语三级'rn Group by xh, xm, djksmc) a,rn (select xh, xm, djksmc, max(cj) cet4rn from xsdjksbrn where djksmc = '英语四级'rn Group by xh, xm, djksmc) b,rn (select xh, xm, djksmc, max(cj) cet6rn from xsdjksbrn where djksmc = '英语六级'rn Group by xh, xm, djksmc) c,rn (select xh, xm, djksmc, max(cj) computerrn from xsdjksbrn where djksmc like '计算机%'rn Group by xh, xm, djksmc) d, xsjbxxb e)rn where (a.xh = e.xh or b.xh = e.xh or c.xh = e.xh or d.xh = e.xh)rn and ((e.DQSZJ = '2010' AND e.XZ = '5') ORrn (e.DQSZJ = '2011' AND e.XZ = '4') ORrn (e.DQSZJ = '2012' AND e.XZ = '3'))rn AND e.SFZX = '是'rn order by e.xy, e.xzb, e.xh, e.xm;rnrnrn报错落在 djksmc) a,的a上rnrn我确信我的语句所有的左<em>右</em><em>括号</em>都是匹配的,没有<em>缺失</em>,一定是语句的语法出了问题,请大家帮我把把关,谢谢!
ORACLE子查询有order by 报缺失括号
[code=sql]select PM_MODEL_CODE,(select WD_IN_TIME from T_WIP_DETAIL where WD_MODEL_CODE=m.PM_MODEL_CODE and ROWNUM=1 order by WD_IN_TIME) WD_IN_TIMErn from T_PM_MO_BASE m group by PM_MODEL_CODE[/code]rnrn<em>括号</em>里我又必须按时间排序,然后取第一个,求解决方法
oracle写了个简单的分页,一直报括号缺失
存储过程-------rncreate or replace procedure proc8(v_in_table in varchar,v_in_pagesize in number,v_in_pagenow in number,v_out_result out pack2.my_cursor) isrn 2 v_begin number(10);rn 3 v_end number(10);rn 4 v_sql varchar2(3000);rn 5 beginrn 6 v_begin:=v_in_pagesize*(v_in_pagenow-1)+1;rn 7 v_end:=v_in_pagesize*v_in_pagenow;rn 8 v_sql:='select name into v_name from (select a1.*,rownum rn from (select * from '||v_in_table||') a1 where rownum'||v_begin;rn 9 open v_out_result for v_sql;rn 10 end;rn 11 /rn rnjava程序--------rn Class.forName("<em>oracle</em>.jdbc.driver.OracleDriver");rn rn ct=DriverManager.getConnection("jdbc:<em>oracle</em>:thin:@10.1.12.184:1521:orcl","system","manager");rn cs=ct.prepareCall("call proc8(?,?,?,?)");rn cs.setString(1, "student");rn cs.setInt(2,2);rn cs.setInt(3,1);rn cs.registerOutParameter(4,<em>oracle</em>.jdbc.OracleTypes.CURSOR);rn cs.execute();rn rs=(ResultSet)cs.getObject(4);rn while(rs.next())rn System.out.println("name="+rs.getString("name")+" no="+rs.getInt("no"));rn rnrn错误------rnjava.sql.SQLException: ORA-00907: <em>缺失</em><em>右</em><em>括号</em>rnORA-06512: 在 "SYSTEM.PROC8", line 9rnORA-06512: 在 line 1
oracle 用rownum作分页查询时 提示缺失括号??
SELECT * FROM s.employees WHERE employeeid IN(SELECT employeeid FROM s.tax WHERE ROWNUM<=6 ORDER BY tax DESC) rn不知道错在哪了?
时缺少括号错误
我以前用的是mssql,现因工作需要转向Oracle,<em>建</em>一个<em>表</em>的时候,老提示缺少<em>右</em><em>括号</em>:rn sex number(1,0) not null and check(sex=0 or sex=1) and default 0,rn *rnERROR 位于第 6 行:rnORA-00907: 缺少<em>右</em><em>括号</em>rnrn脚本如下,请高手指点:
oracle出现ORA-00907: 缺少括号错误,
SQL> create table yangou(rn 2 id int(32) not null primary key,rn 3 name varchar(30) not null);rnrnid int(32) not null primary key,rn *rnERROR 位于第 2 行:rnORA-00907: 缺少<em>右</em><em>括号</em>rn这是我的<em>建</em><em>表</em>代码,刚学<em>oracle</em>,请大家帮忙,谢谢rncreate table yangou(rn 2 id varchar(32) not null primary key,rn 3 name varchar(30) not null);如果是这样的,就没有错误.rnrn
缺失括号
<em>缺失</em>的<em>括号</em>时间限制:1秒空间限制:65536K一个完整的<em>括号</em>字符串定义规则如下:1、空字符串是完整的。2、如果s是完整的字符串,那么(s)也是完整的。3、如果s和t是完整的字符串,将它们连接起来形成的st也是完整的。例如,&quot;(()())&quot;, &quot;&quot;和&quot;(())()&quot;是完整的<em>括号</em>字符串,&quot;())(&quot;, &quot;()(&quot; 和 &quot;)&quot;是不完整的<em>括号</em>字符串。牛牛有一个<em>括号</em>字符串s,现在需要在其中任意位置尽
oracle视图提示缺少括号
1.创<em>建</em>视图中的select 语句单独执行查询没问题,在外面包上 create or replace view v_视图名 as() 时报ORA-00907:<em>缺失</em><em>右</em><em>括号</em>rn2.创<em>建</em>视图中的查询语句大体如下rnrn```rn select rn CBS.id,rn CBS.name,rn CBS.ST,rn BBI.id,rn BBI.update_time,rn BBI.rcrd_st rn from CBS left join BBI rn on CBS.id=BBI.idrn where CBS.ST='1'rn order by BBI.update_time desc rn rn```rnrn3:之前没有加上order by条件时可以<em>建</em>视图成功,加上后,内部的select语句单独查询没问题,<em>建</em>视图时报缺少<em>右</em><em>括号</em>
RANK的时候报缺失括号(大虾帮忙看下)
以下是SQL语句rnselect NO1,rank() over(order by CreateDate desc) from tablern放在PL/SQL中可以执行,但是放在程序中就报错说<em>缺失</em><em>右</em><em>括号</em>。哪位大虾知道为什么啊=。=
紧急求助 SQL语句编译后提示缺失括号
select 地市名称, 堤名,起始桩号,终止桩号,日期,超设防水位堤段长度,超警戒水位堤段长度,超保证水位堤段长度,备注 from ( select 报<em>表</em>编号,堤名,起始桩号,终止桩号,日期,超设防水位堤段长度,超警戒水位堤段长度,超保证水位堤段长度,备注 from TBRT1404_DFBF) XG left join (select 报<em>表</em>编号,地市名称,填报单位名称 from TBRT0001_BTXX left join TBRT0003_DISTRICT on TBRT0001_BTXX.行政区划代码=TBRT0003_DISTRICT.县区代码 where TBRT0001_BTXX.审核标识='110' 6 ) XZ on XG.报<em>表</em>编号=XZ.报<em>表</em>编号)and 日期 between to_date('2001-06-01','yyyy-MM-dd') and to_date('2009-06-12','yyyy-MM-dd') order by 地市名称, 堤名
c++builder中的SQL语句出错:ORA-00907:缺失括号
c++builder中的SQL语句出错:rn AnsiString stime,etime;rn stime="2008-12-9 1:18:00"; rn etime="2008-12-9 3:25:00"; rn ADOQuery1->Close();rn ADOQuery1->SQL->Clear();rn ADOQuery1->SQL->Add("Select distinct tag_value.* from tag_value where tag_value.clock> to_date('"+stime+"','yyyy-mm-dd hh24:mi:ss') and tag_value.id=134 or tag_value.id=129 or tag_value.id=130 and tag_value.clock[/color]) order by tag_value.clockrn就不会出错!rn搞不清楚是怎么回事?请教各位大侠!
缺失括号"的错误)">使用别名应注意(报"缺失括号"的错误)
(Oracle测试)使用SQL语句的select语句是经常会用到字段和<em>表</em>的的别名,使用要注意,字段的别名前面可以加as关键字,或是省略不写,但是<em>表</em>名的别名前面不可以加as,否则会报如下错误: [color=red]命令出错, 行: 11 列: 20 错误报告: SQL 错误: ORA-00907: <em>缺失</em><em>右</em><em>括号</em> 00907. 00000 - &quot;missing right parenth...
第 12 行出现错误: ORA-00907: 缺失括号
create table T_RECV_MSG (rn DBID number(11) not null,rn STATUS number(11) default 0,rn SEQID varchar(20) default '',rn CALLNO varchar(20) default '',rn DSTCALLNO varchar(20) default '',rn SERVICEID varchar(20) default '',rn LINKID varchar(20) default '',rn SENDTIME date default sysdate,rn CONTENT varchar(4000) default '',rn OPERATOR varchar(20) default '',rn UDHI int(11) default -1, rn primary key (DBID)rn);rnUDHI int(11) default -1,rn *rn第 12 行出现错误:rnORA-00907: <em>缺失</em><em>右</em><em>括号</em>rn求教,哪错了rn
SQL语句编译后提示缺失括号
select TBL_TOPIC.* from TBL_TOPIC rn where boardId=1 rn and topicId not in (select topicId from TBL_TOPIC where boardId=1 and rownum<20 order by publishTimern正确rnrn请问怎么回事啊?
解析sql语句时出现缺失括号
select tb.hospital_no,sum(tb.costs),sum(tb.rc),sum(tb.xy_costs),sum(tb.zy_costs),sum(tb.cy_costs),rnsum(tb.matri_costs),sum(tb.blood_costs),sum(tb.x_costs),sum(tb.lab_costs),sum(tb.bed_costs),rnsum(tb.other_costs),sum(tb.fl_costs),sum(tb.o_costs),sum(tb.zc_costs),sum(tb.food_costs),rnsum(tb.ss_costs),sum(tb.zl_costs),sum(tb.hl_costs),sum(tb.jl_costs),sum(tb.ect_costs),rnsum(tb.dsa_costs),sum(tb.mri_costs),sum(tb.ct_costs) rnfrom (select (case r.hospital_no when '01' then '城中院区' else '阳湖院区'end) hospital_no,t.patient_id,t.visit_id,rndecode(sum(t.costs),0, '', to_char(sum(t.costs), '9999999999.99')) as costs, count(*) as rc, rndecode(sum(t.xy_costs),0, '', to_char(sum(t.xy_costs), '9999999999.99')) as xy_costs, rndecode(sum(t.zy_costs),0, '', to_char(sum(t.zy_costs), '9999999999.99')) zy_costs, rndecode(sum(t.cy_costs),0, '', to_char(sum(t.cy_costs), '9999999999.99')) cy_costs, rndecode(sum(t.matri_costs),0, '', to_char(sum(t.matri_costs), '9999999999.99')) matri_costs, rndecode(sum(t.blood_costs),0, '', to_char(sum(t.blood_costs), '9999999999.99')) blood_costs, rndecode(sum(t.x_costs),0, '', to_char(sum(t.x_costs), '9999999999.99')) x_costs, rndecode(sum(t.lab_costs),0, '', to_char(sum(t.lab_costs), '9999999999.99')) lab_costs, rndecode(sum(t.bed_costs),0, '', to_char(sum(t.bed_costs), '9999999999.99')) bed_costs, rndecode(sum(t.other_costs),0, '', to_char(sum(t.other_costs), '9999999999.99')) other_costs, rndecode(sum(t.fl_costs),0, '', to_char(sum(t.fl_costs), '9999999999.99')) fl_costs, rndecode(sum(t.o_costs),0, '', to_char(sum(t.o_costs), '9999999999.99')) o_costs, rndecode(sum(t.zc_costs),0, '', to_char(sum(t.zc_costs), '9999999999.99')) zc_costs, rndecode(sum(t.food_costs),0, '', to_char(sum(t.food_costs), '9999999999.99')) food_costs, rndecode(sum(t.ss_costs),0, '', to_char(sum(t.ss_costs), '9999999999.99')) ss_costs, rndecode(sum(t.zl_costs),0, '', to_char(sum(t.zl_costs), '9999999999.99')) zl_costs, rndecode(sum(t.hl_costs),0, '', to_char(sum(t.hl_costs), '9999999999.99')) hl_costs, rndecode(sum(t.jl_costs),0, '', to_char(sum(t.jl_costs), '9999999999.99')) jl_costs, rndecode(sum(t.ect_costs),0, '', to_char(sum(t.ect_costs), '9999999999.99')) ect_costs, rndecode(sum(t.dsa_costs),0, '', to_char(sum(t.dsa_costs), '9999999999.99')) dsa_costs, rndecode(sum(t.mri_costs),0, '', to_char(sum(t.mri_costs), '9999999999.99')) mri_costs, rndecode(sum(t.ct_costs),0, '', to_char(sum(t.ct_costs), '9999999999.99')) ct_costs rnfrom HIS.BI_YBJZ_DETAIL t rnleft join his.dept_vs_class q on t.dept_code = q.dept_code left join his.dept_class r on q.ksbm = r.ksbmrnwhere t.js_date >= trunc(sysdate, 'yyyy') and t.js_date <= trunc(sysdate) and r.hospital_no is not null group by r.hospital_no, t.patient_id, t.visit_id ) tb group by tb.hospital_no
缺失括号+括号匹配深度
<em>缺失</em>的<em>括号</em> 题目描述 一个完整的<em>括号</em>字符串定义规则如下: 1、空字符串是完整的。 2、如果s是完整的字符串,那么(s)也是完整的。 3、如果s和t是完整的字符串,将它们连接起来形成的st也是完整的。 例如,"(()())", ""和"(())()"是完整的<em>括号</em>字符串,"())(", "()(" 和 ")"是不完整的<em>括号</em>字符串。 牛牛有一个<em>括号</em>字符串s,现在需要在其中任意位置尽量少地添加<em>括号</em>,将...
ORACLE 缺少括号 紧急求助
rnselect S.STATION_NAME AS station_name, rn(select E.ID from OM_ELEC_DETAIL E where S.ID=E.BASE_ID and rownum<2 order by E.ID desc) AS chargeId rn rn from OM_BASE_STATION S rn rn在ORacle 中运行 报错:缺少<em>右</em><em>括号</em>;请高手帮我解决,本人很少写ORACLE语句。rnrn解决为谢!!! rn
报错“缺少括号
请问各位:我把Oracle9i和自己用vc写的程序放在同一台电脑上,执行select scott.emp.*,(select dname from scott.dept where scott.dept.deptno=scott.emp.deptno) from scott.emprn 就会报错“缺少<em>右</em><em>括号</em>”,VC的程序放在只装客户端的电脑上运行就正常,那位大侠遇到这种情况的
ORA-00907: 缺少括号
[img]http://dl2.iteye.com/upload/attachment/0094/0197/219d7536-01cb-3617-8b6b-9454ad67bf83.jpg[/img] 在一个应用系统,提供了运行 ORQCLE SQL 的功能。对于简单的 SQL 语句的运行一切正常,而对于有子查询的复杂 SQL 语句,经常会出现错误。但是,这个语句在 DQL PLUS 中运行...
缺少括号错误
rn这段代码ie老报错:缺少‘)’ 。高手帮忙看看咋回事儿吧。
缺少括号问题
为什么这句话在PL/sql里执行没有问题。 SELECT WHSCODE,sum(CASE when status='空' then 1 else 0 end) NULLTorrNums FROM WAREHOUSEPOSITION GROUP BY WHSCODE rn带到程序中,就报错,说缺少<em>右</em><em>括号</em>。我原来以为是单引号截断sql语句。但是后来改成 CASE when 1=1 then 1 else 0 endrn仍然报错。不知道什么原因。请帮忙。
ora 丢失括号
select * from ( select distinct * from ( select ctm.id_ ctmId , ctm.name_ ctmName , ctr.id_ ctrId , ctr.name_ ctrName , ctr.email_ ctrEmail , ctr.mphone_ ctrMphone , ctr.brithday_ ctrBrithday from contacter_ ctr inner join customer_ ctm on ctr.fk_customer_ = ctm.id_ inner join user_ u on ctm.fk_user_ = u.id_ inner join ctm_ctg_lk_ ctmCtg on ctmCtg.fk_ctm_ = ctm.id_ inner join ctm_ctg_ cc on ctmCtg.fk_ctm_ctg_ = cc.id_ where ctr.brithday_ like '%-04-12' and u.id_ in '5dfaf039298290ee0129d51355e5029e' regexp_like( ctr.mphone_ , '^((13[0-9])|(15[^4,\D])|(18[0,5-9]))\d8$' ) ) order by ctmId asc )where rownum <= ?rnrnrn高手来帮忙看看这是怎么回事rn
VSCode跳出括号
VSCode自动完成功能会在我们打左<em>括号</em>的时候自动完成<em>右</em><em>括号</em>,可是,非常郁闷的是,在这个编辑状态下,却无法像其他编辑器一样通过按Tab或Enter键跳出<em>右</em><em>括号</em>到行尾。 虽然VSCode有强大的按键自定义功能,但初学者看起来还是头晕。 而且居然百度不到,故起此贴。 在这个Issue下找到相对简单的解决方法,就是安装Tabout插件。 https://github.com/Microso...
ora-00907 缺少括号
我在我的数据库中对另一个数据库<em>建</em>立了链路,并对一个本<em>建</em>了同义词,访问没有问题。rn 我想利用一个过程把这个<em>表</em>的数据导入的我本地服务器中。rn 我<em>建</em>了一个RECORD,中有一个字段类型是DATE的,对应远程<em>表</em>中一个DATE类型字段,rn 但是FETCH后,组成生成的SQL语句的时候,字段的数据由YYYY-MM-DD HH24:MI:SS变成了DD-MM-YY形式了。rn 所以在执行SQL语句时,提示ora-00907 缺少<em>右</em><em>括号</em>rn 我本地数据的DATE类型格式也为YYYY-MM-DD HH24:MI:SS,但是FETCH后为什么格式变了呢?
菜鸟请教,在PLSQL中创,提示“缺少括号
create table S(Sno CHAR(5) not null unique,Sname char(30) unique,Status char(8),City char(20) primary key (Sno));rnrncreate table P(Pno char(6),Pname char(30) not null,Color char(8),Weight numeric(6,2),City char(20) primary key(Pno));rnrncreate table SP(Sno char(5),Pno char(6),Status char(8),Qty numeric(9) primary key(Sno,Pno),foreign key(Sno) reference S(Sno), Foreign key (Pno) references P(Pno));rnrn这三行都缺啊。。。。。
新人求助,过程提示缺少括号
使用create table<em>建</em><em>表</em>,运行过程中数据报错“缺少<em>右</em><em>括号</em>”,将头围两个<em>括号</em>删去后,即可顺利运行,成功<em>建</em><em>表</em>,请前辈们帮忙看一下。rn运行报错的语句:rncreate table TMP_RATE_DAFAX_2_y_countrnasrn(selectrn ibk_no,rn count,rn count(*) 我行客户数,rn sum(bal_rmb_20131231) 余额_2013123,rn sum(bal_rmb_20140331) 余额_20140331,rn sum(amount) 代发金额,rn (sum(bal_rmb_20140331) -sum(bal_rmb_20131231))/sum(amount) 留存率rn fromrn TMP_RATE_DAFAX_2_y_newrn group by ibk_no,rn count order by ibk_no);
(7名同志回答都错了,救我)oracle语句错误,缺失括号,怎么解决
## 谢谢各位,问题我自己解决了代码如下:rn![图片说明](https://img-ask.csdn.net/upload/201712/18/1513582884_846993.png)rnrnrnrn## # 我感觉下面同志回答肯定有对的,会不会还有其他地方引起的问题??rnrn请给出修改代码,谢谢rnrnrnSELECTrn CSL.LOG_ID,rn CSL.USER_ID,rn CSL.USERNAME,rn CSL.DESCRIPTION,rn CSL.METHODS,rn CSL.LOG_TYPE,rn CSL.REQUEST_IP,rn CSL.EXCEPTIONCODE,rn CSL.EXCEPTION_DETAIL,rn CSL.PARAMS,rn CSL. TIME,rn ROWNUM AS rownornFROMrn (rn (rn (SELECT * FROM CMU_USERS START WITH USER_ID = 1 CONNECT BY PRIOR USER_ID = PID ) Urn LEFT OUTER JOIN CMU_SYSTEM_LOG CSL ON U .USER_ID = CSL.USER_IDrn WHERE CSL.USER_ID IS NOT NULL ORDER BY TIME DESCrn )rn WHERE ROWNUM 1rnrnrn图片:![图片说明](https://img-ask.csdn.net/upload/201712/18/1513569336_342395.png)rnrn**这样的语句是可以查出数据的,加上分页查询就查不出了,前端使用的是easyUI框架:**rnSELECTrn CSL.LOG_ID,rn CSL.USER_ID,rn CSL.USERNAME,rn CSL.DESCRIPTION,rn CSL.METHODS,rn CSL.LOG_TYPE,rn CSL.REQUEST_IP,rn CSL.EXCEPTIONCODE,rn CSL.EXCEPTION_DETAIL,rn CSL.PARAMS,rn CSL. TIMErnFROMrn (SELECT * FROM CMU_USERS START WITH USER_ID = 1 CONNECT BY PRIOR USER_ID = PID ) Urn LEFT OUTER JOIN CMU_SYSTEM_LOG CSL ON U .USER_ID = CSL.USER_IDrn WHERE CSL.USER_ID IS NOT NULL ORDER BY TIME DESCrn rn rn如果告诉我另一种分页的查询方法也可以。一页显示20条
oracle中创t_log之后,执行时出现缺失括号的错误,该如何解决
<em>oracle</em>中创<em>建</em>完<em>表</em>t_log之后,执行时出现<em>缺失</em><em>右</em><em>括号</em>的错误,百度了一下,有的网友说,把auto increment去掉就可以了,试了一下不行,我检查了一下,语句中不缺<em>右</em><em>括号</em>,<em>括号</em>也都是英文字符,请问大神们这个问题该咋解决?[img=https://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin/001/face/21.gif][/img]rn[img=https://img-bbs.csdn.net/upload/201807/30/1532950367_420699.jpg][/img]
哪位高手:缺少括号
SQL Server 2000里执行好好的,拿到Oracle9i里就不行,说缺少<em>右</em><em>括号</em>(当然是把SUBSTRING改为substr的),什么意思啊,我google翻了半天,也没找出结论:rnrnselect xzjd_mc,sum(jfxzc_mj)as jfxzc_mj,rnsum(cw325) as cw325 rnfromrn(rnselect XZJD_MC, B.jfxzc_mc,B.JFXZC_MJ,B.QX_DM,B.zq_dm,B.jfxzc_dm,rn(select sum(tb_mj) from ST_DLTB where DL_DM='325' and SZXZC_DM=JFXZC_MC group by JFXZC_MC)as cw325 rnfrom st_xzorjd as Arninner join st_jforxzc as B on SUBSTRING(A.XZJD_DM,7,3)=B.zq_dm rn) as Brngroup by xzjd_mc
算术达式补全括号(algs4)
栈的应用 package _1_3linkedList; import java.util.Scanner; /*1.3.9从标准输入中得到一个缺少左<em>括号</em>的<em>表</em>达式并打印出补全<em>括号</em>之后的中序<em>表</em>达式 */ public class _1_3_9CompleteBracket { public static void main(String[] args) { String s=new
函数左括号括号跳转
Ctrl键+]键
左,括号的配对问题
做一个复合查询,包括且,或,以及()的条件,当用户点击<em>右</em><em>括号</em>时,我怎么判断他前面一定输入了左<em>括号</em>大家有没有例子参考一下。
ado打开Oracle的程序的路径为什么不能包含括号')'
我有个exe文件通过ado方式打开数据库rn当exe文件所在的路径没有包括<em>右</em><em>括号</em>')',能正常打开数据库rn当exe文件所在的路径含有<em>右</em><em>括号</em>')',就不能正常打开数据库,返回下面的错误rn错误描述:ORA-06413: 连接未打开rnrn大家知道为什么吗??
oracle
1、创<em>建</em><em>表</em>的同时创<em>建</em>主键约束 (1) 无命名 create table student ( studentid int primary key not null, studentname varchar(8), age int); (2) 有命名 create table students ( studentid int , studentname varchar(8), age int, con...
ORACLE
create user lmyf identified by lmyf;    create tablespace lmyf_data datafile 'D:\ORACLE_DB\lmyf_data.dbf' size 1024m;    alter user lmyf default tablespace lmyf_data;    grant create session,cre
oracle
create table person( id number(10), email varchar2(40), nickname varchar2(20), pwd varchar2(20), age number(10) ); select * from person; commit; insert into person values(1,'hgh@163.com','feifei','1234567',22); commit;
请教::oracle 分页SQL语句错误:缺少括号...
Select * From (Select temp_Table.*,ROWNUM rn From ( Seclect * From info)temp_Table where ROWNUM=?rnrn错误提示:缺少<em>右</em><em>括号</em>。rn请问该如何解决,多谢!
这个SQL语句在ORACLE报缺少括号
select * from meta_ruledetail_gui u rnwhere u.guide_line inrn(rn select t.guide_line from meta_hot_count_gui t where rownum<2 group by t.guide_line order by sum(t.hot_count) desc rn)rnrn把order by sum(t.hot_count) desc 去掉后就没有错了,rn
oracle 语句中 case when缺少括号
select substr(to_char(t.grosstime,'yyyy-mm-dd'),9,10) as dates ,rnsum(decode(varno, '0102010105000000', netweight,0)) "JMton",rnsum(case when t.borrowflag='0'and t.varno='0102010105000000'then 1 else 0 end) as "JMnum",rnfrom table_1 trnwhere to_char(t.grosstime, 'yyyy-mm') = '2010-10' and t.minecode="150000" and t.transway='1' and t.flag='1' rngroup by substr(to_char(t.grosstime,'yyyy-mm-dd'),9,10)rnorder by substr(to_char(t.grosstime,'yyyy-mm-dd'),9,10)rnrn用plsql执行没问题,在报<em>表</em>中就报缺少<em>右</em><em>括号</em>。。。主要就是第三行case when,该怎么办呢?
oracle 使用union提示ORA-00907:缺少括号
在使用union的时候提示:ORA-00907:缺少<em>右</em><em>括号</em> 此原因是因为在union的左边和<em>右</em>边都有order by,因此需要去掉一边的order by,保留一个即可。 select * from  (  select id,name from emp order by name union  select id,name from emp )
执行ORACLE SQL语句,报ora-00907 缺少括号
select slm,substr(id,1,1) lb,sum(zajs) ajsnum,sum(wz) wznum,sum(tzz) tzznum,sum(dt) dtnum from ywk_xmxx join xtwh_struct_class on dh like 'substr(id,1,1)%' where length(slh)=2 and rnjgrq>=To_date(2010-7-1 00:00:00,'yyyy-mm-dd hh:mm:ss') and rn jgrq) group by slm,substr(id,1,1) rnrn请各位大侠帮忙分析下,谢谢
oracle删除数据时 ORA-00907: 缺少括号
sql语句:delete from test.tableA;rn就提示:ORA-00907: 缺少<em>右</em><em>括号</em>rn我不懂,我哪写错了?~~
oracle
<em>oracle</em><em>建</em><em>表</em>
oracle
SQL> create tablespace longs datafile 'D:\long.dbf' size 100M autoextend on;rnSQL> create user hll identified by hll default tablespace longs;rnSQL> grant dba to hll;rnSQL> create table stu(rn 2 id int primary key not null,rn 3 name char(20) not null,rn 4 age int);rnSQL> commit;rn提交完成。rnrnrn[b]我在sqlplus下<em>建</em>立了上面的<em>表</em>rn用户hll授予dba权限rn这时候我在 plsql下 用system/<em>oracle</em> orcl normal 登陆可以看到<em>表</em>sturnhll/hll orcl normal 登陆后, tables下是空的??是不是还要在配置向导下<em>建</em>立个数据库 ??rn这个orcl是数据库名字,监听名字也可以是orcl?rnrnplsql 用hll怎么连??<em>表</em>空间和数据库,<em>表</em>之间的关系还是很乱啊rn用惯了sql server,mysql转不过了弯了[/b]rnrn[size=24px]大侠给理顺理顺吧。。。[/size]rnrnrnrnrnrnrnrn
Oracle
安装好的Oracle 10g,没有附带S_EMP什么的<em>表</em>,请问在哪可以弄到?或者哪位大虾有<em>建</em><em>表</em>的脚本的,发一份给我呗,谢谢了!szjiazongwei@hx.sodiedu.com.cn
【一次过】【2018爱奇艺】缺失括号
题目描述 一个完整的<em>括号</em>字符串定义规则如下: 1、空字符串是完整的。 2、如果s是完整的字符串,那么(s)也是完整的。 3、如果s和t是完整的字符串,将它们连接起来形成的st也是完整的。 例如,"(()())", ""和"(())()"是完整的<em>括号</em>字符串,"())(", "()(" 和 ")"是不完整的<em>括号</em>字符串。 牛牛有一个<em>括号</em>字符串s,现在需要在其中任意位置尽量少地添加<em>括号</em>,将其转化为一个完...
爱奇艺校招----缺失括号(Python)
一、题目 题目描述 一个完整的<em>括号</em>字符串定义规则如下: 1、空字符串是完整的。 2、如果s是完整的字符串,那么(s)也是完整的。 3、如果s和t是完整的字符串,将它们连接起来形成的st也是完整的。 例如,"(()())", ""和"(())()"是完整的<em>括号</em>字符串,"())(", "()(" 和 ")"是不完整的<em>括号</em>字符串。 牛牛有一个<em>括号</em>字符串s,现在需要在其中任意位置尽量少地添加<em>括号</em>,将...
Oracle缺失括号错误
Oracle在创<em>建</em><em>表</em>的时候,报了一个错误:[Err] ORA-00906: missing left parenthesis。 以下是创<em>建</em><em>表</em>的源代码: CREATE TABLE TB_SALES_PO_FR ( "ID" NUMBER NOT NULL , "BUSINESSID" VARCHAR2 NULL , "BUSINESS" VARCHAR2(50) NULL , "WORKCOD
oracle with as 缺失 SELECT 关键字
WITH rn STUC AS(rn SELECT * FROM FW_STUDENT rnrn )rn B AS (rn SELECT * FROM FW_STUDENT rn WHERE STUDENTNAME = '张天'rn rn ) rn SELECT rn STUC.STUDENTNO rn ,B.STUDENTNAME rn FROM STUC ,Brnrn<em>缺失</em> SELECT 关键字rnrn帮忙看看了
oracle查询缺失数据
with tab as ( rn select '2001' d from dual union all rn select '2002' d from dual union all rn select '2003' d from dual union all rn select '2006' d from dual union all rn select '2007' d from dual union all rn select '2008' d from dual)rnSELECT SSrn FROM (SELECT SN + (level - 1) SSrn FROM (select min(d) SN,max(d) EN from tab) Trn CONNECT BY SN + (level - 1) <= EN)rnWHERE SS NOT IN (SELECT d FROM tab)rnrn各位大神,这样数据大了好慢。有没有能快点的。
oracle缺失达式
create or replace view v_SpendIncomeRatio as select col.collegesId, sum(inc.tuitionCount)+sum(inc.subsidyCount)+sum(inc.sepcialFunCount)+inc.otherIncomeAmount+sum(inc.donatedValue)+sum(soc.donate...
oracle安装包缺失错误
Q: cannot create /tmp/OraInstall2017-10-04_02-40-22PM/jdk/jre/lib/amd64/motif21 unable to process jdk/jre/lib/amd64/motif21/libmawt.so. checkdir error: cannot create /tmp/OraInstall2017-10-04_02-49-
Oracle缺失达式
INSERTrnINTO 指标基本信息<em>表</em>rn (rn 指标编号 ,rn 指标代码 ,rn 指标名称 ,rn 数据类型 ,rn 控件类型 ,rn 有效标志 ,rn 最大记录数,rn 创<em>建</em>人 ,rn 创<em>建</em>时间 ,rn 修改人 ,rn 修改时间 ,rn 指标说明 ,rn 备注rn )rn VALUESrn (rn PK_指标基本信息<em>表</em>.NEXT_val ,rn 'KCSZ_SJKSS1' ,rn '实践课时比例(%)' ,rn '文本' ,rn '文本' ,rn '是' ,rn 300 ,rn 1 ,rn '2011/6/1' ,rn 1 ,rn '2011/6/1' ,rn '无' ,rn '无'rn );rnrn<em>缺失</em>什么<em>表</em>达式?
c语言版学生信息管理系统下载
实现了对学生信息的更新,删除,排序,查找等功能 相关下载链接:[url=//download.csdn.net/download/nxlujiangbo/2827611?utm_source=bbsseo]//download.csdn.net/download/nxlujiangbo/2827611?utm_source=bbsseo[/url]
jQuery延迟加载下载
jQuery的一款图片特效,让页面上的图片延迟加载,增加用户体验。 相关下载链接:[url=//download.csdn.net/download/u011014032/5552753?utm_source=bbsseo]//download.csdn.net/download/u011014032/5552753?utm_source=bbsseo[/url]
一元云购系统V3.0最新商业破解版下载
一元云购系统V3.0最新商业破解版,保证不出弹窗,跟官方同步更新 相关下载链接:[url=//download.csdn.net/download/red12red/7379051?utm_source=bbsseo]//download.csdn.net/download/red12red/7379051?utm_source=bbsseo[/url]
相关热词 c# 去空格去转义符 c#用户登录窗体代码 c# 流 c# linux 可视化 c# mvc 返回图片 c# 像素空间 c# 日期 最后一天 c#字典序排序 c# 截屏取色 c#中的哪些属于托管机制
我们是很有底线的