下面这个用ORACLE怎么写啊?
create procedure
(
v_delflg IN VARCHAR2,
v_withdata IN VARCHAR2,
v_columnList IN VARCHAR2,
RefCur_MasterBO OUT VARCHAR2,
v_totalCount OUT VARCHAR2);
)
as
select F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT from tmdr01
set RefCur_MasterBO = '123';
set v_totalCount = select count(1) from tmdr01
急用!!!!!在线等!!!!!
create procedure
(
v_delflg IN VARCHAR2,
v_withdata IN VARCHAR2,
v_columnList IN VARCHAR2,
RefCur_MasterBO OUT VARCHAR2,
v_totalCount OUT VARCHAR2);
)
as
select F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT from tmdr01
set RefCur_MasterBO = '123';
set v_totalCount = select count(1) from tmdr01
急用!!!!!在线等!!!!!
VARC := SELECT COUNT(1) FROM TMDE01;
SELECT VAR;
VARC := SELECT COUNT(1) FROM TMDr01;
SELECT VARC;这句话应该怎么写啊? 报错
等价于SQL Server的
deckare @VARC int
select @VARC=count(1) from TMDr01
select @VARC
create or replace procedure proc_name
(
v_delflg IN VARCHAR2,
v_withdata IN VARCHAR2,
v_columnList IN VARCHAR2,
RefCur_MasterBO OUT VARCHAR2,
v_totalCount OUT VARCHAR2);
)
as
begin
select
F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT
from tmdr01
RefCur_MasterBO := '123';
v_totalCount := (select count(1) from tmdr01);
end
create procedure proc_name
(
v_delflg IN VARCHAR2,
v_withdata IN VARCHAR2,
v_columnList IN VARCHAR2,
RefCur_MasterBO OUT VARCHAR2,
v_totalCount OUT VARCHAR2);
)
as
select
F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT
from tmdr01
RefCur_MasterBO := '123';
v_totalCount := (select count(1) from tmdr01);
end