--查询姓name的人数
create or replace function namenum
(name IN varchar2)
return number
as
namenumber number;
begin
select count(*) into namenumber from COMMON.AB01 where AAB013 like name||'%';
return namenumber;
end namenum;
警告: 创建的函数带有编译错误
create or replace function namenum
(name IN varchar2)
return number
as
namenumber number;
begin
select count(*) into namenumber from COMMON.AB01 where AAB013 like name||'%';
return namenumber;
end namenum;
警告: 创建的函数带有编译错误
我试了下,创建应该是可以的;要不把那句改下试下
select count(*) into namenumber from COMMON.AB01 ttt
where ttt.AAB013 like name||'%';
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME VARCHAR2(20)
RQ DATE
SALARY NUMBER
SQL> CREATE OR REPLACE FUNCTION NAMENUM(CNAME IN VARCHAR2)
2 RETURN NUMBER
3 AS
4 NAMENUMBER NUMBER;
5 BEGIN
6 SELECT COUNT(*) INTO NAMENUMBER FROM TBL WHERE NAME LIKE CNAME||'%';
7 RETURN NAMENUMBER;
8 END NAMENUM;
9 /Function created.你用
SQL>Show err;
察看错误原因
行号= 1 列号= 29 错误文本= PLS-00103: 出现符号 "CREATE"在需要下列之一时: ( return compress compiled wrapped 这是我在console里看的.