存储的问题(页 1) - Oracle

nply 发表于 2007-12-17 19:48

存储的问题

create or replace procedure Proc_Lz_t_transit_paper_master() istransit_count varchar2(10);begin select 'aaa' into transit_count from dual; dbms_output.put_line('人数' || transit_count);end Proc_Lz_t_transit_paper_master;
这个哪里写错了，帮忙看看

ILoveMK 发表于 2007-12-17 20:22

create or replace procedure Proc_Lz_t_transit_paper_master as
transit_count varchar2(10);
begin
select 'aaa' into transit_count from dual;
dbms_output.put_line('人数'||transit_count);
end;

sun521 发表于 2007-12-25 16:44

select count(*) into transit_count from dual;
这样查的是你有多少记录

elvis123 发表于 2007-12-25 17:15

[quote]原帖由 [bold][underline]sun521[/underline][/bold] 于 2007-12-25 16:44 发表 [url=http://bbs.bc-cn.net/redirect.php?goto=findpost&pid=1160028&ptid=193000][img]http://bbs.bc-cn.net/images/common/back.gif[/img][/url]
select count(*) into transit_count from dual;
这样查的是你有多少记录 [/quote]
8 neng 'from dual'^-^!

ILoveMK 发表于 2007-12-25 18:59

[quote]原帖由 [bold][underline]elvis123[/underline][/bold] 于 2007-12-25 17:15 发表 [url=http://bbs.bc-cn.net/redirect.php?goto=findpost&pid=1160045&ptid=193000][img]http://bbs.bc-cn.net/images/common/back.gif[/img][/url]

8 neng 'from dual'^-^! [/quote]是的。

页: [1]