To protect the security of Oracle Database Previous / Next 2010-04-14 17:25:20 / Personal Category: oracle View (10) / Comments (0) / Rate (0 / 0) Each organization should develop a safety standard, safe and right or wrong, this is only to comply wit ...
rn rn http://www.cnblogs.com/tohen/archive/2008/11/17/1335186.html rn First, create a PLSQL table: rn create table HWQY.TEST (CARNO VARCHAR2 (30), CARINFOID NUMBER) rn rn rn Second, create a PLSQL stored procedure: rn create or replace procedure pro_ ...
First, create a PLSQL table: create table HWQY.TEST ( CARNO VARCHAR2 (30), CARINFOID NUMBER ) Second, create a PLSQL stored procedure: create or replace procedure pro_test AS carinfo_id number; BEGIN select s_CarInfoID.nextval into carinfo_id from du ...
First, create a PLSQL table: create table HWQY.TEST ( CARNO VARCHAR2 (30), CARINFOID NUMBER ) Second, create a PLSQL stored procedure: create or replace procedure pro_test AS carinfo_id number; BEGIN select s_CarInfoID.nextval into carinfo_id from du ...
We often export oracle9i database backup, then need a way to make it automatically Reference to the netizens approach, my approach is as follows: The first step: Open Notepad type: exp test / test @ test file = d: / backup /% date: ~ 0,10%. dmp log = ...
rnrnrnrn The timing of the Oracle database, hot backup (Exp) are usually two approaches can be achieved, one is in the Oracle database, provided the task of using Queue Manager (Job Queue) to be achieved; the other is to use the operating system to e ...
