Oracle 缺少表达式 [问题点数:20分]

Bbs1
本版专家分:0
结帖率 0%
Bbs9
本版专家分:64162
版主
Blank
GitHub 绑定GitHub第三方账户获取
Blank
进士 2017年 总版技术专家分年内排行榜第八
Blank
优秀版主 2016年10月优秀大版主
优秀小版主
Blank
银牌 2017年1月 总版技术专家分月排行榜第二
Bbs3
本版专家分:719
Blank
红花 2019年4月 其他数据库开发大版内专家分月排行榜第一
2019年3月 其他数据库开发大版内专家分月排行榜第一
缺少表达式
学jsp怎么有这么多的问题啊? 一开始是配置问题,后来碰到数据库驱动问题,今天又碰到了一个问题:就是在jsp中往oracle创建一个表counter,字段为:(date varchar(10),today number(6),first number(6),second number(6)); 当用sql语句select date from counter时会报错:<em>缺少</em><em>表达式</em>,我在sql*plus中也是遇到该问题。这到底咋回事?
ora 缺少表达式
CString str;rnstr.Format("select * from route where start=%s",sta);rnrnrn运行时说<em>缺少</em><em>表达式</em>,什么原因?
数据更新,缺少表达式??
rn string conString=(String) ConfigurationSettings.AppSettings["ConnectionString"];rn rn string str="update limit set telephone=@telephone, calltype=@calltype, descript=@descript where id=@id";rn OleDbConnection objConnect = new OleDbConnection(conString);rn rn OleDbCommand objCommand = new OleDbCommand(str, objConnect);rn objCommand.Parameters.Add(new OleDbParameter("@telephone" , OleDbType.VarChar , 16));rn objCommand.Parameters["@telephone"].Value = telephone_edits.Text ;rn objCommand.Parameters.Add(new OleDbParameter("@calltype" , OleDbType.VarChar , 2));rn objCommand.Parameters["@calltype"].Value = calltype ;rn objCommand.Parameters.Add(new OleDbParameter("@descript" , OleDbType.VarChar , 16));rn objCommand.Parameters["@descript"].Value = descript_edits.Text ;rn objCommand.Parameters.Add(new OleDbParameter("@id" , OleDbType.Integer ));rn objCommand.Parameters["@id"].Value = id;rn rn rn objConnect.Open();rn objCommand.ExecuteNonQuery();rn objConnect.Close();
缺少表达式SQLMAP
我想在用模糊查询查询东西,但老是出现<em>缺少</em><em>表达式</em>,SQLMAP中代码如下:rnrn select n.newsno as newsNo,rn n.title as title,rn n.newsdate as newsDate,rn n.note as notern from jfnews n rn wherern rn rn rn n.newsdate >= #startDate#rn rn rn rn rn n.newsdate rn rn这个是可以运行的,但加上就报<em>缺少</em><em>表达式</em>了,我看了好多边,SQL语句没写错啊,有谁能帮我看看,谢谢了
ORA-00936: 缺少表达式
用OleDb连接ORACLE数据库时,查询代码rn[code=csharp]string sql = @"SELECT * FROM DBCENTERUSER WHERE USERNAME = @UserName ";rnOleDbParameter parameter = new OleDbParameter("@UserName",userName);rnOleDbDataReader dataReader = DBSQLHelper.ExecuteReader(sql, parameter);[/code]rn其中,ExecuteReader为rn[code=csharp]public static OleDbDataReader ExecuteReader(string sql, OleDbParameter value)rnrn OleDbCommand cmd = new OleDbCommand(sql, Connection);rn cmd.Parameters.Add(value);rn OleDbDataReader reader = cmd.ExecuteReader();rn return reader;rn[/code]rn执行到OleDbDataReader reader = cmd.ExecuteReader(),报ORA-00936: <em>缺少</em><em>表达式</em>错误rn奇怪的是,当我把上面的参数@UserName直接换成值时就不会报错了rn求大神指教
ORA-00936: 缺少表达式 :数据类型
ORACLE 数据库中有很多类型都可以存放文件(文本,视频等),针对于各种文件,各类型都有哪些优点,rn我今天测试,用BFILE存文档,我先用BYTE[]的变量取到文件,但是保存:rnrn byte[] image = new byte[length]; rnrn file.InputStream.Read(image, 0, length); rnrn string sqlStr = "INSERT INTO YUSX.Annex (Detail) VALUES " + rn "( @Detail)";rnrn OleDbParameter[] param = new OleDbParameter[1];rn rn param[0] = new OleDbParameter("@Detail", image);rnrn保存错误,“执行命令过程中,发生了一个或多个错误。 ORA-00936: <em>缺少</em><em>表达式</em> ”请问是什么问题啊!rn如果我想保存视频文件,用什么类型会比较好啊,先谢过rnrn
提示 缺少表达式
下面语句将两个TO_DATE()改为'2004-08-12',在SQL2000下运行没有问题rnrn数据库改为oracle后,提示 <em>缺少</em><em>表达式</em>rnrnrnSELECT A.*,(SELECT SUM(B.amount)rn FROM (SELECT CONVERT(varchar(10), chargetime, 120) AS dt, SUM(amount) rn AS amount rn FROM cquancun rn GROUP BY CONVERT(varchar(10), chargetime, 120)) B rn WHERE datediff(dd, B.dt, A.rq) >= 0) AS total rnFROM (SELECT CONVERT(varchar(10), chargetime, 120) AS rq, SUM(C.amount) rn AS chargeamountrn FROM cquancun C rn where chargetime>TO_DATE('20040212','YYYYMMDDHH24MISS') andrn chargetime
mybatis foreach缺少表达式错误
1.出现这个错误的原因有很多,比较常见的参数类型写错了,在foreach 中 #{} 内字段与 作为条件的字段不一致造成,网上还有一种说是item 与你要引用的项相同 造成,在我看来没有错。...
oracle 表达式
NULL 博文链接:https://lversonye3.iteye.com/blog/1039441
ASP.NET保存图片到oracle出现的错误 comm.ExecuteNonQuery();ORA-00936: 缺少表达式
小弟用ASP.NET保存图片到<em>Oracle</em>数据库rn<em>Oracle</em>表是这么建的rncreate table phopo_gather(rnID varchar2(16) not null,rnPlateNumber varchar2(15) not null,rnPlateClass varchar(2) not null,rnPhoto1 Blob not null,rnPhoto2 Blob,rnPhoto3 Blobrn);rnrn然后用ASP.NET往库中的Photo1字段插入图片,代码如下rnHttpFileCollection myfilecollection;rnmyfilecollection=Request.Files;rnHttpPostedFile file=myfilecollection[0];rnbyte[] by=new byte[file.ContentLength];rnStream stream=file.InputStream;rnstream.Read(by,0,file.ContentLength);rn rnOleDbConnection conn=new OleDbConnection("Provider=OraOLEDB.<em>Oracle</em>;Data Source=myoracle;User Id=system;Password=myoracle");rnstring sql="insert into phopo_gather(id,PlateNumber,PlateClass,Photo1)values(@id,@PlateNumber,@PlateClass,@Photo1)";rnOleDbCommand comm=new OleDbCommand(sql,conn);rn comm.Parameters.Add("@id",OleDbType.VarChar,16);rncomm.Parameters["@id"].Value = "+@temp1+";rn comm.Parameters.Add("@PlateNumber",OleDbType.VarChar,15);rn comm.Parameters["@PlateNumber"].Value=System.DBNull.Value;rn comm.Parameters.Add("@PlateClass",OleDbType.VarChar,2);rn comm.Parameters["@PlateClass"].Value=System.DBNull.Value;rn comm.Parameters.Add("@Photo1",OleDbType.VarBinary,file.ContentLength);rncomm.Parameters["@Photo1"].Value=by;rnconn.Open();rncomm.ExecuteNonQuery();rnconn.Close();rnreturn "";rnrn因为PlateNumber 、PlateClass这两个字段暂时没有值,所以插了两个空值。rnrn其中@temp1是参数存放的图片的名字形式是31977854rnrn在执行comm.ExecuteNonQuery();的时候出错ORA-00936: <em>缺少</em><em>表达式</em> rn应该是SQL语句插入数据的时候出现的错误,但是具体不知道哪里错了,希望高手给长长眼,谢谢了
Oracle 9i 缺少监听器?
在学校的机房,有一台oracle服务器,供大家学习使用,每个人有自己的用户,每台机子可能有多个人使用,在登陆连接数据库的时候报错“<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列不空,则直接显示
oracle绑定变量 缺少等号
[code=sql]rn for j in 3..14 looprn v_sql:=' update tab_1 set f:x=1) where fd=''1'' and user_id=:x';rn execute immediate v_sql using j,j,p_user_id,p_user_id;rn end loop;rn[/code]rn报错误 ORA-00927: <em>缺少</em>等號rnrn求指导,谢谢!
ORACLE 缺少逗号 问题 ?
String sql = "Insert into PAYRECKON ( payreckonid , money , issuedate , operatorid , serialnumber , rn paytypeid ) values ( HIBERNATE_SEQUENCE.NextVal ,"rn + pr.getMoney()rn + " , "rn + pr.getIssuedate()rn + " , "rn + pr.getOperatorid()rn + " , '"rn + pr.getPayreckonid()rn + "' , '"rn + pr.getPaytypeid() + "' )";rnrn一开始是这样写的SQL,然后执行时报 “<em>缺少</em>逗号”的错误!rnrnString sql = "Insert into PAYRECKON ( payreckonid , money , issuedate , operatorid , serialnumber , rn paytypeid ) values ( HIBERNATE_SEQUENCE.NextVal ,"rn + pr.getMoney()rn + " , to_date("rn + pr.getIssuedate()rn + ",'YYYY-MM-DD HH24:MI:SS') , "rn + pr.getOperatorid()rn + " , '"rn + pr.getPayreckonid()rn + "' , '"rn + pr.getPaytypeid() + "' )";rnrn然后改成这样,加了一个to_date()函数,执行后报“java.sql.SQLException: ORA-00907: 缺失右括号”错误!rnrn这里的pr.getIssuedate() 里放的是 new Date()出来的值。rnrn望 高手 解答该如何修改~
oracle缺少OracleOraDb11g_home1ClrAgent服务
win7环境下,安装oracle10.2.0.3,安装完成后,<em>缺少</em><em>Oracle</em>OraDb11g_home1ClrAgent服务,请问这是什么原因导致的啊,是否有解决的办法,谢谢。
一个insert说我缺少表达式
[code=SQL]rninsert into MET_COM_ICD9 crn (c.sequence_no,rn c.icd_code,rn c.icd_name,rn c.oper_code,rn c.oper_date)rnvaluesrn (select TICD.Nextval as sequence_no,rn TICD.CURRVAL as icd_code,rn t.groupname,rn '662' as oper_code,rn sysdate as oper_datern from com_text t)rn[/code]rn说我<em>缺少</em><em>表达式</em>?我错在哪里? TICD 是一个序列rn我单独执行rn[code=SQL]rnselect TICD.Nextval as sequence_no,rn TICD.CURRVAL as icd_code,rn t.groupname,rn '662' as oper_code,rn sysdate as oper_datern from com_text trn[/code]rn是可以的
oledbCommand对象的 ExecuteReader()方法 异常缺少表达式
使用oracle数据库 sql语句"Select * from zbb_userInfos where userName=@userName and userPassword=@userPassword"rnrnpublic static OleDbDataReader ExeDataReader(string olestring, OleDbTransaction stran, CommandType cmdType, string cmdText, params OleDbParameter[] param)rn rn OleDbConnection conn = new OleDbConnection(olestring);rn if (conn.State != ConnectionState.Open)rn rn conn.Open();rn rn OleDbCommand cmd = Getcommand(conn, stran, cmdType, cmdText, param);//获得执行命令的准备方法rn return cmd.ExecuteReader(CommandBehavior.CloseConnection);rn rn关键是不是在于第一个形参,数据库链接字符串,conn.open()能过去rn这是DAL的调用方法rn OleDbParameter[] param =new OleDbParameter("@userName",user.UserName),rn new OleDbParameter("@userPassword",user.UserPassword)rn ;rn OleDbDataReader reader = <em>Oracle</em>Helper.ExeDataReader(<em>Oracle</em>Helper.Oleconnstring, null, CommandType.Text, OleDb_haveData, param);
ORA-00936: 缺少表达式,求大神解决
strSql = "UPDATE XT_JOB SET JOB_STATUS = 12,LEFT_NUMBER = " + strDataNum[1]rn + ",GOOD_NUMBER = " + cGoodCount + ",BAD_NUMBER = " + strDataNum[3] rn + ",PRODUCT_NUMBER = " + strDataNum[5] + ",REDO_NUMBER = " + strDataNum[4]rn + ",DROP_NUMBER =" + strDataNum[6] + ",UPDATE_TIME = TO_DATE('" + strDate + "','YYYY-MM-DD HH24:MI:SS') WHERE JOB_ID = " + CString(cJobID);rnrniRetVal = WriteDataFile(hDataFile,DBSQL_LEVEL,cModuleName,0,strSql.GetBuffer(strSql.GetLength()),cErrTxt);rn strSql.ReleaseBuffer();rnrn mServerConn->Execute(strSql.AllocSysString(), NULL, adExecuteNoRecords);rn SysFreeString(strSql.AllocSysString());rnrnrn时间的获取rnrnstrDate = "";rn GetLocalTime(&st);rn strDate.Format("%4d-%2d-%2d %2d:%2d:%2d",st.wYear,st.wMonth,st.wDay,st.wHour,st.wMinute,st.wSecond);rn
谁知道我的代码里缺少什么表达式
如下:
请教关于ORA-00936: 缺少表达式 的问题!
rnSelect T1.count(*),T1.sum(decode(errorcode,0,1,0)) from rnrnglc_location_msg_200909 T1 where 1=1 Andrnleft join( rnselect tvcityid,servicecode from glc_location_msg_200909 T2 where 1=1 group by tvcityid,servicecode rn) on T1.tvcityid = T2.tvcityid and T1.servicecode=T2.servicecode rnrnrn上面sql执行中,T1.count(*)这里报ORA-00936 错误,请问如何修改?
Oracle计算时间差表达式
http://hi.baidu.com/linzongjing/blog/item/448451edba7d46deb31cb12e.html <em>Oracle</em>计算时间差<em>表达式</em> --获取两时间的相差豪秒数select ceil((To_date('2008-05-02 00:00:00' , 'yyyy-mm-dd hh24-mi-ss') - To_date('2008-04-30 23:59:...
Oracle的树形语句表达式
SELECT level,a.id FROM base_organization a START WITH a.id=3 --开始位置 CONNECT BY PRIOR a.id=a.parent_id --id=别人的父id level代表层级  
(笔记)Oracle中的表达式
(1)数值<em>表达式</em>--+(加法),-(减法),*(乘法),/(除法)和**(乘方)等-- declare --此处number(9)和integer都行-- result_1 integer; begin result_1:=10+3*4-20+5**2; dbms_output.put_line('输出的结果为='||to_char(result_1)); end;  --db...
Oracle计算时间差表达式
[code=&quot;sql&quot;] 天: ROUND(TO_NUMBER(END_DATE - START_DATE)) 小时: ROUND(TO_NUMBER(END_DATE - START_DATE) * 24) 分钟: ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60) 秒: ROUND(TO_NUMBER(END_DATE - STA...
关于oracle 时间比较的表达式
我在tableA表中有个字段columnA是个date型,我想写个SQL语句:rnselect columnA < sysdate from tableArn预期得到的效果是返回true/false或者1/0之类的。如何实现?谢谢。
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 不是group by表达式
SELECT rn XBGATHER_ACCEPTER_PAY.OPER_ID,rn GATHER_NO,rn USERNAME,rn [color=#FF0000]bill_list,[/color]rn SUM(PRICE_SUM) AS SUM rn FROM XBGATHER_ACCEPTER_PAY rn LEFT JOIN PT_USER ON USERNO = OPER_ID rn WHERE OP_TIME >= TO_DATE('2010-09-27 00:00:00','yyyy-mm-dd hh24:mi:ss') rn AND OP_TIME rnGROUP BY XBGATHER_ACCEPTER_PAY.OPER_ID;rnrn上面语句报不是group by<em>表达式</em>错误,我将非聚合函数字段都加入group by;rnGROUP BY XBGATHER_ACCEPTER_PAY.OPER_ID, GATHER_NO, USERNAME, [color=#FF0000]bill_list[/color];rn这时报:不一致的数据类型: 要求 - 得到的却是 CLOB;原因bill_list是clob类型;rn把bill_list从select与group by中删除,select成功;但我现在需要同时把bill_list也select出来;rn应该怎么解决这个问题,请各位朋友帮帮忙。
Oracle中条件表达式
mysql和<em>Oracle</em>都可以用 --条件<em>表达式</em> --给EMP表中的员工起中文名字 select e.ename, case e.ename when 'SMITH' then '曹贼' when 'ALLEN' then '大耳贼' when 'WARD' then '诸葛小儿' els...
Oracle缺失表达式
INSERTrnINTO 指标基本信息表rn (rn 指标编号 ,rn 指标代码 ,rn 指标名称 ,rn 数据类型 ,rn 控件类型 ,rn 有效标志 ,rn 最大记录数,rn 创建人 ,rn 创建时间 ,rn 修改人 ,rn 修改时间 ,rn 指标说明 ,rn 备注rn )rn VALUESrn (rn PK_指标基本信息表.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>?
oracle正规表达式学习
在oracle数据库中,如何在sql语句中使用正则<em>表达式</em>呢,看看这个吧
oracle时间差表达式
oracle时间差<em>表达式</em>,计算两时间相差的天、小时、分钟、秒及毫秒数
关于oracle时间格式的表达式
package org.com.db;rnimport java.sql.*;rnpublic class database rn static // 驱动程序就是之前在classpath中配置的jdbc的驱动程序的jar包中rn String DBDRIVER = "oracle.jdbc.driver.<em>Oracle</em>Driver";rn // 连接地址是由各个数据库生产商单独提供的,所以需要单独记住rn static String DBURL = "jdbc:oracle:thin:@localhost:1521:hy";rn // 连接数据库的用户名rn static String DBUSER = "scott";rn // 连接数据库的密码rn static String DBPASS = "tiger";rn Connection conn=null;rn Statement stmt = null;rn ResultSet rs = null;rn public database() throws Exception rn rnrn Class.forName(DBDRIVER);rn rn public Connection getConnection() throws Exception rn conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);rn return conn;rn rnrn public void closeResource()rn rn try rn if (rs != null) rn rs.close();rn rs = null;rn rn catch (Exception ex) rn ex.printStackTrace();rn rn try rn if (stmt != null) rn stmt.close();rn stmt = null;rn rn catch (Exception ex) rn ex.printStackTrace();rn rn try rn if (conn != null) rn conn.close();rn conn = null;rn rn catch (Exception ex) rn ex.printStackTrace();rn rn rnrn public ResultSet executeQuery(String sql) throws Exception rnrn conn = DriverManager.getConnection(DBURL, DBUSER,DBPASS );rn stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,rn ResultSet.CONCUR_READ_ONLY);rn rs = stmt.executeQuery(sql);rn return rs;rnrn rnrn public int executeUpdate(String sql) throws Exception rn int result = 0;rn try rn conn = DriverManager.getConnection(DBURL, DBUSER,DBPASS);rn stmt = conn.createStatement();rn result = stmt.executeUpdate(sql);rn return result;rn finally rn closeResource(); rn rn rn//public static void main(String[] args) throws Exception rn// Connection conn = null; // 表示数据库的连接的对象rn// // 1、使用Class类加载驱动程序rn// Class.forName(DBDRIVER);rn// // 2、连接数据库rn// conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);rn// System.out.println(conn);rn// // 4、关闭数据库rn// conn.close();rn// rnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnpackage org.com.emp;rnimport java.sql.Connection;rnimport java.sql.Date;rnimport java.sql.PreparedStatement;rnimport java.sql.ResultSet;rnimport org.com.db.database;rnpublic class emplydesin rn public int emplyadd(int EmpPassword, String Name,rn String Cellphone, String Address, String Gender, String Birthspace,rn String Nation, Date Birthtime, String Title, int DeptID,rn int DutiesID, String Wphone, String Fphone, String Email,rn String Political, String Health, String Profession, String Gegree,rn String Marry, String Pincodes, String Icom, int PermissionID,rn Date Luru_data, Date Modifydata) rn int rows = 0;rn Connection conn = null; rn PreparedStatement pstmt = null;rn String sql = "insert into emply(EmployeeID,EmpPassword,Name,Cellphone,Address,Gender,Birthspace,Nation,Birthtime,Title,DeptID,DutiesID,Wphone,Fphone,Email,Political,Health,Profession," +rn "Gegree,Marry,Pincodes,Icom,PermissionID,Luru_data,Modifydata)values(book_sequence.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";rn database db = null;rn try rn db = new database();rn pstmt=conn.prepareStatement(sql);rn pstmt.setInt(2, EmpPassword);rn pstmt.setString(3, Name);rn pstmt.setString(4, Cellphone);rn pstmt.setString(5, Address);rn pstmt.setString(6, Gender);rn pstmt.setString(7, Birthspace);rn pstmt.setString(8, Nation);rn pstmt.setDate(9, new java.sql.Date(Birthtime.getTime()));rn pstmt.setString(10, Title);rn pstmt.setInt(11, DeptID);rn pstmt.setInt(12, DutiesID);rn pstmt.setString(13, Wphone);rn pstmt.setString(14, Fphone);rn pstmt.setString(15, Email);rn pstmt.setString(16, Political);rn pstmt.setString(17, Health);rn pstmt.setString(18, Profession);rn pstmt.setString(19, Gegree);rn pstmt.setString(20, Marry);rn pstmt.setString(21, Pincodes);rn pstmt.setString(22, Icom);rn pstmt.setInt(23, PermissionID);rn pstmt.setDate(24, new java.sql.Date(Luru_data.getTime()));rn pstmt.setDate(25, new java.sql.Date(Modifydata.getTime()));rn rn catch (Exception e1) rn // TODO Auto-generated catch blockrn e1.printStackTrace();rn rn try rn // database db = new database();rn rows = db.executeUpdate(sql);rnrn catch (Exception e) rn System.out.print(e);rn rn return rows;rn rnpublic static void main(String arg[])rn rn emplydesin em=new emplydesin();rn rn rn int ro=em.emplyadd(123,rn "丫丫","151999999","宜","w","宜春","汉","1994-12-23","经理",2001,rn 3001,"77777777","8888888","hfdjfh@163.com","群众","良好","计算机","本科","未婚",rn "36050288888888","照片1",4001,todate(03-12-81),03-12-81);?不知道怎么表达rnrn rnrnrnrnrn麻烦看看如何插入正确的测试数据,特别是时间的数据,rnrnrnrn数据库表如下rnrncreate sequence emplyseq start with 1001;rncreate table emplyrn(rn EmployeeID number(4) primary key not null,rn EmpPassword number(20) not null,rn Name varchar2(10) not null,rn Cellphone varchar2(20) not null,rn Address varchar2(10) not null,rn Gender varchar2(10) not null,rn Birthspace varchar2(10) not null,rn Nation varchar2(10) not null,rn Birthtime date not null,rn Title varchar2(10) not null,rn DeptID number(4) not null,rn DutiesID number(4) not null,rn Wphone varchar2(20) not null,rn Fphone varchar2(20),rn Email varchar2(20),rn Political varchar2(5) not null,rn Health varchar2(5) not null,rn Profession varchar2(10) not null,rn Gegree varchar2(5) not null,rn Marry varchar2(5) not null,rn Pincodes varchar2(20) not null,rn Icom varchar2(10),rn PermissionID number(4) not null,rn Luru_data date,rn Modifydata date)rn麻烦看看,虽然很长,但核心的就那些,麻烦帮我调试下,谢谢!!!!
Oracle SQL 之条件表达式
<em>Oracle</em> SQL 之条件<em>表达式</em>
oracle中用sql时间相减的问题
--MONTHS_BETWEEN(date2,date1) 给出date2-date1的月份 SQL&gt; select months_between('19-12月-1999','19-3月-1999') mon_between from dual; MON_BETWEEN ----------- 9 SQL&gt;select months_between(to_date('20...
select 运算表达式 在oracle下
这个运算大家在oracle下都很容易执行rnselect 130+5+(6-1)*2 from dual rn结果是145;rnrn但是我现在的<em>表达式</em>是一个string 类型的变量,变成了执行 select '130+5+(6-1)*2' from dual;rn结果是 130+5+(6-1)*2 字符串;rnrn如何把字符<em>表达式</em> 变成 数学运算<em>表达式</em>!
oracle 表达式错误
CREATE OR REPLACE PROCEDURE out_emr(MRID IN VARCHAR2) ISrnrn MRID1 VARCHAR(20);rn MRID2 VARCHAR(20);rn dia_date VARCHAR(30);rn iccardno VARCHAR(20);rn MDESCRIPT VARCHAR(8000);rn MHISDESCRIPT VARCHAR(8000);rn CHECKUP VARCHAR(8000);rn CHECKASS VARCHAR(8000);rn COURSEREC VARCHAR(8000);rn MDESCRIPT1 VARCHAR(8000);rn MHISDESCRIPT1 VARCHAR(8000);rn CHECKUP1 VARCHAR(8000);rn CHECKASS1 VARCHAR(8000);rn COURSEREC1 VARCHAR(8000);rn admiss_times INT;rn DIAGNOSECONTENT VARCHAR(60);rn DIAGNOSERANGE NCHAR(1);rnrn --游标声明必须放到变量声明处,declare多余rn CURSOR audit_cursor ISrn rn SELECT mainmr.MRID,rn mainmr.papernum,rn inpatient.outdate,rn inpatient.admiss_times,rn inpatient.MDESCRIPT,rn inpatient.MHISDESCRIPT,rn inpatient.CHECKUP,rn inpatient.CHECKASS,rn inpatient.COURSEREC,rn alldiagnoserecord.DIAGNOSECONTENT,rn alldiagnoserecord.DIAGNOSERANGErn FROM mainmr, inpatient, alldiagnoserecordrn WHERE mainmr.MRID = inpatient.MRIDrn AND inpatient.MRID = alldiagnoserecord.sickidrn AND mainmr.MRID = MRIDrn AND (diagnosecontent = '妊娠糖尿病' OR diagnosecontent = '2型糖尿病' ORrn diagnosecontent = '1型糖尿病' OR diagnosecontent = '特殊类型糖尿病' ORrn diagnosecontent = '糖尿病');rnrnBEGINrn EXECUTE IMMEDIATE 'CREATE GLOBAL TEMPORARY TABLE ca_emr(rn MRID varchar(20),rn dia_date varchar(30),rn flag varchar(1) ,rn doctor varchar(5),rn iccardno varchar(20),rn MDESCRIPT long,rn MHISDESCRIPT long ,rn CHECKUP long ,rn CHECKASS long ,rn COURSEREC long,rn admiss_times smallint ,rn DIAGNOSECONTENT varchar(60),rn DIAGNOSERANGE nchar(2)rn )rn on commit PRESERVE rows';rnrn OPEN audit_cursor;rn LOOPrn rn FETCH audit_cursorrn INTO MRID1,rn iccardno,rn dia_date,rn admiss_times,rn MDESCRIPT1,rn MHISDESCRIPT1,rn CHECKUP1,rn CHECKASS1,rn COURSEREC1,rn DIAGNOSECONTENT,rn DIAGNOSERANGE;rn rn EXIT WHEN audit_cursor%NOTFOUND;rn rn SELECT convert(VARCHAR(8000), xmlcontent)rnrn INTO MDESCRIPTrn FROM xmlfilerecordrn WHERE xmlcontentid = MDESCRIPT1;rn rn SELECT convert(VARCHAR(8000), xmlcontent)rn INTO CHECKUPrn FROM xmlfilerecordrn WHERE xmlcontentid = CHECKUP1;rn rn SELECT convert(VARCHAR(8000), xmlcontent)rn INTO CHECKASSrn FROM xmlfilerecordrn WHERE xmlcontentid = CHECKASS1;rn rn SELECT convert(VARCHAR(8000), xmlcontent)rn INTO COURSERECrn FROM xmlfilerecordrn WHERE xmlcontentid = COURSEREC1;rn rn SELECT convert(VARCHAR(8000), xmlcontent)rn INTO MHISDESCRIPTrn FROM xmlfilerecordrn WHERE xmlcontentid = MHISDESCRIPT1;rn rn INSERT INTO ca_emrrn (MRID, flag, iccardno, dia_date, admiss_times, MDESCRIPT,rn MHISDESCRIPT, CHECKUP, CHECKASS, COURSEREC, DIAGNOSECONTENT,rn DIAGNOSERANGE)rn VALUESrn (MRID1, 'z', iccardno, dia_date, admiss_times, MDESCRIPT,rn MHISDESCRIPT, CHECKUP, CHECKASS, COURSEREC, DIAGNOSECONTENT,rn DIAGNOSERANGE);rn rn END LOOP; --end loop<em>缺少</em>分号rn CLOSE audit_cursor;rnrnEND out_emr;rnrnrnrnrnCompilation errors for PROCEDURE SZEMR.OUT_EMRrnrnError: PL/SQL: ORA-00936: <em>缺少</em><em>表达式</em>rnLine: 79rnText: SELECT convert(VARCHAR(8000), xmlcontent)rnrnError: PL/SQL: SQL Statement ignoredrnLine: 79rnText: SELECT convert(VARCHAR(8000), xmlcontent)rnrnError: PL/SQL: ORA-00936: <em>缺少</em><em>表达式</em>rnLine: 84rnText: SELECT convert(VARCHAR(8000), xmlcontent)rnrnError: PL/SQL: SQL Statement ignoredrnLine: 84rnText: SELECT convert(VARCHAR(8000), xmlcontent)rnrnError: PL/SQL: ORA-00936: <em>缺少</em><em>表达式</em>rnLine: 89rnText: SELECT convert(VARCHAR(8000), xmlcontent)rnrnError: PL/SQL: SQL Statement ignoredrnLine: 89rnText: SELECT convert(VARCHAR(8000), xmlcontent)rnrnError: PL/SQL: ORA-00936: <em>缺少</em><em>表达式</em>rnLine: 94rnText: SELECT convert(VARCHAR(8000), xmlcontent)rnrnError: PL/SQL: SQL Statement ignoredrnLine: 94rnText: SELECT convert(VARCHAR(8000), xmlcontent)rnrnError: PL/SQL: ORA-00936: <em>缺少</em><em>表达式</em>rnLine: 99rnText: SELECT convert(VARCHAR(8000), xmlcontent)rnrnError: PL/SQL: SQL Statement ignoredrnLine: 99rnText: SELECT convert(VARCHAR(8000), xmlcontent)rn
Oracle常用运算符及表达式
一、关系运算符基本与java一样,只是对于不等于,推荐使用:&amp;lt;&amp;gt; 二、表示范围:1、between    X    and    Y:X和Y代表范围数值,相当于[ X,Y ]2、X..Y :相当于[ X,Y ]三、存储过程中得赋值运算符以及字符链接符:“  :=  ”和“  || ”...
oracle中的条件表达式 case 表达式
https://docs.oracle.com/cd/B19306_01/server.102/b14200/expressions004.htmCASE expressions let you use IF ... THEN ... ELSE logic in SQL statements without having to invoke procedures. The syntax is:CA...
ORACLE 安装提示缺少依赖包
安装ORALCE 在做检验时提示<em>缺少</em>依赖包,其实是因为系统是64位系统而这些包都是32位的, This is a prerequisite condition to test whether the package "libaio-0.3.105" is available on the system This is a prerequisite condition to test w
redhat 安装oracle缺少的i386.rpm
compat-libstdc++-33-3.2.3-47.3.i386.rpm libaio-devel-0.3.105-2.i386.rpm libgcc-3.4.6-3.i386.rpm libgcc-4.1.2-55.el5.i386.rpm libstdc++-3.4.6-11.i386.rpm unixODBC-2.2.11-7.1.i386.rpm unixODBC-devel-2.2.11-7.1.i386.rpm
Oracle学习笔记 --- ORA:缺少左括号
<em>Oracle</em>学习笔记 --- ORA:<em>缺少</em>左括号
oracle number类型缺少精度
例子: select * from (select  sum(nvl(x3,0)) x3,max(xxdm) xxdm,max(bh) bh from tjb2017.jcj511 where bh=1 group by xxdm)a, (select  sum(nvl(x3,0)) x3,max(xxdm) xxdm,max(bh) bh from tjb2017.jcj511 where
redhat 安装oracle缺少的x86_x64.rpm
rehat 安装oracle 11g r2 <em>缺少</em>的64 位rpm包集合,包含: cloog-ppl-0.15.7-1.2.el6.x86_64.rpm compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm cpp-4.4.7-3.el6.x86_64.rpm elfutils-libelf-0.152-1.el6.x86_64.rpm elfutils-libelf-devel-0.125-3.el5.x86_64.rpm elfutils-libelf-devel-0.152-1.el6.x86_64.rpm elfutils-libelf-devel-static-0.152-1.el6.x86_64.rpm gcc-4.4.7-3.el6.x86_64.rpm gcc-c++-4.4.7-3.el6.x86_64.rpm glibc-devel-2.12-1.107.el6.x86_64.rpm glibc-headers-2.12-1.107.el6.x86_64.rpm kernel-headers-2.6.32-358.el6.x86_64.rpm ksh-20100621-19.el6.x86_64.rpm libaio-devel-0.3.107-10.el6.x86_64.rpm libstdc++-devel-4.4.7-3.el6.x86_64.rpm mpfr-2.4.1-6.el6.x86_64.rpm pdksh-5.2.14-37.el5_8.1.x86_64.rpm ppl-0.10.2-11.el6.x86_64.rpm unixODBC-2.2.14-12.el6_3.x86_64.rpm unixODBC-devel-2.2.14-12.el6_3.x86_64.rpm
oracle提示不是分组表达式
select CHANNEL_KIND, '全省' as cityid,stat_day as stat_day, sum(MOBILETOTAL_DEVNUM) MOBILETOTAL_DEVNUM, sum(DEVNUM_2G) DEVNUM_2G, sumrnrn(TOTAL3G_DEVNUM) TOTAL3G_DEVNUM, sum(NETCARD3G_DEVNUM) NETCARD3G_DEVNUM, sum(CONTRACT3G_DEVNUM) CONTRACT3G_DEVNUM, sum(CARD3G_DEVNUM) CARD3G_DEVNUM, sumrnrn(BROADBAND_DEVNUM) BROADBAND_DEVNUM, sum(FIXED_DEVNUM) FIXED_DEVNUM, sum(OTHER_DEVNUM) OTHER_DEVNUM, sum(TOTAL_DEVNUM) TOTAL_DEVNUM from V_SALEMAN_MANVIEW_DEVELOPDAY rnrnwhere 1=1 and stat_day>= '2011-08-15' and channel_kind <>'26' and cityid<>'0524' and manid ='admin' group by CHANNEL_KIND order by to_number(channel_kind)
Oracle正规表达式替换函数
 原来也支持子表示之间的贪婪模式权衡,对比较特别的需求特别的有用,记录之。 select orgcode, replace(orgcode, '-', '') orgcode_h, regexp_replace(replace(orgcode, '-', ''), '([0-9]+?)(([0]{2})+)$',
Oracle错误:表达式类型错误
--计算某读者已借几本书rnCreate or replace function f_borrowed_num(v_readerid number)rnreturn number rnasrnV_num number;rnBeginrnSelect count(*) into v_num from reader,borrow where reader.readerid=v_readerid and reader.readerid=borrow.readerid;rnReturn v_num;rnEnd;rnrn--利用自定义函数写一个只要在borrow表上有变动时就进行更新rest_borrow_num的触发器(双重游标循环我不太通,不太确定用的对不对)rncreate or replace trigger tr_update_borrowrnafter update or delete or insert on borrowrnfor each rowrndeclare rncursor cur_reader is select readerid from reader;rncursor cur_rule is select * from rule ;rnbeginrnfor v_readerid in cur_reader loop rnfor v_rule in cur_rule looprnupdate reader set rest_borrow_num=v_rule.num-f_borrowed_num(v_readerid) rnwhere v_readerid=:old.readerid and reader.readertype=v_rule.readertype;rnend loop cur_reader;rnend loop cur_rule;rnEnd;rn/rn运行触发器时报错:错误(270,61): PLS-00382: <em>表达式</em>类型错误rn求大佬告诉我触发器哪咋错了,游标双重循环错了吗?
ORACLE 计算出数值表达式的值
在ORACLE中,rn我现在有一个<em>表达式</em>,比如是‘1+2*3’rn我想用一个变量接收这个<em>表达式</em>的值,请问是用什么办法啊?rn我现在接收到的值就一直是这个<em>表达式</em>,而不能取到值
ORACLE报表中的SQL表达式
我在ORACLE数据库主页用应用程序构建器创建了报表(report),报表导入的是A表,在A表中有一个外键链接的是USER表,报表里外键显示的内容是USERNO的内容,USER表里有一个USERNAME。rn请问我如何设置能在报表中,让A表的这个外键显示的内容是USER表里的USERNAME,还有应该在哪个位置设置?
一个ORACLE 缺失表达式 的问题
就是下面这个句子。。我在SQL DEVELOPER中执行是没有问题的。。rn但是在.NET下面就会报 缺失<em>表达式</em>。。rn请各位帮我解答下疑问。。rnselect au.zz name,count(au.qcode) ccount from ISTIC_DATA_CSTPCD_AUTHOR au inner join (select distinct(arti.AID) disaid,arti.qcode qcode from ISTIC_DATA_CSTPCD_FUND fund inner join ISTIC_DATA_CSTPCD_ARTICLE arti on fund.qcode=arti.qcode where 1=1 and fund.JJXM like '%安徽%' ) te on te.qcode=au.qcode group by au.zz order by ccount desc
Oracle表函数和游标表达式
今天在书上看到两个概念:游标<em>表达式</em>和表函数,不是很明白,在网上查的资料也不怎么清楚,有没有人能帮忙讲讲啊,谢谢!
Oracle中FLWOR表达式的应用
相关的SQL语句如下:rn[code=SQL]rnCREATE TABLE some_xml (x XMLType); /*建立XMLType表*/rnINSERT INTO some_xml rn VALUES('rn rn Manu step 1 at Loc 1rn Manu step 2 at Loc 1rn Manu step 3 at Loc 1rn rn rn Manu step 1 at Loc 2rn Manu step 2 at Loc 2rn Manu step 3 at Loc 2rn rn '); /*插入XML数据*/rn[/code]rnFLWOR<em>表达式</em>:$step in /ManuInstructions/Location[1] return string($step)rn这个<em>表达式</em>是否有错?rn请高手帮忙写一个SELECT语句在SQL*Plus中显示我要显示的内容,即:Manu step 1 at Loc 2Manu step 2 at Loc 2Manu step 3 at Loc 2rnrn
oracle 缺失表达式 急啊。。
oracle 数据库第一次用,下面语句在数据库运行都很正常,前台执行的时候就提示<em>缺少</em><em>表达式</em>,我就不知道原因了。没遇到过。rnrn[code=sql]select o.organid,o.organname,s.sealid,s.raceword,s.sealname,s.lineword,s.sealtype from organ o left join seal s on o.organname=s.raceword where o.organid=@o.organid[/code]rnrn[img=https://img-bbs.csdn.net/upload/201307/23/1374550740_745717.png][/img]
Oracle 解析cron定时表达式
<em>Oracle</em> 解析cron<em>表达式</em>1.概述2.步骤2.1 规范cron<em>表达式</em>合理的创建标题,有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能,丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 1.概...
缺少对象,缺少
下面是树的代码:rn rnrn是不是"+tmp.getCname()+"不对啊?
缺少“(”
Set f2 = fso.OpenTextFile(Server.MapPath("\72\("cstr(date)"+".txt")"), 2, True)rnrnrn哪里出错了?
缺少对象">缺少";"和缺少对象
小弟用asp.net开发网页,要绑定图片,点击图片显示在页面某处,在CS文件里面写了个ajaxpro的Dataset方法,然后在JS文件里面这样写rnfunction init()//初始化页面rnrn GetQface(); rnrnfunction GetQface()rnrn var ds=_j.j.GetPhotoList().value;//cs里面方法的调用rn var s = new Array();rn s[s.length]=" "rn for(var i=0; i"; rn rn s[s.length]=""rn document.getElementById("div1").innerHTML = s.join("");rnrn页面就是一个id为div1的DIVrn红色字体为点击图片要发生的事件,但是写了这些,就报错,<em>缺少</em>";"和<em>缺少</em>对象,用最简单的return confirm测试还是一样,求教应该怎么写,多谢
缺少As??
Dim name(100) As StringrnPublic Function add(n As String, s As Integer)rn name(1) = nrnEnd Functionrnrn上面这段代码写到一个模块中了,但是编译器总是提示少As,请问上面的代码有什么问题?
oracle缺少的包。怎么装不上。
想在REDHAT 5.3上安装ORACLE 发现<em>缺少</em>三个必要的包。情况如下,rn<em>缺少</em>rnpackage compat-gcc-c++rnrnpackage compat-libstdc++ rnrnrnpackage compat-libstdc++-develrnrnrnrn[root@redhat3 rpm]# rpm -q gcc make binutils openmotif setarch compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-develrngcc-4.1.2-44.el5rnmake-3.81-3.el5rnbinutils-2.17.50.0.6-9.el5rnopenmotif-2.3.1-2.el5rnsetarch-2.0-1.1rncompat-db-4.2.52-5.1rncompat-gcc-7.3-2.96.122rnpackage compat-gcc-c++ is not installedrnpackage compat-libstdc++ is not installedrnpackage compat-libstdc++-devel is not installedrnrn<em>缺少</em>了三个包。但是找到这些包后。就是安装不上。情况如下:rnrnrnrpm -ivh compat-gcc-c++-7.3-2.96.122.i386.rpm rnrnwarning: compat-gcc-c++-7.3-2.96.122.i386.rpm: Header V3 DSA signature: NOKEY, key ID db42a60ernerror: Failed dependencies:rn compat-libstdc++ = 7.3 is needed by compat-gcc-c++-7.3-2.96.122.i386rn compat-libstdc++-devel = 7.3 is needed by compat-gcc-c++-7.3-2.96.122.i386rnrnrn还有rn rpm -ivh compat-libstdc++-7.3-2.96.122.i386.rpm rnrnwarning: compat-libstdc++-7.3-2.96.122.i386.rpm: Header V3 DSA signature: NOKEY, key ID db42a60ernPreparing... ########################################### [100%]rn file /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so from install of compat-libstdc++-7.3-2.96.122.i386 conflicts with file from package compat-libstdc++-296-2.96-138.i386rnrnrn还有rn rpm -ivh compat-libstdc++-devel-7.3-2.96.122.i386.rpm rnrnwarning: compat-libstdc++-devel-7.3-2.96.122.i386.rpm: Header V3 DSA signature: NOKEY, key ID db42a60ernerror: Failed dependencies:rn compat-libstdc++ = 7.3-2.96.122 is needed by compat-libstdc++-devel-7.3-2.96.122.i386rnrn
Oracle中如何实现缺少日期的填充?
传入两个参数:表名和日期字段名,要找出日期字段不连续的部分,并用前一条纪录填充以增加记录(日期字段不断加1,其他字段复制)进行补缺。从而生成一张日期连续递增不空缺的新表。 rn日期字段是日期类型 rn比如:传入参数只有表名“TableN”和日期字段名“DateA”,而实际表TableN中还包含ValueB和ValueC……等字段(可能还有其他字段,不确定)。而操作不变,日期字段DateA进行补充,ValueB、ValueC等字段进行复制。 rn用游标又怎么实现?? rn有一个思路:<em>Oracle</em>里可以定义记录型的变量,可以存储fetch出来的整条记录。 rndeclare rn cursor mycursor isrn select * from TableN order by DateA; --(用参数形式替代"TableN"和"DateA")rn cursorrecord1 mycursor%rowtype;--(cursorrecord存储整条取出来的记录)rn cursorrecord2 mycursor%rowtype;--(cursorrecord存储整条取出来的记录)rnbeginrn fetch mycursor into cursorrecord1;rn --将其中的DataA字段内容存到变量tmpdate中rn tmpdate:=cursorrecord1("DateA");--<em>Oracle</em>怎么将tmpdate赋值,高手指教rn while --条件:不是最后一条记录rn beginrn fetch mycursor into cursorrecord2;rn while --条件:tmpdate的后面一天<>cursorrecord2中的DateA字段rn --1.用该记录型变量cursorrecord1中的值(所有字段)添加新纪录,并把新记录中的DataA字段改为tmpdate加一rn --2.tmpdate加一,继续while循环,跳至第1.步rn endrn cursorrecord1:=cursorrecord2;--将cursorrecord1赋值为cursorrecord2,进行下一区间的判断rn tmpdate:=cursorrecord1("DateA");--rn endrnendrnrn rn如果用记录型变量记录从游标fetch出来的整行记录,保留日期,再把这条记录整条添加,并修改top 1的的时间为保留日期的后面一天,就实现了添加一条日期不存在的记录了。 rn但具体得如何实现??? rn请教高手... rn rn填充前的表TableN rnDateA ValueB ValueC rn2007-1-18 1 5 rn2007-1-20 3 7 rn2007-1-25 6 3 rn rn填充后形成的新表: rnDateA ValueB ValueC rn2007-1-18 1 5 rn2007-1-19 1 5 rn2007-1-20 3 7 rn2007-1-21 3 7 rn2007-1-22 3 7 rn2007-1-23 3 7 rn2007-1-24 3 7 rn2007-1-25 6 3 rn
oracle创建视图提示缺少右括号
1.创建视图中的select 语句单独执行查询没问题,在外面包上 create or replace view v_视图名 as() 时报ORA-00907:缺失右括号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>右括号
Linux安装oracle 11g系统缺少rpm包
Linux安装oracle数据库会报包<em>缺少</em>,这些是我收集的,后期再继续补充
linux centos 安装oracle缺少的rpm包
linux centos 安装oracle过程中所有<em>缺少</em>的rpm包 i386: compat-libstdc++-33-3.2.3-61.i386 elfutils-libelf-devel-0.137-3.el5.i386 elfutils-libelf-devel-static-0.137-3.el5.i386 gcc-4.1.2-46.el5.i386 gcc-c++-4.1.2-46.el5.i386 glibc-devel-2.5-42.i386 glibc-headers-2.5-42.i386 kernel-headers-2.6.18-164.el5.i386 libaio-0.3.105-2.i386 libaio-devel-0.3.106-3.2.i386 libgcc-3.4.6-3.i386 libgomp-4.4.0-6.el5.i386 libstdc++-3.4.6-11.i386 libstdc++-devel-4.1.2-46.el5.i386 pdksh-5.2.14-1.i386 sysstat-7.0.2-3.el5.i386 unixODBC-2.2.11-7.1.i386 unixODBC-devel-2.2.11-7.1.i386 i686: binutils-devel-2.20.51.0.2-5.36.el6.i686 compat-libstdc++-33-3.2.3-69.el6.i686 elfutils-libelf-devel-0.152-1.el6.i686 glibc-2.12-1.25.el6.i686 glibc-devel-2.12-1.25.el6.i686 libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6.i686 libgcc-4.4.5-6.el6.i686 libstdc++-4.4.5-6.el6.i686 libstdc++-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6.i686 libstdc++-docs-4.4.7-3.el6.i686 unixODBC-2.2.14-12.el6_3.i686 unixODBC-devel-2.2.14-12.el6_3.i686 zlib-1.2.3-29.el6.i686 zlib-devel-1.2.3-29.el6.i686 x86_64: binutils-2.20.51.0.2-5.20.el6.x86_64 binutils-2.20.51.0.2-5.36.el6.x86_64 binutils-devel-2.20.51.0.2-5.36.el6.x86_64 compat-libcap1-1.10-1.x86_64 compat-libstdc++-33-3.2.3-69.el6.x86_64 elfutils-libelf-devel-0.152-1.el6.x86_64 elfutils-libelf-devel-0.163-3.el7.x86_64 gcc-c++-4.4.5-6.el6.x86_64 glibc-2.12-1.25.el6.x86_64 glibc-2.17-105.el7.x86_64 glibc-devel-2.12-1.25.el6.x86_64 ksh-20100621-6.el6.x86_64 libaio-0.3.105-2.x86_64 libaio-0.3.107-10.el6.x86_64 libaio-0.3.109-13.el7.x86_64 libaio-devel-0.3.105-2.x86_64 libaio-devel-0.3.106-5.x86_64 libaio-devel-0.3.107-10.el6.x86_64 libaio-devel-0.3.109-13.el7.x86_64 libgcc-4.4.5-6.el6.x86_64 libgcc-4.8.5-4.el7.x86_64 libstdc++-4.4.5-6.el6.x86_64 libstdc++-4.8.5-4.el7.x86_64 libstdc++-devel-4.4.5-6.el6.x86_64 make-3.81-19.el6.x86_64 pdksh-5.2.14-30.x86_64 pdksh-5.2.14-36.el5.x86_64 sysstat-9.0.4-18.el6.x86_64 unixODBC-2.2.11-7.1.x86_64 unixODBC-2.2.14-12.el6_3.x86_64 unixODBC-2.3.1-11.el7.x86_64 unixODBC-devel-2.2.11-7.1.x86_64 unixODBC-devel-2.2.14-12.el6_3.x86_64 unixODBC-devel-2.3.1-11.el7.x86_64
Oracle 导入数据库 缺少表 怎么办
我要导入dmp文件 我先建了一个表空间 对应的建了三个用户 并且给了权限 但是在rnrnimp stodoc/stodoc@orcl file=c:\x.dmp full=y rn或rnimp stodoc/stodoc@orcl file=c:x.dmp fromuser=stodoc touser=stodoc 导入数据库的时候都<em>缺少</em>表和函数 存储过程rnrn怎么回事 请大家多多指教呀
oracle recovery database时报缺少归档日志
recovery database 报 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ======================...
linux下安装oracle缺少的所有包
linux下安装oracle<em>缺少</em>的所有包,在linux下安装oracle数据库必须的jar包
linux 安装oracle 缺少包集合.zip
linux安装oracle<em>缺少</em>包集合: libXau-devel-1.0.1-3.1.i386.rpm libXp-devel-1.0.0-8.1.el5.i386.rpm libXau-devel-1.0.1-3.1.i386.rpm
LINUX中安装oracle缺少的rpm包2
因为只能上传小于60M的文件,所以补上我找到剩下的资源。
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
Oracle 数据文件意外缺少的恢复过程
实验环境 操作系统为Window xp sp3 <em>Oracle</em>版本 oracle11gR1 数据库为归档模式,且归档日志存在,模拟数据文件丢失的操作 1.sqlplus /nolog conn sys/ticket as sysdba 查看数据文件以及编号 select file#,status from v$datafile; 关闭数据库 shutdown ...
oracle ora-12514错误监听器缺少实例
linux環境下啟動多個數據庫實例 (2009-07-13 09:18:42) 转载 标签: 杂谈   1.切換到數據庫用戶; 2.執行lsnrctl start命令; 3.執行export ORACLE_SID=欲啟動的數據庫實例; 4.執行sqlplus / nolog命令進入sql命令行模式; 5.執行connect sys/欲啟動的數據...
Oracle导出的dmp文件缺少表处理办法
这里写自定义目录标题欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题,有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能,丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 打发斯蒂芬 ...
oracle exp导出缺少表的处理
执行以下语句: select table_name from user_tables where segment_created = 'NO' 对查出的表进行修改 alter table JC_TOPIC allocate extent
1.LINUX中安装oracle缺少的rpm包
compat-libstdc++-33-3.2.3-61.i386.rpm libaio-0.3.105-2.i386.rpm libgcc-3.4.6-3.i386.rpm pdksh-5.2.14-1.i386.rpm unixODBC-devel-2.2.11-7.1.i386.rpm glibc-2.3.4-2.41.i686.rpm libaio-devel-0.3.105-2.i386.rpm libstdc++-3.4.6-3.1.i386.rpm unixODBC-2.2.11-7.1.i386.rpm
红帽6安装oracle缺少的rpm包
红帽6安装oracle检查依赖,所<em>缺少</em>的dmp包,包括32位和64位
LINUX中安装oracle缺少的rpm包
自己在linux中安装oracle11g碰到<em>缺少</em>rpm包的问题,网上下了很多资源,汇总了一些,希望能帮助需要的人。
linux下安装oracle最全的缺少
费了九牛二虎之力整理的在linux下安装oracle需要的包集合,详细信息如下:i386: compat-libstdc++-33-3.2.3-61.i386 elfutils-libelf-devel-0.137-3.el5.i386 elfutils-libelf-devel-static-0.137-3.el5.i386 gcc-4.1.2-46.el5.i386 gcc-c++-4.1.2-46.el5.i386 glibc-devel-2.5-42.i386 glibc-headers-2.5-42.i386 kernel-headers-2.6.18-164.el5.i386 libaio-0.3.105-2.i386 libaio-devel-0.3.106-3.2.i386 libgcc-3.4.6-3.i386 libgomp-4.4.0-6.el5.i386 libstdc++-3.4.6-11.i386 libstdc++-devel-4.1.2-46.el5.i386 pdksh-5.2.14-1.i386 sysstat-7.0.2-3.el5.i386 unixODBC-2.2.11-7.1.i386 unixODBC-devel-2.2.11-7.1.i386 i686: binutils-devel-2.20.51.0.2-5.36.el6.i686 compat-libstdc++-33-3.2.3-69.el6.i686 elfutils-libelf-devel-0.152-1.el6.i686 glibc-2.12-1.25.el6.i686 glibc-devel-2.12-1.25.el6.i686 libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6.i686 libgcc-4.4.5-6.el6.i686 libstdc++-4.4.5-6.el6.i686 libstdc++-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6.i686 libstdc++-docs-4.4.7-3.el6.i686 unixODBC-2.2.14-12.el6_3.i686 unixODBC-devel-2.2.14-12.el6_3.i686 zlib-1.2.3-29.el6.i686 zlib-devel-1.2.3-29.el6.i686 x86_64: binutils-2.20.51.0.2-5.20.el6.x86_64 binutils-2.20.51.0.2-5.36.el6.x86_64 binutils-devel-2.20.51.0.2-5.36.el6.x86_64 compat-libcap1-1.10-1.x86_64 compat-libstdc++-33-3.2.3-69.el6.x86_64 elfutils-libelf-devel-0.152-1.el6.x86_64 elfutils-libelf-devel-0.163-3.el7.x86_64 gcc-c++-4.4.5-6.el6.x86_64 glibc-2.12-1.25.el6.x86_64 glibc-2.17-105.el7.x86_64 glibc-devel-2.12-1.25.el6.x86_64 ksh-20100621-6.el6.x86_64 libaio-0.3.105-2.x86_64 libaio-0.3.107-10.el6.x86_64 libaio-0.3.109-13.el7.x86_64 libaio-devel-0.3.105-2.x86_64 libaio-devel-0.3.106-5.x86_64 libaio-devel-0.3.107-10.el6.x86_64 libaio-devel-0.3.109-13.el7.x86_64 libgcc-4.4.5-6.el6.x86_64 libgcc-4.8.5-4.el7.x86_64 libstdc++-4.4.5-6.el6.x86_64 libstdc++-4.8.5-4.el7.x86_64 libstdc++-devel-4.4.5-6.el6.x86_64 make-3.81-19.el6.x86_64 pdksh-5.2.14-30.x86_64 pdksh-5.2.14-36.el5.x86_64 sysstat-9.0.4-18.el6.x86_64 unixODBC-2.2.11-7.1.x86_64 unixODBC-2.2.14-12.el6_3.x86_64 unixODBC-2.3.1-11.el7.x86_64 unixODBC-devel-2.2.11-7.1.x86_64 unixODBC-devel-2.2.14-12.el6_3.x86_64 unixODBC-devel-2.3.1-11.el7.x86_64
oracle表达式之“ora-0079”不是group by表达式分析(未完待续。。。)
with tab as (select t.object_pid, t.mesh, round(x, 8) x, round(y, 8) y, round(z, 3) z, id from had_object_box_pole t, table(sdo_util.GetVertices(t.geo
oracle 报错表达式必须具有与对应表达式相同的数据类型
[img=https://img-bbs.csdn.net/upload/201707/27/1501122021_476499.png][/img][img=https://img-bbs.csdn.net/upload/201707/27/1501122028_55480.png][/img]
ORACLE下为什么执行会提示缺少表达式啊?? SQL下运行很正常。
update wcmchnldoc set docorder=row from (select *,row=row_number()over(order by docreltime) from wcmchnldoc)wcmchnldoc where docchannel=266rnrnrn这个语句在sql里很正常啊。在ORACLE里就不行了,ORACLE不也有row_number()over吗
请帮我看看这条sql,运行就说 ora-00936:缺少表达式
insert into pagelayoutrn (issuedate,rn nodeid,rn nsid,rn subscribed,rn displayorder,rn issuetime,rn nsdate,rn pubtime,rn publishpage)rnvaluesrn (select to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd'),rn masterid,rn nsid,rn 1,rn 1,rn to_date(to_char(sysdate, 'hh24:mi:ss'), 'hh24:mi:ss'),rn nsdate,rn to_date(to_char(sysdate, 'hh24:mi:ss'), 'hh24:mi:ss'),rn 1rn from nsreleaselibrn )rnrn请帮我看看这条sql,运行就说 ora-00936:<em>缺少</em><em>表达式</em>
请问怎么屏蔽编译错误 ,缺少表达式这个对话框
RT rn就是输入 a= 时,把光标点到别的地方时出现的这个提示对话框rn它严重影响我的编程心情和速度.......
TQuery控件open操作的时候提示ORA-00936缺少表达式,请教~!!
TQuery控件open操作的时候提示ORA-00936<em>缺少</em><em>表达式</em>,请教~!!
[在线等待]在模糊查询中怎么报缺少表达式~~~~~
<>"" Thenrn SqlPjlb="select count(*) cnt from t_phone_log where date like '%" & strFind & "%' or tellerno like '%" & strFind & "%' or trancode like '%" & strFind & "%' or tranname like '%" & strFind & "%' or note like '%" & strFind & "%'"rn elsern SqlPjlb="select count(*) cnt from t_phone_log "rn end ifrn if strFind<>"" Thenrn SqlPjlb="select * from t_phone_log where date like '%"&strFind&"%' or tellerno like '%"&_rn strFind&"%' or trancode like '%"&strFind&"%' or tranname like '%"&strFind&_rn "%' or note like '%"&strFind&"%'"rn elsern SqlPjlb="select * from t_phone_log "rn end if rn RS.CursorLocation = 3rn RS.open SqlPjlb,objConn,3rn RecordCount = RS.RecordCount rn %>rnrn我也查询了数据库没错rn这段有什么错误呢?
从本地sql向远程access插入数据 提示缺少表达式
Conn.Execute "INSERT OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0','Data Source="\\u861\D$\90生产\CBELL CBHNT6.0 混凝土搅拌站生产管理系统\CBHNT.mdb";User ID=Admin;Password=' )...T_RWD(rwdh,hth,yhmc,gcmc) SELECT rwdh,hth,khmc,gcmc FROM tygl..rwd where rwdh='" & Trwdh & "'""rnrn以上语句我是在vb6.0中调用的但是提示 提示<em>缺少</em><em>表达式</em>,请高手帮忙看看!!!!出错后光标总是停在“\\u861\D$\90生产”语句的\\反斜杠上!!
输入代码的时候为什么老是出现缺少表达式的现象
这是一段调整名称宽度的一段代码,请高手看一下错在哪里,谢谢。rnrnPublic Declare Function Findwindow Lib "user32" Alias "FindwindowA" _rn(ByVallpClassName As String, ByVallpWindowName As String) As LongrnrnPublic Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" _rn(ByVal hWnd1 As Long, ByVal hwnd As Long, _rnByVallpsz1 As String, ByVallpsz2 As String) As LongrnrnrnPublic Declare Function SendMessage Lib "user32" Alias "SendMessageA" _rn(ByVal hwnd As Long, ByVal wMsg As Long, _rnByVal wParam As Long, IParam As Any) As LongrnSub WidenNameBoxDrop2()rnDim Res As LongrnConst CB_SETDROPPEDWIDTH = &H160rnConst cWidth = 400 * 设定名称方块的宽度rnRes = SendMessage(_rnFindWindowEx( _rnFindWindowEx( _rnFindWindow("XLMAIN",Application.Caption) _rn,0,"EXCEL;",vbNullString) _rn,0,"combobox",vbNullString, _rnCB_SETDROPPEDWIDTH,cWidth,0)rnEnd Subrn
sql 里的ORA-00936:缺少表达式 是什么问题啊?
sql 里的ORA-00936:<em>缺少</em><em>表达式</em> 是什么问题啊? 有哪位大哥给解释一下。
为什么写在procedure中就缺少表达式?独立执行就没有问题?
我目前是以system登录:错误都是在组合字符串时发生,写在procedure中就<em>缺少</em><em>表达式</em>rn,独立执行就没有问题(说明语句时没有逻辑上或语法上的问题的),请教:rnrn 53 open dbcursor3 for 'select '||strTemp||' from '||strdbcursor1;rnERROR 位于第 1 行:rnORA-00936: <em>缺少</em><em>表达式</em>rnORA-06512: 在"TESTMIS.REFRESHINDEX", line 53rnORA-06512: 在line 1rnrn 36 execute immediate 'insert into testmis.zindex_info(dbbm,flbm,bbm,nr) '||rn 37 'select ''FXHY'',''FXHY_NULL'','''||strdbcursor1||''','||strTemp||' from '||strdbcursor1rnrnOR 位于第 1 行:rn-00936: <em>缺少</em><em>表达式</em>rn-06512: 在"TESTMIS.REFRESHINDEX", line 36rn-06512: 在line 1
请问ASP报“缺少表达式”错误,指的是什么意思?
在我执行SQL的时候:rnset rs = conn.execute(sql_string,RecsAffected,adCmdText)rn报错说:“<em>缺少</em><em>表达式</em>”,请问这具体指的是什么意思?rnrn具体错误信息如下:rn错误类型:rnMicrosoft OLE DB Provider for ODBC Drivers (0x80040E14)rn[Microsoft][ODBC driver for <em>Oracle</em>][<em>Oracle</em>]ORA-00936: <em>缺少</em><em>表达式</em>rn/myweb/the_fac_info.asp, 第 219 行rn
表达式(字符表达式、关系表达式
求子串操作 符号:(:) 语法 ->([]:[]) -> -> 说明 1.
表达式表达式解析器表达式解析器
<em>表达式</em><em>表达式</em>解析器<em>表达式</em>解析器<em>表达式</em>解析器<em>表达式</em>解析器<em>表达式</em>解析器
jsp 缺少 ,明明没有缺少
[code=Java]rnrn 您正在搜索商品 , 总共找到 件 rn ------------------------------------------------------------------------------------rn rn< end; i++)rn rn tryrn Document doc = search.hits.doc(i);rn catch(CorruptIndexException ex)rn rn ex.printStackTrace();rn rn catch(IOException ex)rn rn ex.printStackTrace();rn rn%>rn rn......rn rnrnrn rn上一页 rnrnrnrnrn下一页rnrn[/code]
Oracle计算时间差表达式(简单详细)
网站地址: http://www.51testing.com/?uid-16403-action-viewspace-itemid-106533
Oracle 插入数据是报错:ORA-00936 缺失表达式
insert into schedule_3 (Serialnum,prjectname,projectcode,state,nodename,pedstate,unitcode) rnvaluesrn (rn select a.Serial,rn c.apaname,c.apacode,2,a.ProjectNodename,1,b.unitcodern from Zdt_Model_ProjectPlan a , ZDT_PROJECTUNIT b , code_apanage crn where b.companycode=c.apacodern )rnrnrn这是我执行的sql语句,看起来好像没什么问题啊,可就是执行不了,报错:缺失<em>表达式</em>rnrn各位路过的高手们,请帮帮忙吧。。。
Oracle查询错误分析 ORA-01791 不是SELECTed表达式
<em>Oracle</em>查询错误分析 ORA-01791 不是SELECTed<em>表达式</em>
Oracle查询错误分析:ORA-01791:不是SELECTed表达式
表结构如下: create table HH_BOOK_GOOD ( ID VARCHAR2(32) not null, BOOKID VARCHAR2(32) not null, GOODID VARCHAR2(32) not null, GOODPRICE FLOAT not null, ...
oracle 如何通过表达式导出特定的表
数据库中存在很多表,都有特定的命名规则,例如商品系统,以sp_开头;rn现需求如下,我想通过emp的方式导出这些表及表中数据(包含blob,用pl/sql的导出不能用),如何实现rn例如:imp username/password@sid ignore=n tables=(table1,table2) file=d:\xxx.dmp log=d:\xx.logrn上面的例句中的tables=(table1,table2)能否用<em>表达式</em>来替换,例如tables=(sp_*)?这样写不对,该怎样写呢?rn希望及时答复!
零基础学JAVAWEB下载
《零基础学Java Web开发:JSP+Servlet+Struts +Spring+Hibernate+Ajax》,pPPT格式,简体中文版。 全面讲解Javaweb应用开发的编程技术,并详细介绍JaVaweb开发中各种常用的技术,可作为Javaweb开发技术的学习指南。   共17章,分为3篇。其中第1~12章是基础篇,讲解TJavaweb开发中必不可少的各种基础知识;提高篇包括第13~16章,主要讲解目#iJavaweb开发中常用的各种框架和新兴技术,如Struts、Spring、Hibernate和Ajax等,这些技术在实际的项目开发中都会被大量用到;第17章是实战篇,主要以Hib 相关下载链接:[url=//download.csdn.net/download/sky3319225/4435777?utm_source=bbsseo]//download.csdn.net/download/sky3319225/4435777?utm_source=bbsseo[/url]
3D max biped动作库下载
biped动作库,各种动作,直接导入,动作流畅 相关下载链接:[url=//download.csdn.net/download/u011345761/5722147?utm_source=bbsseo]//download.csdn.net/download/u011345761/5722147?utm_source=bbsseo[/url]
深入浅出JavaScript(中文版)下载
你将从《深入浅出javascript(中文版)》学到什么?这么说你准备从写html和css的静态网页跃进到编写动态网络应用程序脚本了?这里就是起点。《深入浅出java script》带你游历令人兴奋的交互式网页创建过程。为了启发你的思考,《深入浅出javascript(中文版)》覆盖了所有的java script基本知识,从基本网络编程技巧,如变量、函数和循环语句,到高级一些的专题,如表单验证、dom操作、客户端对象、脚本程序调试——甚至是aiax!赶快做好准备……快速响应的网站离你只有几页纸那么远。 相关下载链接:[url=//download.csdn.net/download/machen_smiling/8016167?utm_source=bbsseo]//download.csdn.net/download/machen_smiling/8016167?utm_source=bbsseo[/url]
相关热词 c# 线程结束时执行 c# kb mb 图片 c# 替换第几位字符 c#项目决定成败 c# 与matlab c# xml缩进 c#传感器基础 c#操作wps c# md5使用方法 c# 引用父窗口的组件
我们是很有底线的