放在数据字典里面
system表空间简单的例子:
CREATE OR REPLACE PROCEDURE Procdemo
AS
v_String1 VARCHAR2(50) := 'Hello World!';
BEGIN
DBMS_OUTPUT.PUT_LINE(v_String1);
END Procdemo;
/
system表空间简单的例子:
CREATE OR REPLACE PROCEDURE Procdemo
AS
v_String1 VARCHAR2(50) := 'Hello World!';
BEGIN
DBMS_OUTPUT.PUT_LINE(v_String1);
END Procdemo;
/
as
begin
insert into tj_jkcd(ship_name_cn,cc,kz,xx,voyage_no,cdmc,i_e_date,zrxs,bzxs)
select ship_name_cn,cc,kz,xx,voyage_no,cdmc,i_e_date,count(cc) zrxs,count(cc)*(to_number(cc)/20) bzxs
from jkcd
where cc in('20','40')
group by ship_name_cn,cc,kz,xx,voyage_no,cdmc,i_e_date;
end;