我建的一个存储过程用来creat视图 和update 表 但执行的时候报错
在行 1 上开始执行命令时出错:
execute updateranklist
错误报告:
ORA-00911: 无效字符
ORA-06512: 在 "SYSTEM.UPDATERANKLIST", line 4
ORA-06512: 在 line 1
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.
*Action:
~~~~~~~~~~~~~~~~~~~~分割线~~~~~~~~~~~~~~~~~~~~~~~~~
procedure的定义如下
create or replace
procedure updateranklist
is
begin
execute immediate'
create or replace view ranklist (user_nickname,user_time) as
select nickname,lasttime from appuser where lasttime>0 order by lasttime desc;
update appuser set lasttime=0';
end;
纠结了好长时间,,求大神指导
在行 1 上开始执行命令时出错:
execute updateranklist
错误报告:
ORA-00911: 无效字符
ORA-06512: 在 "SYSTEM.UPDATERANKLIST", line 4
ORA-06512: 在 line 1
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.
*Action:
~~~~~~~~~~~~~~~~~~~~分割线~~~~~~~~~~~~~~~~~~~~~~~~~
procedure的定义如下
create or replace
procedure updateranklist
is
begin
execute immediate'
create or replace view ranklist (user_nickname,user_time) as
select nickname,lasttime from appuser where lasttime>0 order by lasttime desc;
update appuser set lasttime=0';
end;
纠结了好长时间,,求大神指导
解决方案 »
- 菜鸟求助,创建oracle用户问题
- oracle sql 相同数据合并
- imp导入单张表的问题
- 请问如何在oracle中批量导入EXACLE
- 在Oracle中有很多表名是以v$起始的,请问是什么意思?
- rman备份表空间>删除表空间>重建表空间 无法恢复表空间,为什么?
- 存储过程中查询数据的问题
- 我用DELPHI作为前端,写了两种SQL语句,要送到ORACLE服务器执行,哪一种运行得更快一些呢?语句如下...
- 如何用imp导入指定的用户的所有的表,即该用户的表空间,原来用exp导出时是整个数据库
- 问一个SQL逻辑的问题,sql执行和预期不符合,SQL大拿请帮忙哦!!
- oracle8i的DBA Studio无法打开
- 求教一个多对多的匹配问题 Oracle
--try
create or replace
procedure updateranklist
is
begin
execute immediate'create or replace view ranklist (user_nickname,user_time) as
select nickname,lasttime from appuser where lasttime>0 order by lasttime desc';
execute immediate 'update appuser set lasttime=0';
end;
/exec updateranklist;