ORACLE 常用语句

ORACLE 常用语句

1. CREATE USERS

DROP USER DEMO_DB CASCADE;
CREATE USER DEMO_DB IDENTIFIED BY DEMO_DB DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS;
GRANT CREATE SESSION TO DEMO_DB;
GRANT CONNECT TO DEMO_DB;
GRANT RESOURCE TO DEMO_DB;
GRANT SYSDBA TO DEMO_DB;
GRANT CREATE ANY TABLE TO DEMO_DB;
GRANT UNLIMITED TABLESPACE TO DEMO_DB;
GRANT CREATE ANY PROCEDURE TO DEMO_DB;


IMP SYSTEM/MANAGER FILE=C:\DEMO_DB.DMP FROMUSER=DEMO_DB TOUSER=DEMO_DB IGNORE=Y;


BEGIN PS_APP_NPI_002_PKG.PS_ALL_001_M_CASHFLOW(P_USR => "TEST",
                                           P_RUN_TYPE => "U",
                                           P_PROGRAM_ID => 100002,
                                           P_STATUS => "",
                                           P_ERR_MSG => "");
END;


EXEC PS_APP_NPI_002_PKG.PS_ALL_001_M_CASHFLOW(P_USR => "TEST",P_RUN_TYPE => "U",P_PROGRAM_ID => 100002,P_STATUS => "",P_ERR_MSG => "");

2.