好好学习，好好工作

安装数据库时选择utf-8修改以下charset配置，然后重启[client]port=3306[mysql]default-character-set=gbk[mysqld]port=3306basedir="D:/Program Files/MySQL/MySQL Server 5.5/"datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.5/Data/"character-set-serv

1、expdp bom/app@jd18:1521/orcl dumpfile=bpm.dmp directory=DATA_PUMP_DIR schemas=bpm 2、impdp bom/app@jd18:1521/test dumpfile=bpm.dmp directory=DATA_PUMP_DIR schemas=bpm remap_tablespace=TBS_APP:TBS_AP

运用UTL_FILE包进行文件的读写操作   读文件的操作如下 步骤1：在oracle数据库中创建文件目录 SQL>create or replace directory ORADIR_HY  as '/home/qaadmin/';(如果登录的oracle用户没有创建目录的权限，则需要先授权 授权语句：Grant create  any directory to m

USE [test] GO /****** Object:  StoredProcedure [PROJECT].[autofix_user]    Script Date: 12/06/2012 15:25:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- =========================

WITH parent as( select CONVERT(nvarchar,row_number() OVER (ORDER BY p.PARENT_ACTIVITY_ID ASC)) as seq, CONVERT(nvarchar,' |') as prefix,p.* from Project.TT_ACTIVITY p where p.PARENT_ACTIVITY_ID is