hutudanvip的专栏

导出 exp dp009/dperp32011@DEP_192.168.17.253 FILE=E:\AA.DMP TABLES=t_bd_accountbanks 导入 imp dp009/dperp32011@DEP_192.168.17.201 FILE=E:\AA.DMP tables=T_TMP_BUSIDEPTCOMPANY imp finmanager/fin

--创建包，并且定义类型test_cursor为游标 create or replace package testpackage        as type test_cursor is ref cursor; end testpackage; --创建过程，获取数据 create or replace procedure afei_pro_emp(        spNo

select count(*) from t_rpt_innerprofitlist truncate table t_rpt_innerprofitlist 1、建立目录 create or replace directory dir_dp1 as '/dump1'; 2、查看创建目录表 select * from dba_dir

1、建表语句 create table T_FINS_OAALERT (   FID VARCHAR2(44) primary key not null,   FBUSICODE VARCHAR2(20),   FBILLNUM VARCHAR2(20),   FBILLTYE VARCHAR2(20),   FBUSITYPE VARCHAR2(20),   FCREATETIM

oracle中 connect by prior 递归算法  Oracle中start with...connect by prior子句用法 connect by 是结构化查询中用到的，其基本语法是：  select ... from tablename start with 条件1  connect by 条件2  where 条件3;  例：  select * from t

以下是引用片段： 　　create public database 　　link fwq12 connect to fzept 　　identified by neu using 'fjept' 　　CREATE DATABASE LINK数据库链接名CONNECT TO 用户名 IDENTIFIED BY 密码 USING ‘本地配置的数据的实例名’; --创建DBLI

declare   type type_array is varray(192) of varchar2(80);   number_array type_array := type_array('20120201_W04061302'                                         );   id_array type_array := type_ar

手工刷新物化视图 exec dbms_mview.refresh('T_DAR_ARSTATE'); DROP MATERIALIZED VIEW t_dept_view; DROP MATERIALIZED VIEW t_dept_city_view; /*城市客户*/ CREATE MATERIALIZED VIEW t_dept_city_view --创建

--消耗很少 delete from t_dfn_monthdel  where (fshippernumberid,fmonth) in (select fshippernumberid,fmonth                    from t_dfn_monthdel                   group by fshippernumberid,fmonth

select * from t_gl_voucher; update t_dar_deparmonrptstart rpt set rpt.ffivouchered = 0; ---查看被锁的表 SELECT a.sid, b.owner, object_name, object_type FROM v$lock a, all_objects b WHERE TYPE =

/* 赋表 dep009.t_bd_bank dep009.t_cus_openbankser dep009.t_cus_cityser dep009.t_cus_provinceser 权限给用户finwbsuser */ grant insert,delete,select,update on dep009.t_bd_bank to finwbsuser; grant i

修改D:\oracle\product\10.2.0\client_1\tnsnames.ora文件 fin_67.25 =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.67.25)(PORT = 1521))     )     (CONNECT_D

create or replace package body barcode is procedure syncCommData is --变量定义 --Sql语句 v_insert_sql varchar2(2000); v_merge_sql varchar2(2000); v_delete_sql varchar2(2000); --是否有足够长的变更记录 hasLo

1、 /* *创建报表视图 */ create or replace view vm_claim_countcashrptdata as select        --事业部财务部        (select bus.finasyscode            from t_org_department bus           where bus.status = 1