Oracle执行create view语句时提示ORA-00998:必须使用列别名命名此表达式
create view VW_PUB_SYS_DICT_CACHE as
  (
    SELECT rownum,
           0,
           a."'CACHESYSDICT'",
           a."COMBOBOX_CODE",
           a."OPTION_VALUE",
           a."OPTION_NAME"
    FROM (
           SELECT 'cacheSysDict',
                  COMBOBOX_CODE,
                  OPTION_VALUE,
                  OPTION_NAME
           FROM TB_PUB_DATADICT
           UNION ALL
           SELECT 'cacheBranch',
                  BRH_CODE,
                  BRH_CODE,
                  BRH_SHT_NAME
           FROM TB_PUB_BRANCH
           UNION ALL
           SELECT 'cacheSysDict',
                  'userCode',
                  AUTH_UID,
                  TELLER_NAME
           FROM TB_PUB_USER
           WHERE AUTH_TYPE = 'WB'
         ) a
  );

尝试过给所有表加别名,也无效。

我单独执行查询语句是可以的:

SELECT rownum,
           0,
           a."'CACHESYSDICT'",
           a."COMBOBOX_CODE",
           a."OPTION_VALUE",
           a."OPTION_NAME"
    FROM (
           SELECT 'cacheSysDict',
                  COMBOBOX_CODE,
                  OPTION_VALUE,
                  OPTION_NAME
           FROM TB_PUB_DATADICT
           UNION ALL
           SELECT 'cacheBranch',
                  BRH_CODE,
                  BRH_CODE,
                  BRH_SHT_NAME
           FROM TB_PUB_BRANCH
           UNION ALL
           SELECT 'cacheSysDict',
                  'userCode',
                  AUTH_UID,
                  TELLER_NAME
           FROM TB_PUB_USER
           WHERE AUTH_TYPE = 'WB'
         ) a

3个回答

自己解决了,前面加上视图的字段名即可。

CREATE OR REPLACE VIEW VW_PUB_SYS_DICT_CACHE ("ID", "OPTLOCK", "NAME", "TAG", "KEY", "VALUE") AS (
  SELECT rownum,
         0,
         a."'CACHESYSDICT'",
         a."COMBOBOX_CODE",
         a."OPTION_VALUE",
         a."OPTION_NAME"
  FROM (
         SELECT 'cacheSysDict',
                COMBOBOX_CODE,
                OPTION_VALUE,
                OPTION_NAME
         FROM TB_PUB_DATADICT
         UNION ALL
         SELECT 'cacheBranch',
                BRH_CODE,
                BRH_CODE,
                BRH_SHT_NAME
         FROM TB_PUB_BRANCH
         UNION ALL
         SELECT 'cacheSysDict',
                'userCode',
                AUTH_UID,
                TELLER_NAME
         FROM TB_PUB_USER
         WHERE AUTH_TYPE = 'WB') a
);

列名重复了BRH_CODE,
而且UNION ALL 的列名也不一致

create view VW_PUB_SYS_DICT_CACHE as
(
SELECT rownum,
0 type,
a.CACHESYSDICT,
a.COMBOBOX_CODE,
a.OPTION_VALUE,
a.OPTION_NAME
FROM (
SELECT 'cacheSysDict' cacheSysDict,
COMBOBOX_CODE COMBOBOX_CODE,
OPTION_VALUE OPTION_VALUE,
OPTION_NAME OPTION_NAME
FROM TB_PUB_DATADICT
UNION ALL
SELECT 'cacheBranch' cacheSysDict,
BRH_CODE COMBOBOX_CODE,
BRH_CODE OPTION_VALUE,
BRH_SHT_NAME OPTION_NAME
FROM TB_PUB_BRANCH
UNION ALL
SELECT 'cacheSysDict' cacheSysDict,
'userCode' COMBOBOX_CODE,
AUTH_UID OPTION_VALUE,
TELLER_NAME OPTION_NAME
FROM TB_PUB_USER
WHERE AUTH_TYPE = 'WB'
) a
);

yangxingzou
zoyation 回复伪墨: 多了引号,自己把所有没用的引号去掉,有引号就会当做固定字符串
7 个月之前 回复
qq997404392
伪墨 这样会提示 ORA-00904: "A"."'CACHESYSDICT'": 标识符无效
7 个月之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
oracle列别名使用
给列取一个其他名字,方便自己认识 select t.empno, t.ename from scott.emp t; select t.empno, t.ename as 名字 from scott.emp t; 列名上显示名字两个字 给临时结果取名字 select t.deptno, count(*) from scott.emp t group by t.deptn
oracle 执行提示缺少表达式
select to_char(blrq, 'yyyy-MM-dd HH24:mi:ss'),rn *rn from fjxx rn where tablename = 'foster_service_info'rn and fjlb = '4'rn and fjid = '8081C764039F183C'rn order by fjmcrn 执行提示缺少表达式
Oracle 列的别名
重命名一个列。 便于计算。 紧跟列名,也可以在列名和别名之间加入关键字‘AS’,别名使用双引号“”,以便在别名中包含空格或特殊的字符并区分大小写。 ...
Oracle:列别名
Oracle中输出结果中默认使用该列列名的大写形式作为列的标题select id id_temp from test 和select id as id_temp form test都是为test中id字段取别名。那么如何使用小写呢?解决方案: 就是给别名加上双引号select id "id_temp" from test
关于执行多条drop view,create view语句的问题
有如下语句:rn[code=SQL]rndrop view tablenamerngorncreate view tablename asrn select * .....rn ......rnrnrndrop view tablename2rngorncreate view tablename2 asrn select * .....rn ......rnrn[/code]rn单独执行一段语句,如rnrn[code=SQL]rndrop view tablenamerngorncreate view tablename asrn select * .....rn ......rn[/code]rn没有任何问题,但是一起执行的时候总提示我drop附近或者create附近有语法错误,到底怎么一回事?
在部署时执行sql,出错“'CREATE VIEW' 必须是批查询中的第一条语句。”,如何解决
部署的脚本里有table,view,procedure,因为脚本里不能有go,所以都去掉了,但是,它就出错,rn“'CREATE VIEW' 必须是批查询中的第一条语句。”,如何解决
ADO + Access 使用Create View语句时出错.
系统提示"没有使用MsysTables对象的必要权限,请让系统管理或安装此对对象的人为你设置适当的权限"rn但是,我使用"Drop Veiw"语句却是可以顺利通过.rn代码如下:rnvarrn Cmd : TADOCommand;rnbeginrnrn Cmd := TADOCommand.Create(Self);rn Cmd.Connection := ADOConnection1;rn Cmd.CommandText := 'Drop View Bank1';rn Cmd.Execute;rn Cmd.CommandText := 'Create View bank1 AS SELECT * FROM Bank';rn Cmd.Execute;rnend;
Oracle中列别名及条件范围的使用
列别名需要加双引号的情况: 1.列别名中需要严格区分大小写 2.列别名中存在空格 3.列别名中存在特殊字符:例如:&、$等特殊字符     注意:若特殊字符出现在中间,可以不加双引号 以下示例均采用表PERSON(PID,PNAME,PSEX,PSTATE,PMONEY) 示例:   SELECT A.PID,A.PNAME "GOOD NAME",A.PSEX,A.PSTA...
Oracle中视图的使用及ORA-00998错误
(作者:陈玓玏) 一、视图的概念及优缺点 视图是从一个或多个表导出的虚拟的表,其内容由查询定义。其具有普通表的结构,但是不实现数据存储。其实视图的功能和select语句是一样的,只是避免了重复写较复杂、使用频率较高的子查询。 视图的优点有:1、避免大量重复代码的出现;2、避免大量占用空间的临时表的出现;3、实现简单;4、数据的相对安全性,对于部分用户,只开放可供查询的数据,并限制其修改和...
C#使用列别名
C#使用列别名
使用列别名
本课程为 SQL 入门教程,基于最新标准 SQL: 2016,全面讲解六种主流数据库的 SQL 语句实现与差异,包括:Oracle、MySQL、SQL Server、PostgreSQL、Db2 以及 SQLite 。rn本课程面向
'CREATE VIEW' 必须是批查询中的第一条语句 ?
在SQL SERVER 中,'CREATE VIEW' 必须是批查询中的第一条语句。于是下面的语句在查询分析器中老是执行不了,错误提示如下提示:rnrn服务器: 消息 111,级别 15,状态 1,行 10rn'CREATE VIEW' 必须是批查询中的第一条语句。rnrnrnrn我的程序原句:rnDeclare @BillDate_From char(8)rnDeclare @BillDate_To char(8)rnrnSet @BillDate_From='20030501'rnSet @BillDate_To='20030509'rnrnCreate View vTotalSpentrnAsrnSelect Pin, IsNull(Sum(total_spent),0) as Total_SpentrnFrom BS_Batch_Daily_CDR_TotalrnWhere (batch_date Between @BillDate_From and @BillDate_To)rnGroup by Pinrnrn如果真的要在条件语句中用到变量,那么肯定要在create view之前初始化变量,但create view语句又必须为第一条语句。rnrn这个问题应该怎么解决,请大侠们多多指点! 谢谢!rn
'CREATE VIEW' 必须是查询批次中的第一个语句。
在c#中创建视图,出现'CREATE VIEW' 必须是查询批次中的第一个语句。 怎么解决啊rn语句为rnsql = string.Format(@"user 0 CREATE VIEW [dbo].vHisData AS 1 ", filename, viewSql); 其中filename为数据库名,viewsql为 连接表的语句rnsql = string.Format(@"user 0 go CREATE VIEW [dbo].vHisData AS 1 ", filename, viewSql);rnrnsql = string.Format(@"user 0 rngo rnCREATE VIEW [dbo].vHisData AS 1 ", filename, viewSql);rnrnsql = string.Format(@"user 0; rngo rnCREATE VIEW [dbo].vHisData AS 1 ", filename, viewSql);rn 等都报这个错误rn
“CREATE VIEW' 必须是批查询中的第一条语句”的问题
use SalesrnrnCREATE table salesmanrn(no int null unique,rnfname char(20) not null,rnfname char(20) not null,rnproduct_no char(10))rnrncreate table productrn(product_no char(10) not null unique,rnproduct_name char(20) null,rnprice money null)rnrncreate view product_inforn as select product_no,product_namern from productrnrnrnrn运行后就提示题目中的错误了,请大家帮帮忙,谢谢~~
为什么'CREATE VIEW' 必须是批查询中的第一条语句
为什么'CREATE VIEW' 必须是批查询中的第一条语句,请解释下,谢谢!
java执行sql语句使用别名时显示Column '***' not found
java执行sql语句使用别名时显示Column ‘*’ not found 在做一个小项目时遇到个问题,执行sql语句使用别名时总是报sql异常 Column ‘*’ not found,折腾半天终于找到了原因,下面是具体的错误,如果大家遇到同样的问题在找解决方法,可直接跳过看最后的解决方法。 问题描述 我在本地使用的是java、mysql、tomcat 服务器上的数据库为Maria...
oracle查询生成列别名
select ',' ,col.COLUMN_NAME ,' as ' ,LOWER(substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 1, 1)) || substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 2) from user_...
create view时碰到的问题
我要在一个sp里面创建一个view,sql如下:rnCREATE PROCEDURE sp_1rn@Server varchar(64),rn@DB varchar(64)rnASrnBEGINrnBEGIN TRANSACTIONrnCREATE VIEW tblA AS SELECT * FROM [192.168.0.2].[Data_A].dbo.tblA rn。。。。。。rnrn我在IP地址为192.168.0.1(假设而已,只要不是2就好)运行sp_1,当然运行前link了192.168.0.2的机器,这时候不会出错。但是当我在192.168.0.2机器上运行的时候,因为是自己,所以不用linkserver,当然也不能,但是这时候sp_1报如下的错误:rnServer:Msg 7391, Level 16, State 1, Line 2rnThe operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.OLE/DB provider returned message:New transaction cannot enlist in the specified transaction coordinator. rnrn什么原因?怎么解决?
*********执行此语句报错!!!!************
SQL>connect sys/change_on_install@orcl as sysdba --连接数据库rnSQL>select * from v$option where PARAMETER = 'Advanced replication';rnVALUE --查询是否支持高级复制rn-----rnTRUE --可以支持高级复制rnSQL>create user repadmin identified by repadim default tablespacernusers temporary tablespace temp; --建立管理高级复制的用户rnSQL>GRANT connect, resource, dba TO REPADMIN; --授权rn以上步骤都成功了.rnSQL>EXECUTE dbms_repcat_admin.grant_admin_any_schema('REPADMIN');rn----------------------------错误信息---------------------------------rnBEGIN dbms_repcat_admin.grant_admin_any_schema('REPADMIN'); END;rn *rnERROR 位于第 1 行:rnORA-06550: 第 1 行, 第 7 列:rnPLS-00201: 必须说明标识符 'DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA'rnORA-06550: 第 1 行, 第 7 列:rnPL/SQL: Statement ignoredrn---------------------------------------------------------------------rn不知道这是为什么,请指教.
oracle 连接运算符,连接字符串,||双竖线,在列别名上使用双引号,使用带有特殊字符的列别名...
[color=red]在列别名上使用双引号[/color] 输入并执行查询: [code="sql"]SELECT ename AS "Name", sal*12+5000 AS "年度工资(加年终奖)" FROM emp;[/code] 显示结果为: [code="sql"]Name 年度工资(加年终奖) --------------- --------...
Oracle 数据库-别名的使用
初学数据库,发现了别名使用的一些小问题,在网上没有搜到相应的内容,与大家分享一下一起探讨。select empno, ename, sal from emp where sal = 1250;语句很简单,单表条件查询,现在没有使用别名。下面加上别名:select empno, ename, sal 工资 from emp where sal = 1250;给sal这个列,起别名为工资,而我在wher
Oracle别名使用问题
[b]表结构与表数据:rncreate table fruit(fruitname varchar2(20),product varchar2(20),price varchar2(20));rninsert into fruit values('apple','china','12');rninsert into fruit values('apple','japan','22');rninsert into fruit values('apple','usa','33');rninsert into fruit values('orange','china','10');rninsert into fruit values('banana','china','31');rninsert into fruit values('peach','usa','30');[/b]rnrn[b]问题:rn1> select fruitname f from fruit where f='apple'; //无效的标识符rn2> select fruitname f from fruit where fruitname='apple'; //正确rn3> select fruitname,count(*) c from fruit group by fruitname having c>0; //无效的标识符rn4> select fruitname,count(*) c from fruit group by fruitname having count(*)>0; //正确rn5> select fruitname,count(*) c from fruit group by fruitname having count(*)>0 order by c; //正确[/b]rnrn[b]上述五个问题的运行结果为什么是那样,请解释下?rnrn在from子句中为表指定了别名,表的实际名称是不是被覆盖了?[/b]
create view
[code=SQL]create table hyzl_user(rn uID int unsigned auto_increment,rn uName nvarchar(50) not null,rn uPass nvarchar(20) not null,rn utName nvarchar(50) not null,rn uSex char(5) not null,rn uBir datetime,rn uConNum nvarchar(20),rn uNum nvarchar(20),rn uQQ bigint(8),rn uImg nvarchar(200),rn uEmail nvarchar(50),rn uAddr nvarchar(100),rn uConAddr nvarchar(100),rn uUrl nvarchar(50),rn uUserTypeID int unsigned default 1,rn primary key(uID)rn) ;rnrnrn/*版块信息表*/rncreate table bk_Module(rn bk_Name nvarchar(50) not null,rn bk_userName nvarchar(50) not null,rn bk_ID int unsigned auto_increment,rn primary key(bk_ID)rn);rnrncreate view bk_user as select rn bk_Module.*,rn hyzl_user.*rn from bk_Module left join bk_Module on(bk_Module.bk_userName=hyzl_user.uName);[/code]rnrn为什么插入最后一句view 语句的时候会报错呀:ERROR 1066 (42000): Not unique table/alias: 'bk_Module'rnrn请各位前辈指教一下呀
YII框架别名命名
public function actionAlias() { echo ""; //别名 Yii::setAlias('@fpp','ad/sd/er'); echo Yii::getAlias('@fpp').''; echo Yii::getAlias('@yii').''; echo Yii::getAlias('@app').'';
CREATE VIEW的SQL语句怎么在adoCommand中执行?
在查询分析器中执行正常,为什么adoCommand就报错?rnsql语句稍微有点长,难道只能写成存储过程吗。
关于create any view 和create view权限问题
当前操作用户为:b 具有create view权限 对a用户的表x1有查看,修改的权限 rn版本oracle 10.2.0.4rncreate view xxx a.x1 as rnselect * from a.b;rn--创建成功rncreate view xxx x1 asrnselect * from a.b;rn--权限不足rnrn版本oracle 10.2.0.1rncreate view xxx a.x1 as rnselect * from a.b;rn--权限不足rncreate view xxx x1 asrnselect * from a.b;rn--创建成功rnrn通过这两种测试结果,使得我对create any view 和create view 都有点迷糊了。下面是两种权限的解释:rnCREATE VIEW rn在自己的方案中创建、更改和删除视图 rnCREATE ANY VIEW rn在任何方案中创建视图rnrn但是依据上述解释,似乎无法解释我测试到的结果!rn抛砖引玉!说说你们的看法!
Create View
create or replace view vw_contract_contractlist asrnrnselect ax.contractno,rn(select tb2.inoutdate from (select tb1.inoutdate from iv_record tb1rnwhere tb1.iv_inouttypeid=1 and tb1.contractno=ax.contractno) tb2 where rownum<2) as inouttime--入库时间rnfrom xs_contract axrn/rnrnrnzx.contractno无法被识别,请问不别外写函数,这个怎么解决;
命名别名与历史命令
命名别名:alias、unalias 例如: 历史命令:history
oracle执行插入语句时提示miss select
我是用oracle11g,pl/sql工具,rn创建了一个表rncreate table trn(rn id int primary key,rn name varchar(10)rn)rnrn执行插入语句rninsert into t value(1,'张三');rn为什么会提示ORA-00928:missing select keyword啊?
Mysql Where使用列别名
select s.*,(2 * 6378.137* ASIN(SQRT(POW(SIN(PI()*(39.9148890000-s.lat)/360),2)+COS(PI()*39.9148890000/180)* COS(s.lat * PI()/180)*POW(SIN(PI()*(39.9148890000-s.lng)/360),2)))) as juli from vip_stores as s where juli<5.0 order by juli asc limit 0,20rnrnrn上面的这条代码,where后面使用别名juli,有问题 ,该怎么解决
使用Jboss ide时,Jboss server view提示Could not create the view,请大家帮忙!
小弟刚开始学习使用jbossrnrnjava版本:1.6.0_07rnjboss-4.2.3.GA路径:D:\JBoss\jboss-4.2.3.GArn编辑器:eclipse-jee-ganymede-win32rnrn是在jboss官网下载的rnhttp://www.jboss.org/tools/download/index.htmlrnhttp://download.jboss.org/jbosstools/builds/nightly/200808051539-nightly/index.htmlrnrn其他组件:rnxsd-runtime-2.4.0rndtp-sdk_1.6.0rnemf-runtime-2.4.0rnGEF-SDK-3.4.0rnwtp-sdk-R-3.0-20080616152118arnrnJBossTools-2.1.2.GA-ALL-win32和JBossTools-200808051539-nightly-ALL-win32都有rn=================================================rn在网上下了几个helloworld的例子,在jboss里面发布后都可以运行和访问,rnrn但在eclipse里面调出jboss server view时,却提示:rn Could not create the view: org/eclipse/wst/server/ui/internal/view/servers/ServerActionrnrn详细信息:rnjava.lang.NoClassDefFoundError: org/eclipse/wst/server/ui/internal/view/servers/ServerActionrn at org.jboss.ide.eclipse.as.ui.views.server.ServerTableViewer.(ServerTableViewer.java:204)rn at org.jboss.ide.eclipse.as.ui.views.server.ServerFrame.(ServerFrame.java:113)rn at org.jboss.ide.eclipse.as.ui.views.server.JBossServerView.createPartControl(JBossServerView.java:141)rn at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:371)rn at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:230)rn at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:594)rn at org.eclipse.ui.internal.Perspective.showView(Perspective.java:2127)rn at org.eclipse.ui.internal.WorkbenchPage.busyShowView(WorkbenchPage.java:1062)rn at org.eclipse.ui.internal.WorkbenchPage$19.run(WorkbenchPage.java:3773)rn at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)rn at org.eclipse.ui.internal.WorkbenchPage.showView(WorkbenchPage.java:3770)rn at org.eclipse.ui.internal.WorkbenchPage.showView(WorkbenchPage.java:3746)rn at org.eclipse.ui.handlers.ShowViewHandler.openView(ShowViewHandler.java:165)rn at org.eclipse.ui.handlers.ShowViewHandler.openOther(ShowViewHandler.java:109)rn at org.eclipse.ui.handlers.ShowViewHandler.execute(ShowViewHandler.java:77)rn at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:281)rn at org.eclipse.core.commands.Command.executeWithChecks(Command.java:476)rn at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)rn at org.eclipse.ui.internal.handlers.HandlerService.executeCommand(HandlerService.java:169)rn at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:247)rn at org.eclipse.ui.internal.ShowViewMenu$3.run(ShowViewMenu.java:134)rn at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)rn at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:583)rn at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:500)rn at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)rn at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)rn at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)rn at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823)rn at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422)rn at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2382)rn at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2346)rn at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2198)rn at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:493)rn at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288)rn at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:488)rn at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)rn at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)rn at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)rn at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)rn at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)rn at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:382)rn at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)rn at java.lang.reflect.Method.invoke(Unknown Source)rn at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)rn at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)rn at org.eclipse.equinox.launcher.Main.run(Main.java:1236)rnrn请大家帮忙看一下,怎么解决这个问题?rnrnrnrnrn
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代表层级  
怎样在TADOQuery中执行create view ???
小弟用的语句如下: rnrnvstr:='create view ....';rnrnadoquery1.Active:=false;rnadoquery1.SQL.Clear;rnadoquery1.SQL.Add(vstr);rnadoquery1.Prepared:=true;rnadoquery1.ExecSQL;rnrn执行时报错.
Oracle使用with as语句提示未明确定义列
with contractinfo as    (select ic.contractno ,          ic.erpno,          ic.custno,          ic.signtime,          ic.signetime,          ic.contractcount,          ic.money,          ic.sa
C# 中提示“要编译此程序,使用下面的命名:。。。”?
C# 中提示----要编译此程序,使用下面的命名:rn csc /t:exe /debug+ DataReader.cs /r:System.Data.dllrn只知道System.Data.dll是装配件,要怎么引用,高手请不吝指教,详细说说
执行存储过程时提示无效的sql语句!
以下是存储过程rnrn--开始rnrnrncreate or replace procedure ZHUYE as rnbeginrnrnbegin --如果表存在则删除rn rnexecute immediate ' drop table zhuyecompany';rnexception when others thenrnnull;rnend;rnrnrnrnrncreate table zhuyecompany( ---创建表rnrnpk_costsubj varchar(50),rncostcode varchar(50),rncostname varchar(50),rnzyjg float, --主业机关rnyisc float, rnhj floatrn)rn rnrncreate table sum_costsubj asrnselect b.settleunitname,f.pk_settleunit,fb.pk_costsubj,sum(plan_money) as plan_money rnfrom fp_planbill f left join bd_settleunit b on f.pk_settleunit=b.pk_settleunitrn left join fp_planbill_b fb on f.pk_planbill=fb.pk_planbillrn where 1 = 1 and f.pk_corp = '1051' and f.vbillstatus >= '3' rngroup by b.settleunitname,f.pk_settleunit,fb.pk_costsubj rnrnrninsert into zhuyecompany(pk_costsubj,costcode,costname)rnselect pk_costsubj,costcode,costname from bd_costsubj where pk_corp='1051' and costcode not in('5','9','901','902') order by costcodernrnupdate zhuyecompany set zyjg=(select plan_money from sum_costsubj where zhuyecompany.pk_costsubj=sum_costsubj.pk_costsubj and sum_costsubj.settleunitname='石家庄东方龙供水有限责任公司')rnrnupdate zhuyecompany set yisc=(select plan_money from sum_costsubj where zhuyecompany.pk_costsubj=sum_costsubj.pk_costsubj and sum_costsubj.settleunitname='石家庄东方龙供水有限责任公司一水厂')rnrnrnrnupdate zhuyecompany set hj=zyjg+yisc+ersc+sansc+sisc+wusc+liusc+qisc+basc+jxfugs+gxglc+wxgs+jlglzx+jyysbgs+zhjds+yhfwzx+szjcz+gsjls+hqglzx+jsjc+zgyy+ymyey where 1=1rnrnend;rnrnrnrnrnEXECCUTE ZHUYErnrnrnrnrnrnrnrnrnrnrn
postgre执行以下语句时提示内存溢出。
我在GP也就是postgre数据库中执行:rnselect entry_id ,array_agg(g_no) as g_no,array_agg(G_NAME) as g_name from entry_list group by entry_id;rn时,提示内存溢出。请问如何解决?rnNOTICE: Out of memory. Failed on request of size 40 bytes. (context 'accumArrayResult') (aset.c:840) (seg0 slice1 seg1:50000 pid=21714)rnrn
Oracle批量处理create sql语句
今天,在执行创建多个function时,发现Oracle执行完多条create or replace 语句后,实际上只创建一个function。 进去看了一下该function,出现错误:出现符号create,原因是执行多条create语句,但批量创建function,只创建一个。 开始怀疑sql语句写错,再三检查后,sql语句并没错。那只有一个可能,Oracle没有自动判别批量执行。 之前...
此语句不能执行为什么
if exists (select name from sysobjects where name='收发记录库1' and type='t')rnDROP TABLE 考收发记录库1
oracle给列取别名、给表取别名
当前SC表数据: SNO    CNO    SCORE s001    c001    78.90 s002    c001    80.90 s003    c001    81.90 s004    c001    60.90 s001    c002    82.90 s002    c002    72.90 s003    c002    81.90 s001
相关热词 c++和c#哪个就业率高 c# 批量动态创建控件 c# 模块和程序集的区别 c# gmap 截图 c# 验证码图片生成类 c# 再次尝试 连接失败 c#开发编写规范 c# 压缩图片好麻烦 c#计算数组中的平均值 c#获取路由参数