ORA-00907:缺失右括号 [问题点数:40分,结帖人u011619090]

Bbs1
本版专家分:0
结帖率 75%
Bbs7
本版专家分:13343
Bbs3
本版专家分:886
Blank
GitHub 绑定GitHub第三方账户获取
Bbs1
本版专家分:0
Bbs1
本版专家分:0
Bbs2
本版专家分:194
Bbs6
本版专家分:8699
Blank
蓝花 2017年7月 Java大版内专家分月排行榜第三
Bbs3
本版专家分:886
Blank
GitHub 绑定GitHub第三方账户获取
Bbs3
本版专家分:881
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> rn 请各位帮忙!rn 数据库使用的是 oracle数据库。rn rn 同样的语句 下面的创建表就可以执行: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
ORA-00907: 缺失括号问题整理解决
ORA-00907: <em>缺失</em>右<em>括号</em>前言        最近在开发过程中使用oracle数据库,在程序中进行查询数据时遇到了“ORA-00907: <em>缺失</em>右<em>括号</em>”的问题,但是如果直接把sql语句直接在数据库或PL/SQL中执行时,却又能够正常查询,为了解决这个问题,折腾了半天,查找了一些资料,所以就对各种导致出现“<em>缺失</em>右<em>括号</em>”的情况进行了整理总结。行文如下。1 union all中order by 导致
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>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>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>rnrn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)rn at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)rn at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)rn at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)rn at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)rn at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)rn at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)rn at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)rn at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1116)rn at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)rn at oracle.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: 缺失括号与左括号问题总结
在创建数据表总结如下:  1.date限定字段大小的时候,会报错,比如,将date(12)去掉(12);  2.关键字顺序有误,也会报这样的错;  3.创建表时,如果表有关键字,用双引号括起来;  4.如果创建表时,未对字段中的表设置长度,也会报错;  5.创建主外键约束时外键类型跟主键类型不完全一致,也是会报错的。  ...
ORA-00907: 缺少右括号
[img]http://dl2.iteye.com/upload/attachment/0094/0197/219d7536-01cb-3617-8b6b-9454ad67bf83.jpg[/img] 在一个应用系统,提供了运行 ORQCLE SQL 的功能。对于简单的 SQL 语句的运行一切正常,而对于有子查询的复杂 SQL 语句,经常会出现错误。但是,这个语句在 DQL PLUS 中运行...
ora-00907 缺少右括号
我在我的数据库中对另一个数据库建立了链路,并对一个本建了同义词,访问没有问题。rn 我想利用一个过程把这个表的数据导入的我本地服务器中。rn 我建了一个RECORD,中有一个字段类型是DATE的,对应远程表中一个DATE类型字段,rn 但是FETCH后,组成生成的SQL语句的时候,字段的数据由YYYY-MM-DD HH24:MI:SS变成了DD-MM-YY形式了。rn 所以在执行SQL语句时,提示<em>ora-00907</em> 缺少右<em>括号</em>rn 我本地数据的DATE类型格式也为YYYY-MM-DD HH24:MI:SS,但是FETCH后为什么格式变了呢?
第 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>rn求教,哪错了rn
缺失括号的问题??
[code=SQL]rn我现在有一个这样的 过程 rn但是执行总是报 <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]
缺失括号
例如:rncrate table a(id not null number(4)); 就会报错:缺少")"rn但是:rncreate table a(id number(4) not null); 就不会报错。rn为什么呢?rnnot null 一定要放到后面吗?
缺失括号问题
最近刚开始学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>。百思不得其解~~~rn分不多了,希望大家不吝赐教
缺失括号????
我在创建一个表时,这两行老师提示<em>缺失</em>右<em>括号</em>rn去掉这两行就没问题rn没<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
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搞不清楚是怎么回事?请教各位大侠!
数据库建表的问题 ORA-00907: 缺失括号问题!!!???
报错:ORA-00907: <em>缺失</em>右<em>括号</em>问题!!!???rnrn我的建表脚本如下所示: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查询语句老是报ORA-00907缺失括号
--大家好,我有一条oracle查询语句老是报ORA-00907<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>,一定是语句的语法出了问题,请大家帮我把把关,谢谢!
奇怪的问题 ORA-00907: 缺少右括号
一个非常奇怪的问题rnrn存储过程建立如下rnCREATE OR REPLACE PROCEDURE go (id integer)rnIS rnBEGIN rn return;rnEND go;rnrn在 SQL Plus中调用结果如下rnrnSQL> call go(0);rnrnMethod calledrnrnSQL> call go(id => 0);rnrncall go(id => 0)rnrnORA-00907: 缺少右<em>括号</em>rnrnSQL> rnrnrn怎么会有 ORA-00907: 缺少右<em>括号</em> 这个错误
oracle 建表缺失括号
CREATE TABLE BSI_AREA(rn ADCODE VARCHAR(20) NOT NULL,rn AREANAME VARCHAR(100),rn AREAPOLYSTR CLOB(1048576),rn AREACENTERLON DECIMAL(19,15),rn AREACENTERLAT DECIMAL(19,15),rn CITY_ID VARCHAR(20),rn PARENTID VARCHAR(12),rn CONSTRAINT PK_BSI_AREA PRIMARY KEY(ADCODE));rnrn以上是语句,建好了很多表都是这么写的,这个表就说啥都报错,SQL 错误: ORA-00907: <em>缺失</em>右<em>括号</em>。rn自己尝试给表里的列分别删了就留一列还是不好用,无法定位问题原因,水平比较低,肯定各位大神走过路过帮忙看看。
sql语句缺失括号
我是根据前台传过来的年龄段对人员表里的生日字段进行查询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谢谢大家
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>,但是在数据库中可以运行出来,这是什么原因
老提示:ORA-00907: 缺少右括号
我在ORCALE里面建表,老提示错误:ORA-00907: 缺少右<em>括号</em>rnCREATE TABLE myuser2(rnid int(11) not null,rnusername varchar(200) not null,rnpassword varchar(20) not null,rnage int,rnprimary key (id)rn)rnENGINE=MyISAM DEFAULT CHARSET=GBK;rnrn请高手指教
ORA-00907: 缺少右括号(sql的问题)
下面是jsp的一点代码rnrn//取得当前时间rnjava.util.Date date=new java.util.Date();rnString year=String.valueOf(date.getYear()+1900);rnString mon=String.valueOf(date.getMonth()+1);rnString day=String.valueOf(date.getDate());rnString hour=String.valueOf(date.getHours());rnString min=String.valueOf(date.getMinutes());rnString sec=String.valueOf(date.getSeconds());rnrnString sql_post="insert into R_text values(R_TEXT_SEQ.nextval,";rnsql_post+=title+",";rnsql_post+=body;rnsql_post+=",'applytype',";rnsql_post+="todate(year-mon-day hour:min:sec,'yyyy-mm-dd hh24:mi:ss')";rnsql_post+=",'author',";rnsql_post+="'provide',";rnsql_post+="'searchkey',";rnsql_post+="todate(year-mon-day hour:min:sec,'yyyy-mm-dd hh24:mi:ss')";rnsql_post+=",'videopath',";rnsql_post+="'texttype',";rnsql_post+="'authorinfo',";rnsql_post+="todate(year-mon-day hour:min:sec,'yyyy-mm-dd hh24:mi:ss'),";rnsql_post+="10,";rnsql_post+="'course')";rnrnrntryrnstmt_post.executeUpdate(sql_post);rncatch (SQLException e) rn System.out.println("sql failed :"+e.toString());rn rn===========下面执行结果=============rnsql failed :java.sql.SQLException: ORA-00907: 缺少右<em>括号</em>
ORA-00907: 缺少右括号 错误 急!!!
declare rnv_sql varchar2(1024);rnbeginrnv_sql := 'create global temporary table t_temp_accountrn (materialID varchar2(7),rn start_amount number(5,0),rn start_money number(10,2),rn in_amount nmuber(5,0),rn in_money number(10,2),rn out_amount number(5,0),rn out_money number(10,2),rn finish_amount number(5,0),rn finish_money number(10,2)rn )on commit preserve rows';rn execute immediate v_sql;rnend;rn执行后 出现错误rndeclarern*rnERROR 位于第 1 行:rnORA-00907: 缺少右<em>括号</em>rnORA-06512: 在line 15rn我的sql语句没有错误的阿 找了半天 望高手指教!
oracle 插入数据时缺失括号???
这是我建的表: 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>这个错误,大家帮帮忙吧!我是新手,很多都不懂。谢谢哈!rn这是我插入的数据:insert into users select ('1','david','123456')。
新手求教,缺失括号异常。
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>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段代号也是好的,怎么回事啊????
一存储过程,提示缺失括号问题
一个按时间做的范围分区,现做了一个通用的存储过程,代码如下: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');--表名,范围分区名,时间,表空间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>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向各位请教,存储过程该如何改进下。。。
orcal 建表 缺失括号 怎么弄?
create table T_KP_USERSrn(rn ID numeric(6) not null auto_increment comment '用户ID',rn USERNAME varchar(30) not null comment '用户名称',rn PASSWD varchar(32) not null comment '密码',rn NAME varchar(30),rn SEX varchar(1) comment '1:男rn 2:女',rn PHONE varchar(30),rn SYSTMID varchar(20) comment '所属哪个系统rn 1:监控rn 2:企业在线rn 3:动态稽查rn 4:营运分析rn 5:系统管理rn 6:信息发布rn 7:服务质量信息考核',rn ROLE_ID numeric(6) not null comment '角色ID',rn ID_OWNER numeric(18),rn USER_STAT varchar(1) not null comment '0:注销状态rn 1:正常状态',rn MEMO VARCHAR2(200) comment '备注',rn CJSJ datetime,rn CJCZY varchar(30),rn ZHDLSJ datetime,rn ZHDLIP varchar(15),rn primary key (ID)rn)rntablespace TS_BUSI;
插入一条数据库语句报[Error Code: 907, SQL State: 42000] ORA-00907: 缺失括号
create table tbagreement (rn "contract_no" VARCHAR(26) not null default ' ',rn "in_client_no" VARCHAR(20) not null default ' ',rn "bank_no" VARCHAR(2) not null default ' ',rn "prd_manager" VARCHAR(6) not null default ' ',rn "trans_date" INTEGER not null default '0',rn "trans_time" INTEGER not null default '0',rn "channel" VARCHAR(1) not null default ' ',rn "oper_no" VARCHAR(32) not null default ' ',rn "branch_no" VARCHAR(16) not null default ' ',rn "close_date" INTEGER not null default '0',rn "status" VARCHAR(1) not null default ' ',rn "reserve" VARCHAR(250) not null default ' ',rn constraint PK_TBAGREEMENT primary key ("contract_no")rn);rn
急 oracle数据库 出现ORA-00907: 缺少右括号 在线等
实在不知道 啥原因rnrnORA-00907: 缺少右<em>括号</em> rn说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 rnrn异常详细信息: System.Data.OleDb.OleDbException: ORA-00907: 缺少右<em>括号</em>rnrn源错误: rnrnrn行 20: 'Dim cmd1 As New Data.SqlClient.SqlCommand("select userid,username,truename, online,(select count(id) from chat where dusername='" & Trim(Session.Item("curuser_username")) & "' and susername=qx_users.username and readed='0') as msgcount from qx_users order by online desc", connmy)rn行 21: Me.TblUser.Rows.Clear()rn行 22: Using dr1 As OleDb.OleDbDataReader = cmd1.ExecuteReaderrn行 23: Do While dr1.Readrn行 24: Dim row1 As New TableRowrn rnrn源文件: E:\厦门车管\CLJSGL\Chatmain.aspx.vb 行: 22 rnrn堆栈跟踪: rnrnrn[OleDbException (0x80040e14): ORA-00907: 缺少右<em>括号</em>]rn System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult) +114rn System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +163rn System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56rn System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105rn System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +92rn System.Data.OleDb.OleDbCommand.ExecuteReader() +6rn Chartmain.LoadUserList() in E:\厦门车管\CLJSGL\Chatmain.aspx.vb:22rn Chartmain.Page_Load(Object sender, EventArgs e) in E:\厦门车管\CLJSGL\Chatmain.aspx.vb:62rn System.Web.UI.Control.OnLoad(EventArgs e) +80rn System.Web.UI.Control.LoadRecursive() +49rn System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3750rnrn
ORA-00907: 缺失括号;代码我在sql运行中都正确,但到了idea中就报错
这代码我在sql运行中都正确,但到了idea中就报错 我觉得是子查询中那个order by的毛病,但分页语法必须有 SELECT PP.EMP_CODE, E.NAME, PP.EMP_SEQ_NUM, PP.ORG_NAME, PP.EMP_PROPERTY, PP.EMP_TYPE, PP.EMP_ORG_ID, PP.ID FROM (SELECT T.ID, T.IS_DELETED, T...
ORA-00907: 缺少右括号??TOAD,SQL*Plus里能执行
C#,ASP。NET里面不能执行,如下SQL,奇怪。。。。。。。rn[code=SQL]select METERID,DEVICETYPE,max(case when TO_CHAR(DDATE,'yyyymmdd') =TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end) as data1,max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end) as data2,(max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end)-max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end)) as METERNLLJ,max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then DEVICESTATUS else 0 end) as DEVICESTATUS1,max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd') then DEVICESTATUS else 0 end) as DEVICESTATUS2 from TMPTODAY WHERE DEVICETYPE=16 AND METERID IN (SELECT METERNO FROM TDOOR_METER WHERE METERTYPE=16 ) group by METERID, DEVICETYPE[/code]
oracle删除表数据时 ORA-00907: 缺少右括号
sql语句:delete from test.tableA;rn就提示:ORA-00907: 缺少右<em>括号</em>rn我不懂,我哪写错了?~~
在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>rn这是我的建表代码,刚学oracle,请大家帮忙,谢谢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,现在需要在其中任意位置尽
创建数据库表时,关于ORA-00907: 缺失括号与左括号问题总结
今天使用Oracle数据库建表的时候,遇到了“ORA-00907: <em>缺失</em>右<em>括号</em>”的问题,关于这个,做了一些总结: 报错的sql语句: create table pre_info(pre_name varchar2(20),pre_code varchar2(20),pre_num number(5),pre_price_old number(5), pre_tax decimal...
oracle 使用union提示ORA-00907:缺少右括号
在使用union的时候提示:ORA-00907:缺少右<em>括号</em> 此原因是因为在union的左边和右边都有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请各位大侠帮忙分析下,谢谢
RANK的时候报缺失括号(大虾帮忙看下)
以下是SQL语句rnselect NO1,rank() over(order by CreateDate desc) from tablern放在PL/SQL中可以执行,但是放在程序中就报错说<em>缺失</em>右<em>括号</em>。哪位大虾知道为什么啊=。=
紧急求助 SQL语句编译后提示缺失括号
select 地市名称, 堤名,起始桩号,终止桩号,日期,超设防水位堤段长度,超警戒水位堤段长度,超保证水位堤段长度,备注 from ( select 报表编号,堤名,起始桩号,终止桩号,日期,超设防水位堤段长度,超警戒水位堤段长度,超保证水位堤段长度,备注 from TBRT1404_DFBF) XG left join (select 报表编号,地市名称,填报单位名称 from TBRT0001_BTXX left join TBRT0003_DISTRICT on TBRT0001_BTXX.行政区划代码=TBRT0003_DISTRICT.县区代码 where TBRT0001_BTXX.审核标识='110' 6 ) XZ on XG.报表编号=XZ.报表编号)and 日期 between to_date('2001-06-01','yyyy-MM-dd') and to_date('2009-06-12','yyyy-MM-dd') order by 地市名称, 堤名
oracle数据库建表时出现错误:缺失括号
oracle数据库建表时出现错误:<em>缺失</em>右<em>括号</em> 这个错误一般都是用了oracle中没有的语法导致的,比如:identity函数是SQLSERVER中的,oracle中不能用;数字型定义在oracle中须全写number,只写num也会报这个错误。 调试方法:逐行注释
oracle建表时出现缺失括号问题
在iSQL*PLUS中输入如下内容建表,该表参照的表都已经建好rnrncreate table tb_fault_inforn(rnfid int identity(1,1) primary key,rnfsim char(40) not null,rnfdet char(600) not null,rncompany char(40) not null,rnftime datetime not null,rngid int foreign key references tb_group(gid), rnfsid int foreign key references tb_fault_state(fsid),rnaddf char(600),rnfnum char(10) not null,rnfc int not nullrn);rnrn出现如下问题:rnfid int identity(1,1) primary key,rn *rnrn第 3 行出现错误: rnORA-00907: <em>缺失</em>右<em>括号</em>rnrn都改了一天了,希望各位朋友帮帮忙,我很着急 rnrn rnrn rn
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
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', '绩效管理与工作分析能力有待提高', '评估结果表明,基于这次的培训内容,您对“绩效管理与工作分析”知识和技能的掌握还有待提高,您没有很好的把所学的知识灵活运用到工作中,对于绩效管理与工作分析的重要性,以及绩效管理与工作分析的相关工作流程,您可能还需要继续学习。但绩效管理与工作分析难以操作的地方在于方法的选用与细节的操作,基于观念,让公司员工能够真正认可,是一件非常困难的事情,这需要有效的沟通;细节的操作,能够做到公平公正,科学客观,也是需要相关知识的积累与实践,在这些方面的操作,您可能需要投入更多的精力去学习与积累,只要您不断努力,您也会是最棒的! ', '');rn
缺失右括号"的错误)">使用别名应注意(报"缺失括号"的错误)
(Oracle测试)使用SQL语句的select语句是经常会用到字段和表的的别名,使用要注意,字段的别名前面可以加as关键字,或是省略不写,但是表名的别名前面不可以加as,否则会报如下错误: [color=red]命令出错, 行: 11 列: 20 错误报告: SQL 错误: ORA-00907: <em>缺失</em>右<em>括号</em> 00907. 00000 - &quot;missing right parenth...
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("oracle.jdbc.driver.OracleDriver");rn rn ct=DriverManager.getConnection("jdbc:oracle: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,oracle.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>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不知道错在哪了?
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 缺少右括号。。。
创建视图如下: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>。。。rn请大家帮帮忙看下额。。。rncase的作用是:如果sid列为空,则显示studentid列,如果sid列不空,则直接显示
报错“缺少右括号
请问各位:我把Oracle9i和自己用vc写的程序放在同一台电脑上,执行select scott.emp.*,(select dname from scott.dept where scott.dept.deptno=scott.emp.deptno) from scott.emprn 就会报错“缺少右<em>括号</em>”,VC的程序放在只装客户端的电脑上运行就正常,那位大侠遇到这种情况的
缺少右括号错误
rn这段代码ie老报错:缺少‘)’ 。高手帮忙看看咋回事儿吧。
缺少右括号问题
为什么这句话在PL/sql里执行没有问题。 SELECT WHSCODE,sum(CASE when status='空' then 1 else 0 end) NULLTorrNums FROM WAREHOUSEPOSITION GROUP BY WHSCODE rn带到程序中,就报错,说缺少右<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>,可是,非常郁闷的是,在这个编辑状态下,却无法像其他编辑器一样通过按Tab或Enter键跳出右<em>括号</em>到行尾。 虽然VSCode有强大的按键自定义功能,但初学者看起来还是头晕。 而且居然百度不到,故起此贴。 在这个Issue下找到相对简单的解决方法,就是安装Tabout插件。 https://github.com/Microso...
哪位高手:缺少右括号
SQL Server 2000里执行好好的,拿到Oracle9i里就不行,说缺少右<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>之后的中序表达式 */ public class _1_3_9CompleteBracket { public static void main(String[] args) { String s=new
函数左括号到右括号跳转
Ctrl键+]键
左,右括号的配对问题
做一个复合查询,包括且,或,以及()的条件,当用户点击右<em>括号</em>时,我怎么判断他前面一定输入了左<em>括号</em>大家有没有例子参考一下。
datawindow提交参数后出错 select error:ora-00907:缺少右括号
datawindow 的SQL如下:rn SELECT "TESTPDWORK"."NO", rn "TESTPDWORK"."ADMIN", rn "TESTPDWORK"."DEP", rn "TESTPDWORK"."WORKMAN", rn "TESTPDWORK"."WORKMANCOUNT", rn "TESTPDWORK"."WORKSTARTTIME", rn "TESTPDWORK"."WORKENDTIME" rn FROM "TESTPDWORK" rnwhere (no like '%':no'%' or :no is null)rnand (admin like '%':admin'%' or :admin is null)rnand (dep like '%':dep'%' or :dep is null)rnand (workman like '%':workman'%' or :workman is null)rnand (workendtime =:workstarttime or :workstarttime is null)rnrn用语句ll_return=dw_detail.retrieve(is_no,is_admin,is_dep,is_workman,id_workstarttime,id_workendtime)rn提交刷新数据后出错rnselect error:<em>ora-00907</em>:缺少右<em>括号</em>rn
为什么我在Toad里面就可以执行,在程序里面就报ORA-00907:缺少右括号
最后,组合好的sql语句是:[code=SQL]INSERT INTO LEAVE_FDJR_TABLE (rn DAY_ID,rn DAYrn )rn VALUES (rn s_LEAVE_FDJR_TABLE.NEXTVAL,rn ( ( SELECT MAX (day) FROM leave_fdjr_table) + 1)rn )[/code],找了,好久,没找到原因,请大侠,请指教啊
ORA-00907:缺少右括号 请各位仔细看看 谢 在线等
this.oracleCommand2.CommandText = "insert into L2_DC_REPORT_SUM (COILNO,SRTNO,FINISH_DATE,TRANSFER_DATE) values (" + this.OracleDataReader1.GetOracleString(0).ToString() + "," + this.OracleDataReader1.GetOracleString(1).ToString() + rn",to_date(" + this.OracleDataReader1.GetOracleDateTime(2).ToString() + "," + "yyyy-mm-dd hh24:mi:ss)" + ",to_date(" + this.OracleDataReader1.GetOracleDateTime(3).ToString() + "," + "yyyy-mm-dd hh24:mi:ss" + "))";rnCOILNO与SRTNO为VARCHAR2,FINISH_DATE与TRANSFER_DATE为DATE
【一次过】【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>,将...
随机函数的新问题,报缺少右括号
rnselect filepath from zqf_tmp rn where jm_typeid=1rn order by dbms_random.valuernrn这句正常,每次查询结果都变. 但是,我加上个条件就提示缺少右<em>括号</em>,哪的问题啊?rnrnselect name from jm_info where filepath inrn(rnselect filepath from zqf_tmp rn where jm_typeid=1rn order by dbms_random.valuern)rn
oracle创建视图提示缺少右括号
1.创建视图中的select 语句单独执行查询没问题,在外面包上 create or replace view v_视图名 as() 时报ORA-00907:<em>缺失</em>右<em>括号</em>rn2.创建视图中的查询语句大体如下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条件时可以建视图成功,加上后,内部的select语句单独查询没问题,建视图时报缺少右<em>括号</em>
【数据结构与算法】京东笔试题 去右括号
题目:给定一个只包含<em>括号</em>的字符串,且<em>括号</em>是合法的。删除第一个左<em>括号</em>,再删除任意一个右<em>括号</em>,一直重复此操作直到字符串为“”。 问:一共有多少种解法。 我拿到这道题目,本能的反应就是深搜,结果只AC了一半,一直以为是逻辑有问题,可是想不出来,最后想到可能是超时了,应该加一个备忘录,算是一个经验吧。 然后考完看了牛客网别人的算法,发现很好。 思路是算出每一个右<em>括号</em>前面有几个左<em>括号</em>,于是可以得到删
提示missing right parenthesis,缺少右括号
提示missing right parenthesis,缺少右<em>括号</em>,这个句子有什么问题?rnselect viewno,sum(case CARRYDATE when '2006-03-16' then SUM1 else 0 end) 2006-03-16rnfrom SENDMATVIEW GROUP BY viewno
DB2函数提示多了右括号
[code=sql]rnCREATE OR REPLACE FUNCTION FUNC_TEST (rn in_opId VARCHAR(20),rn in_id VARCHAR(20)rn)rnRETURNS INTEGERrnLANGUAGE SQLrnBEGIN ATOMICrn DECLARE v_id VARCHAR(20);rn DECLARE v_PId VARCHAR(20);rn IF in_opId = in_id THENrn RETURN 0;rn END IF;rn SET v_id = in_id;rn WHILE v_id IS NOT NULL DOrn SET v_PId =( SELECT PARENT_ID FROM JFIT.T_SYS_RESOURCE WHERE ID = v_id);rn IF v_PId = in_opId THENrn RETURN 0;rn END IF;rn SET v_id = v_PId;rn END WHILE;rn RETURN 1;rn END;rn[/code]rnrnrn在DBVisualizer执行;rn报错rn[code=objc]rn[CREATE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "E v_id VARCHAR(20" 后面找到异常标记 ")"。预期标记可能包括:"END-OF-STATEMENT"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [DECLARE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "DECLARE v_PId VARCHAR"。预期标记可能包括:""。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [IF - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "IF"。预期标记可能包括:""。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "END IF" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN "。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [SET - 0 row(s), 0.000 secs] [Error Code: -206, SQL State: 42703] "V_ID" 在使用它的上下文中无效。. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.15.82rn 16:58:16 [WHILE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "WHILE v_id IS NOT NULL DO"。预期标记可能包括:""。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [IF - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "IF"。预期标记可能包括:""。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "END IF" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN "。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [SET - 0 row(s), 0.000 secs] [Error Code: -206, SQL State: 42703] "V_ID" 在使用它的上下文中无效。. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.15.82rn 16:58:16 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "END WHILE" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN "。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [RETURN - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "RETURN"。预期标记可能包括:""。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "END" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN "。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn 16:58:16 [@ - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "@" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN "。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82rn... 13 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 13 errors]rn[/code]
建表时缺少右括号错误
我以前用的是mssql,现因工作需要转向Oracle,建一个表的时候,老提示缺少右<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>rnrn脚本如下,请高手指点:
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>;请高手帮我解决,本人很少写ORACLE语句。rnrn解决为谢!!! rn
编译不报错,运行报错找不到右括号
procedure TFormhbtj.Button1Click(Sender: TObject);rnvarrnLoopDate:string;rnbeginrnif self.cxDateEdit1.Date>self.cxDateEdit2.Date then application.MessageBox('开始日期不能大于结束日期!','提示')rn elsern beginrnLoopDate:=formatdatetime('yyyy-mm-dd',self.cxDateEdit1.datetime);rnwhile LoopDate;rnself.OraQuery_Co.ExecSQL;rnrnrnend;rnend;
错哪了???提示缺少右括号。。T_T
[code=SQL]create or replacernProcedure PRO_Get_NowDatarn(rn P_FCID VARCHAR2,rn o_cur out sys_refcursorrn)rnASrn V_Command varchar2(2000);rnBEGINrn V_Command:=rn 'SELECT * FROM (select sum(ACTIVEPOWER) AS ACTIVEPOWER,avg(WindSpeed) AS WindSpeed,avg(Temperature) AS Temperature,avg(WindDirection) AS WindDirection from TB_'rn ||P_FCID||'_FJ_'||substr(sysdate,1,4 )||rn ' where RECORDTIME in(select RECORDTIME from TB_'rn ||P_FCID||'_FJ_'||substr(sysdate,1,4 )||rn ' group by RECORDTIME having count(*)>0 ) group by RECORDTIME ORDER By RECORDTIME DESC) Where ROWNUM = 1'; rn OPEN o_cur FOR v_command;rn rn rnEND PRO_Get_NowData;[/code]rn在sqldeveloper中编写的存储过程,jsp调用时提示缺少右<em>括号</em>,怎么调试都找不到错误。。。。
关于case when end用法报错:缺失括号 问题请教
[img=https://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin/001/face/17.gif][/img]rn各路大神帮我看看,rnoracle里面的 本来的语句是rn[code=sql]rnSELECT /*+ 123 */ H4RTMP_PHMX.NUM NUM, H4RTMP_PHMX.cls cls, H4RTMP_PHMX.fildate fildate, SUM(decode(H4RTMP_PHMX.cls,'统配出',1,'统配出退',-1,'直配出',1,'直配出退',-1,1)*H4RTMP_PHMX.qty) qty, rnSUM(decode(H4RTMP_PHMX.cls,'统配出',1,'统配出退',-1,'直配出',1,'直配出退',-1,1)*H4RTMP_PHMX.total) total, rnSUM(decode(H4RTMP_PHMX.cls,'统配出',1,'统配出退',-1,'直配出',1,'直配出退',-1,1)*H4RTMP_PHMX.tax) tax, rnH4RTMP_PHMX.statname statname, H4RTMP_PHMX.STCODE STCODE, H4RTMP_PHMX.stname stnamernFROM H4RTMP_PHMX H4RTMP_PHMX, GOODS GOODS, BRAND BRAND, STORE STORE, STORE STORE__1rnWHERE ((H4RTMP_PHMX.GDcode = GOODS.CODE)rn and (H4RTMP_PHMX.stcode = STORE.CODE)rn and (BRAND.CODE(+) = GOODS.BRAND)rn and (STORE__1.CODE = STORE.BELONGSORT) )rn and ( rn( (H4RTMP_PHMX.fildate >= '2016.10.09' ) and (H4RTMP_PHMX.fildate < '2016.10.10' ) )rn )rnGROUP BY H4RTMP_PHMX.cls, H4RTMP_PHMX.NUM, H4RTMP_PHMX.fildate, H4RTMP_PHMX.statname, H4RTMP_PHMX.STCODE, H4RTMP_PHMX.stnamernORDER BY NUM ASCrnrn[/code]rn然后因为有个制品不支持decode函数,我将这个改为rn[code=sql]SELECT H4RTMP_PHMX.NUM NUM, H4RTMP_PHMX.cls cls, H4RTMP_PHMX.fildate fildate,rn SUM(H4RTMP_PHMX.cls=(case rnwhen '统配出' then '1'rnwhen '统配出退' then '-1'rnwhen '直配出' then '1'rnwhen '直配出退' then '-1'rnelse '1' end )rn*H4RTMP_PHMX.qty) qty, rnSUM(H4RTMP_PHMX.cls=(case rnwhen '统配出' then '1'rnwhen '统配出退' then '-1'rnwhen '直配出' then '1'rnwhen '直配出退' then '-1'rnelse '1' end )rn*H4RTMP_PHMX.total) total, rnSUM(H4RTMP_PHMX.cls=(case rnwhen '统配出' then '1'rnwhen '统配出退' then '-1'rnwhen '直配出' then '1'rnwhen '直配出退' then '-1'rnelse '1' end )rn*H4RTMP_PHMX.tax) tax, rnH4RTMP_PHMX.statname statname, H4RTMP_PHMX.STCODE STCODE, H4RTMP_PHMX.stname stnamernFROM H4RTMP_PHMX H4RTMP_PHMX, GOODS GOODS, BRAND BRAND, STORE STORE, STORE STORE__1rnWHERE ((H4RTMP_PHMX.GDcode = GOODS.CODE)rn and (H4RTMP_PHMX.stcode = STORE.CODE)rn and (BRAND.CODE(+) = GOODS.BRAND)rn and (STORE__1.CODE = STORE.BELONGSORT) )rn and ( rn( (H4RTMP_PHMX.fildate >= '2016.10.09' ) and (H4RTMP_PHMX.fildate < '2016.10.10' ) )rn )rnGROUP BY H4RTMP_PHMX.cls, H4RTMP_PHMX.NUM, H4RTMP_PHMX.fildate, H4RTMP_PHMX.statname, H4RTMP_PHMX.STCODE, H4RTMP_PHMX.stnamernORDER BY NUM ASCrn[/code]rn执行后提示<em>缺失</em>右<em>括号</em>,波浪线定位在H4RTMP_PHMX.cls= 的[color=#FF0000]等号[/color]这里,看了下<em>括号</em>都是对齐的。
函数不报错,但是使用函数的时候报缺失括号
--函数的功能是想实现传入一个日期和值然后统计该年到该天的这列的值rncreate or replace function f_tol(v_date in date,v_value in varchar2,v_type in char)rnreturn numberrnasrn num number;rn v_sql varchar2(2000);rnbeginrn if (v_type = 'Y') then rn v_sql:='select sum('||v_value||') from t03_business_letter_sum rn where open_invoice between trunc('||v_date||',''yyyy'') and '||v_date; rn [color=#FF0000] execute immediate v_sql into num;[/color] -- <em>缺失</em>右<em>括号</em>,在line10 rn end if;rn return num;rnend;rnrn请各位帮忙看看是哪写错啦?谢谢
请问这个查询语句该怎么该,加order by报缺失括号
[code=sql]rn SELECT qu.id, qu.belong, qu.type, qu.title, qu.flag,rn(SELECT wm_concat(as_num || '-' || as_info)rnFROM QUESTION_ANSWER quasrnWHERE quas.qu_id = qu.qu_idrnorder by quas.as_sort asc ) AS qu_answersrnFROM QUESTION qu;rnrnrn[/code]rn* ORA-00907: <em>缺失</em>右<em>括号</em>rn* 00907. 00000 - "missing right parenthesis"rn* *Cause: rn* *Action:rn想用来做视图,使用wm_concat合并子表内容并排序,加了排序order by quas.as_sort asc后报ORA-00907: <em>缺失</em>右<em>括号</em>,rn不加order by quas.as_sort asc这句的话正常,请问怎么解决
我在用Map写电话本的(Contacts)的时候右括号缺失了,大神们看看哦!
[code=java]public void writeContacts(RandomAccessFile raf6,int n,int id,long time,String name,String mobileNumber,String address)throws Exceptionrn long start=300*(n-1);rn //raf6.setLength(start+300);rn raf6.seek(start);rn raf6.writeInt(id);rn raf6.writeLong(time);rn raf6.write(name.getBytes());rn raf6.seek(62+start);rn raf6.write(mobileNumber.getBytes());rn raf6.seek(92+start);rn raf6.write(address.getBytes());rn rn rn public MapreadContacts(RandomAccessFile raf6,int n)throws Exceptionrn int start=300*(n-1);rn raf6.seek(start);rn int id=raf6.readInt();rn Date time=new Date(raf6.readLong());rn rn raf6.seek(12+start);rn byte[] buf=new byte[50];rn raf6.read(buf);rn String name=new String(buf).trim();rn rn raf6.seek(62+start);rn byte[] mobileNumbers=new byte[30];rn raf6.read(mobileNumbers);rn String mobileNumbersR=new String(mobileNumbers);rn rn raf6.seek(92+start);rn byte[] address=new byte[50];rn raf6.read(address);rn String addressR=new String(address).trim();rn rn Mapmap=new LinkedHashMap();rn map.put("id", id);rn map.put("Date", time);rn map.put("name", name);rn map.put("mobileNumbers", mobileNumbersR);rn map.put("address", addressR);rn return map;rn rn rn @Testrn public void testContacts()throws Exceptionrn RandomAccessFile raf6=new RandomAccessFile("/home/baohan/桌面/Contacts","rw");rn writeContacts(raf6,1,1,new Date().getTime(),"baohan","123","myFamily");rn /**rn raf6.seek(92);rn byte[] baohan=new byte[50];rn raf6.read(baohan);rn System.out.println(new String(baohan).trim());rn */rn System.out.println(readContacts(raf6,1));rn raf6.close();rn [/code]rnrn如果把注释的那段加上,是可以读取address的,但是直接打印Map的时候结果:rn[code=java]id=1, Date=Thu Jun 05 15:58:50 CST 2014, name=baohan, mobileNumbers=123[/code]rn可以看到address的key和value<em>缺失</em>了,以及右<em>括号</em><em>缺失</em>了!rn大神求救哦,秒秒钟能解决问题哦!
(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之后,执行时出现缺失括号的错误,该如何解决
oracle中创建完表t_log之后,执行时出现<em>缺失</em>右<em>括号</em>的错误,百度了一下,有的网友说,把auto increment去掉就可以了,试了一下不行,我检查了一下,语句中不缺右<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]
使用PL\SQL更新数据库中的日期提示确实右括号缺失
update T_JBXX_JBXXrn set CSRQ = (select substr(SFZJH, 7, 4)rn from T_JBXX_JBXX||'-'||rn select substr(SFZJH, 11, 2)rn from T_JBXX_JBXX || '-' ||rn select substr(SFZJH, 13, 2) from T_JBXX_JBXXrn rn )
使用PL/SQL创建数据表时出现缺失括号和标识符无效的错误,怎么解决?
rn使用PL/SQL创建数据表时出现<em>缺失</em>右<em>括号</em>和标识符无效的错误rnrn建表语句如下rnrn-- Create tablerncreate table SUBJECTrn(rn SUBJECTID NUMBER(20) not null,rn SUBJECT_FID VARCHAR2(20)not null,rn SUBJECTNAME VARCHAR2(50)not null,rn SUBJECTSTATUS VARCHAR2(50) not null,rn SUBJECT_TYPE VARCHAR2(50) rn SUB_START VARCHAR2(8) not null,rn SUB_END VARCHAR2(8) not null,rn SUBJECT_REMARK VARCHAR2(100) rn )rntablespace USERSrn pctfree 10rn initrans 1rn maxtrans 255rn storagern (rn initial 64rn minextents 1rn maxextents unlimitedrn );rn-- Add comments to the columns rncomment on column SUBJECT.SUBJECTIDrn is '科目编码';rncomment on column SUBJECT.SUBJECT_FIDrn is '父级科目编码';rncomment on column SUBJECT.SUBJECTNAMErn is '科目名称';rncomment on column SUBJECT.SUBJECTSTATUErn is '科目状态';rncomment on column SUBJECT.SUBJECTTYPErn is '科目类型';rncomment on column SUBJECT.YEAR_STARTrn is '(年度)开始';rncomment on column SUBJECT.YEAR_ENDrn is '(年度)结束';rncomment on column SUBJECT.SUBJECT_REMARKrn is '备注';rn-- Create/Recreate primary, unique and foreign key constraints rnalter table SUBJECTrn add constraint SUBJECT primary key (SUBJECTID)rn using index rn tablespace USERSrn pctfree 10rn initrans 2rn maxtrans 255rn storagern (rn initial 64Krn minextents 1rn maxextents unlimitedrn );rnrn首先提示的是在SUB_START处<em>缺失</em>右<em>括号</em>,然后是ORA-00904::"字段名称":标识符无效。不可能每个标识符都无效把
小弟基于oracle数据库写一个sql语句,出现缺失括号的错误,麻烦大家帮忙看一看
[code=csharp]rnstring sql = string.Format("select * from 0 where HC_TIME between to_date(1,'yyyy-mm-dd hh24:mi:ss') and to_date(2,'yyyy-mm-dd hh24:mi:ss')", HCTable.realTimetable, Lowtime, Toptime);rn[/code]rn注:HC_TIME是列名称
mybatis批量修改,这样写是不是有问题,老说我缺失有右括号
mybatis批量修改,这样写是不是有问题,老说我<em>缺失</em>有右<em>括号</em>rn修改的结果要求是一个bicycleId对应一个pileId(可以随便对应,就是保证只对应上一个就行),这样写会不会出现一个bicycleId对应上了多个pileId。。。。求指点。。。。。rn[code=java] rn update rn bicyclern rn station_id=#stationId,rn status=#status,rn rn pile_id=#pile.pileIdrn rn rn where rn bicycle_id in rn rn #bicycleIdrn rn [/code]
ora-00907错误问题,求教。
以下是出错代码:rnselect e.*, d.*rn from (select b.nsrmc, b.hy_dm, c.nsrzg_dmrn from dj_nsrxx brn left join rd_nsrzg crn on b.nsrsbh = c.nsrsbh) e,rn (select a.nsrsbh, sum(a.xssr) as xssr_hz, sum(a.se) as se_hzrn from sb_zsxx arn where a.nsr_swjg_dm = '153'rn and a.yzskbz = 'Y' rn and a.hzjksbz = 'N' rn and a.sssq_q >= to_date('20090321', 'yyyymmdd')rn and a.sssq_q < '51' rn and a.sksx_dm <> '22' rn and a.sb_tzlx_dm = '0' rn and a.zsxm_dm = '01' rn and a.zspm_dm <> '9900' rn group by a.nsrsbh) drn where e.nsrsbh = d.nsrsbhrn order by d.se_hz descrn在第4行left处报错,曾经做成:rnselect e.*, c.nsrzg_dmrn(select b.nsrmc, b.hy_dm,d.*rn from dj_nsrxx b,rn (select a.nsrsbh, sum(a.xssr) as xssr_hz, sum(a.se) as se_hzrn from sb_zsxx arn where a.nsr_swjg_dm = '153'rn and a.yzskbz = 'Y' rn and a.hzjksbz = 'N' rn and a.sssq_q >= to_date('20090321', 'yyyymmdd')rn and a.sssq_q < '51' rn and a.sksx_dm <> '22' rn and a.sb_tzlx_dm = '0' rn and a.zsxm_dm = '01' rn and a.zspm_dm <> '9900' rn group by a.nsrsbh) drn where e.nsrsbh = d.nsrsbhrn order by d.se_hz desc) ern left join rd_nsrzg crn on e.nsrsbh = c.nsrsbhrn依然出错,不知原因,求教。
安全连入Internet:防火墙下载
Internet的设计就是为资源共享为目标的 用户数量的增加,恶劣的用户也在增加 许多TCP/IP的服务有漏洞,特别网管服务 窃听和假冒比较容易 服务策略的缺乏导致许多不需要的服务开放 存取控制设置复杂导致安全漏洞 防火墙:一个经济的解决方案 相关下载链接:[url=//download.csdn.net/download/hellosxg/2228175?utm_source=bbsseo]//download.csdn.net/download/hellosxg/2228175?utm_source=bbsseo[/url]
VB 用属性自定义坐标系下载
VB 用属性自定义坐标系 VB 用属性自定义坐标系 相关下载链接:[url=//download.csdn.net/download/zhx0301/2435677?utm_source=bbsseo]//download.csdn.net/download/zhx0301/2435677?utm_source=bbsseo[/url]
linux 学习日记下载
Linux 个人学习日记涵盖了linux的基本操作命令知识,在这我以代码示例及文字叙述来帮助想学好了linux知识的读者和广大学者;个人知识浅薄不胜余力,若有读者发现冗余知识缺陷请联系我,期待与您携手共进学好了linux 相关下载链接:[url=//download.csdn.net/download/zj0910/3420329?utm_source=bbsseo]//download.csdn.net/download/zj0910/3420329?utm_source=bbsseo[/url]
相关热词 c#异步发送kafka c#窗体编号 c# 操作二进制文件 c# 反射 机制 c#线程 窗体失去响应 c#角度转弧度 c# 解析gps数据 c# vs设置 语法版本 c# json含回车 c#多线程demo
我们是很有底线的