CREATE PROCEDURE dbo.up_UpdatePublisherName
(
@pub_id char(4),
@pub_name varchar(40),
@Original_pub_name varchar(40)
)
AS
if exists(select pub_id
from publishers
where (pub_id = @pub_id) AND (pub_name = @Original_pub_name))
Begin
UPDATE publishers SET pub_name = @pub_name
WHERE (pub_id = @pub_id)
End
RETURN
(
@pub_id char(4),
@pub_name varchar(40),
@Original_pub_name varchar(40)
)
AS
if exists(select pub_id
from publishers
where (pub_id = @pub_id) AND (pub_name = @Original_pub_name))
Begin
UPDATE publishers SET pub_name = @pub_name
WHERE (pub_id = @pub_id)
End
RETURN
with the following statement:SELECT DECODE(rating, 1, 5000, 2, 2500, ...) INTO bonus FROM dual;
declare v_RecCount number;
begin
select count(*) into v_RecCount from Table where 条件
if v_RecCount>0 then
dbms_output.put_line('ok');
else
dbms_output.put_line('not ok');
end if;
end;
print '存在'
else
print '不存在'
end if