oracle如何創(chuàng)建存儲過程呢？首先需要授權(quán)sqlplus / as sysdbagrant create view to your_user然后創(chuàng)建表和存儲過程drop table table1cr

oracle如何創(chuàng)建存儲過程呢？

首先需要授權(quán)

sqlplus / as sysdba

grant create view to your_user

然后創(chuàng)建表和存儲過程

drop table table1create table TABLE1( user_id VARCHAR2(10)， user_name VARCHAR2(10)， user_mail VARCHAR2(10)， user_mobile VARCHAR2(10)， user_telephone VARCHAR2(10))CREATE OR REPLACE PROCEDURE CREATEVIEWS IS V_SQL VARCHAR2(10240)BEGIN V_SQL := "CREATE OR REPLACE VIEW V_TEST AS SELECT T1.USER_ID， T1.USER_NAME， --用戶姓名 T1.USER_MAIL， --用戶MAIL T1.USER_MOBILE， --用戶手機(jī) T1.USER_TELEPHONE --用戶電話 FROM TABLE1 T1" EXECUTE IMMEDIATE V_SQLEND CREATEVIEWS/

執(zhí)行，OK

SQL> exec createviewsPL/SQL procedure successfully completed