在sql*plus里面写
例子:
SET SERVEROUTPUT ON;
CREATE OR REPLACE PROCEDURE Procdemo
AS
v_String1 VARCHAR2(50) := 'Hello World!';
BEGIN
DBMS_OUTPUT.PUT_LINE(v_String1);
END Procdemo;
/
例子:
SET SERVEROUTPUT ON;
CREATE OR REPLACE PROCEDURE Procdemo
AS
v_String1 VARCHAR2(50) := 'Hello World!';
BEGIN
DBMS_OUTPUT.PUT_LINE(v_String1);
END Procdemo;
/
create or replace view v_test
as
select * from tab;
直接写你的过程,用F8执行就生成过程了。
或者在dba studio 里写