写了一个存储过程如下:没有参数!
但是出现了问题,行号= 1 列号= 35 错误文本= PLS-00103: 出现符号 ")"在需要下列之一时: <an identifier> <a double-quoted delimited-identifier> current
()
AS
a1 number(4);
a2 varchar2(20);
a3 varchar2(20);
a4 varchar2(20);
a5 varchar2(10);
a6 varchar2(40);
a7 varchar2(10);
a8 date;begin
select
Z_JID AS "序号",
d.W_QNAME AS "省",
e.W_QNAME AS "地市",
b.W_QNAME AS "县",
Z_JJQ AS "价区",
a.W_XCSXSZF AS "煤种",
Z_JJXJ AS "经销价",
Z_GXSJ as "时间"
into a1,a2,a3,a4,a5,a6,a7,a8
from ZT_GPJG, WT_XTCYXXSM a, WT_QGQYDM b, WT_QGQYDM d, WT_QGQYDM e
WHERE a.W_XCSZ=Z_JMZDM and a.W_XCSLX='煤种' and
b.W_QID=Z_JDSXBM and d.W_QID=substr(Z_JDSXBM,1,2)||'0000' and e.W_QID=substr(Z_JDSXBM,1,4)||'00';--return
--GO
end; 把()删掉也不行!试过了
但是出现了问题,行号= 1 列号= 35 错误文本= PLS-00103: 出现符号 ")"在需要下列之一时: <an identifier> <a double-quoted delimited-identifier> current
()
AS
a1 number(4);
a2 varchar2(20);
a3 varchar2(20);
a4 varchar2(20);
a5 varchar2(10);
a6 varchar2(40);
a7 varchar2(10);
a8 date;begin
select
Z_JID AS "序号",
d.W_QNAME AS "省",
e.W_QNAME AS "地市",
b.W_QNAME AS "县",
Z_JJQ AS "价区",
a.W_XCSXSZF AS "煤种",
Z_JJXJ AS "经销价",
Z_GXSJ as "时间"
into a1,a2,a3,a4,a5,a6,a7,a8
from ZT_GPJG, WT_XTCYXXSM a, WT_QGQYDM b, WT_QGQYDM d, WT_QGQYDM e
WHERE a.W_XCSZ=Z_JMZDM and a.W_XCSLX='煤种' and
b.W_QID=Z_JDSXBM and d.W_QID=substr(Z_JDSXBM,1,2)||'0000' and e.W_QID=substr(Z_JDSXBM,1,4)||'00';--return
--GO
end; 把()删掉也不行!试过了
解决方案 »
- oracle 安装时网络问题
- 请教 表名存在另外一个表的查询
- 函数异常使数据库连接失败?
- 急!!!!!!!!!!!!
- 求助老鸟! oracle 基础概念问题!
- 从oracle下载的oracle10为什么比9文件大小小得多,安装后所需空间相差也是这么大吗?另外10比9多消耗内存能资源吗?
- 对数据库的表每一项操作,比如“delete、insert、update”,在数据库的日志里都有记录吗?我能查看这些操作吗?
- Redhat AS 2.1下装Oracle9i问题请教?
- WINDOWS XP切换用户登录后不能使用原用户安装的ORACLE 客户端,怎么办
- 1000分求 ADO 存取oracle blob字段(存jpg图片)的源码(VC)!
- 紧急!PL/SQL中对查询结果关联显示的问题!!!
- RAC安装问题(急)
a1 number(4);
a2 varchar2(20);
a3 varchar2(20);
a4 varchar2(20);
a5 varchar2(10);
a6 varchar2(40);
a7 varchar2(10);
a8 date;begin
select
Z_JID AS "序号",
d.W_QNAME AS "省",
e.W_QNAME AS "地市",
b.W_QNAME AS "县",
Z_JJQ AS "价区",
a.W_XCSXSZF AS "煤种",
Z_JJXJ AS "经销价",
Z_GXSJ as "时间"
into a1,a2,a3,a4,a5,a6,a7,a8
from ZT_GPJG, WT_XTCYXXSM a, WT_QGQYDM b, WT_QGQYDM d, WT_QGQYDM e
WHERE a.W_XCSZ=Z_JMZDM and a.W_XCSLX='煤种' and
b.W_QID=Z_JDSXBM and
d.W_QID=substr(Z_JDSXBM,1,2)||'0000' and
e.W_QID=substr(Z_JDSXBM,1,4)||'00';
--return
--GO
end;