create or replace procedure p_sl is
declare v_name varchar2(20);
begin
select name into v_name from p_test where name='&name';
end;
哪里有错误
declare v_name varchar2(20);
begin
select name into v_name from p_test where name='&name';
end;
哪里有错误
v_name varchar2(20);
begin
select ename into v_name from emp where ename='&name';
DBMS_OUTPUT.PUT_LINE(v_name);
end;
做个入参咋了
create or replace procedure p_sl is
v_name varchar2(20);
begin
select name into v_name from p_test where name='&name';
end;
--或者这样create or replace procedure p_sl(name1 p_test.name%type) is
v_name varchar2(20);
begin
select name into v_name from p_test where name=name1;
end;
create or replace procedure p_sl(E_name VARCHAR2)
is
declare
v_name varchar2(20);
begin
select name into v_name from p_test where name=E_name;
end;
一:
declare
v_name varchar2(20);
begin
select name into v_name from p_test where name='&name';
end;
二:
create or replace procedure p_sl is
v_name varchar2(20);
begin
select name into v_name from p_test where name='&name';
end;还有注意 select name from p_test where name='&name';返回的结果只能有一笔记录哦
1 is
2 v_name varchar2(20)
3 begin
4 select name into v_name from p_test where name=name1;
5 end;
6 /
n_name in varchar2,
v_name out varchar2)
begin
select name into v_name from p_test where name=n_name;
end;
v_name varchar2(20);
begin
select name into v_name from p_test where name='&name';
end;
为什么好多人都支持这个写法 这样编译出来是什么 有人瞧过么
在pl/sql里是跳出个小窗口让你输入参数值,输入什么,就存储过程中就用什么代替了
1 is
2 v_name varchar2(20)
3 begin
4 select name into v_name from p_test where name=name1;
5 end;
6 /