create or replace procedure xiaoqlj
(
username_ID in varchar2(20))
)
is
cursor cus_cursor is
select username,usersex,telphone,email,address
from customer;
begin
dbms_output.enable;
for cus_index in cus_cursor loop
if cus_index.username=username_ID then
dbms_output.putline(cus_index.username);
end if;
end loop;
end;
这是完整的,但就是看不出错来。
(
username_ID in varchar2(20))
)
is
cursor cus_cursor is
select username,usersex,telphone,email,address
from customer;
begin
dbms_output.enable;
for cus_index in cus_cursor loop
if cus_index.username=username_ID then
dbms_output.putline(cus_index.username);
end if;
end loop;
end;
这是完整的,但就是看不出错来。
(
username_ID in varchar2)
)
is
cursor cus_cursor is
select username,usersex,telphone,email,address
from customer;
begin
dbms_output.enable;
for cus_index in cus_cursor loop
if cus_index.username=username_ID then
dbms_output.putline(cus_index.username);
end if;
end loop;
end;
/
varchar2)-〉varchar2
(
username_ID in varchar2)
)
is
cursor cus_cursor is
select username,usersex,telphone,email,address
from customer;
begin
for cus_index in cus_cursor loop
if cus_index.username=username_ID then
dbms_output.putline(cus_index.username);
end if;
end loop;
end;
/
这样应该可以!
create or replace procedure xiaoqlj
( username_ID in varchar2 )
is
cursor cus_cursor is
select username,usersex,telphone,email,address
from customer where username=username_ID;
begin
for cus_index in cus_cursor loop
dbms_output.put_line(cus_index.username);
end loop;
end;
/
(
username_ID in varchar2)
)
is
cus_index customer%rowtype;
cursor cus_cursor is
select username,usersex,telphone,email,address
from customer;
begin
dbms_output.enable;
for cus_index in cus_cursor loop
if cus_index.username=username_ID then
dbms_output.putline(cus_index.username);
end if;
end loop;
end;
/
PROCEDURE XIAOQLJ 出现错误:LINE/COL ERROR
-------- ---------------------------------------------
4/1 PLS-00103: 出现符号 ")"在需要下列之一时:
;iswithauthiddeterministic
parallel_enableas这错在哪里啊?