<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Think的专栏]]></title><description><![CDATA[技术是服务的根本]]></description><link>https://blog.csdn.net/billhost</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; billhost]]></copyright><item><title><![CDATA[oracle行列字符串]]></title><link>https://blog.csdn.net/billhost/article/details/5595244</link><guid>https://blog.csdn.net/billhost/article/details/5595244</guid><author>billhost</author><pubDate>Sat, 15 May 2010 15:13:00 +0800</pubDate><description><![CDATA[SELECT T.USER_NO,       T.USER_NAME,       MAX(SUBSTR(SYS_CONNECT_BY_PATH(T.ROLE_NAME, /), 2))  FROM (SELECT T.USER_NO,               T.USER_NAME,               T.ROLE_NAME,               T.USER_NO ]]></description><category></category></item><item><title><![CDATA[oracle不同schema之间建外键]]></title><link>https://blog.csdn.net/billhost/article/details/5555018</link><guid>https://blog.csdn.net/billhost/article/details/5555018</guid><author>billhost</author><pubDate>Tue, 04 May 2010 11:19:00 +0800</pubDate><description><![CDATA[需要权限:  grant references on test_sys to user_1; or   grant all on test_sys to user_1; 测试：sys用户下:SQL> create user user_1 identified by user_1;用户已创建。SQL> grant dba to user_1;授权成功。SQ]]></description><category></category></item><item><title><![CDATA[oracle实现绑定in字符串]]></title><link>https://blog.csdn.net/billhost/article/details/5530801</link><guid>https://blog.csdn.net/billhost/article/details/5530801</guid><author>billhost</author><pubDate>Mon, 26 Apr 2010 17:26:00 +0800</pubDate><description><![CDATA[1.建立存放字符串的数组类型   create or replace type Type_bind as table OF VARCHAR2(4000)  2.建立将字符串转成数组然后返回给Type_bind函数。  CREATE OR REPLACE FUNCTION F_PUB_BIND_IN(p_bind IN VARCHAR2)  RETURN TYPE_BIND AS/*]]></description><category></category></item><item><title><![CDATA[oracle job号使用]]></title><link>https://blog.csdn.net/billhost/article/details/5518501</link><guid>https://blog.csdn.net/billhost/article/details/5518501</guid><author>billhost</author><pubDate>Fri, 23 Apr 2010 09:44:00 +0800</pubDate><description><![CDATA[当用submit建JOB时，JOBID由系统自带SEQUENCE：sys.JOBSEQ生成。 如果一段时间后JOBID过大，可以DROP SEQUENCE sys.JOBSEQ;再重建create sequence JOBSEQminvalue 1maxvalue 999999999999start with 1increment by 1cache 20;来重新开始JOBID。可]]></description><category></category></item><item><title><![CDATA[oracle 用户管理]]></title><link>https://blog.csdn.net/billhost/article/details/5518432</link><guid>https://blog.csdn.net/billhost/article/details/5518432</guid><author>billhost</author><pubDate>Fri, 23 Apr 2010 09:30:00 +0800</pubDate><description><![CDATA[系统权限： 回收时不会产生级联回收conn / as sysdba;create user t1 identified by t1;create user t2 identified by t2;grant connect to t1,t2;grant create table, create view to t1 with admin option;conn t1/t1grant creat]]></description><category></category></item><item><title><![CDATA[恢复与备份部分技术]]></title><link>https://blog.csdn.net/billhost/article/details/4506454</link><guid>https://blog.csdn.net/billhost/article/details/4506454</guid><author>billhost</author><pubDate>Tue, 01 Sep 2009 11:26:00 +0800</pubDate><description><![CDATA[ 一.完全数据库恢复1.修改数据库为归档模式  2.改完以后，进行完全数据库备份（这备份必须是修改归档模式后的备份，否则恢复不了。）.３.生成数据库的日常行为（如往某张表插入数据)，然后强制归档（alter system switch logfile)，因为恢复至少需要一个归档文件。　　４.删除一个数据文件，破坏数据库　　查看需要恢复的文件:select *from  v$recover_]]></description><category></category></item><item><title><![CDATA[imp 与exp部分例子]]></title><link>https://blog.csdn.net/billhost/article/details/4506357</link><guid>https://blog.csdn.net/billhost/article/details/4506357</guid><author>billhost</author><pubDate>Tue, 01 Sep 2009 11:12:00 +0800</pubDate><description><![CDATA[导入时,对象如果存在,可以指定ignore=y忽略错误 1.导出与导入全库   a.exp  #export the entire databaseuserid="sys/doone@practice as sysdba"file=dmp/full_1.dmplog=log/full.logfull=yrows=ybuffer=10000compress=nRECORD=y#增量导出(]]></description><category></category></item><item><title><![CDATA[服务器上包含多个库时，listener.ora和tnsnames.ora的配置]]></title><link>https://blog.csdn.net/billhost/article/details/4374251</link><guid>https://blog.csdn.net/billhost/article/details/4374251</guid><author>billhost</author><pubDate>Thu, 23 Jul 2009 16:14:00 +0800</pubDate><description><![CDATA[１.配置内容：1).listener.oraSID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = D:/oracle/product/10.1.0/Db_1)      (PROGRAM = extproc)    )    (SID_DESC =  ]]></description><category></category></item><item><title><![CDATA[oracle utl_file包的使用]]></title><link>https://blog.csdn.net/billhost/article/details/4312275</link><guid>https://blog.csdn.net/billhost/article/details/4312275</guid><author>billhost</author><pubDate>Wed, 01 Jul 2009 10:57:00 +0800</pubDate><description><![CDATA[ I.设置路径utl_file_dir   第一步：以管理员用户登陆      如：conn    sys/password@sid    as    sysdba     第二步：设置可操作目录      需要指定utl_file包可以操作的目录。在oracle    10g以前，可以用以下方法：      1、alter    system    set    utl_file_dir=]]></description><category></category></item><item><title><![CDATA[批处理动态sql]]></title><link>https://blog.csdn.net/billhost/article/details/4297010</link><guid>https://blog.csdn.net/billhost/article/details/4297010</guid><author>billhost</author><pubDate>Thu, 25 Jun 2009 11:38:00 +0800</pubDate><description><![CDATA[１.－－－－－－－－DECLARE  TYPE ref_cursor_type IS ref CURSOR;  v_mycursor ref_cursor_type;  TYPE id_list IS TABLE OF integer;  TYPE name_list IS TABLE OF varchar2(30);    v_tabid id_list:=id_list();  v_tab]]></description><category></category></item><item><title><![CDATA[如何从优秀的程序员成为伟大的程序员【转】]]></title><link>https://blog.csdn.net/billhost/article/details/4281343</link><guid>https://blog.csdn.net/billhost/article/details/4281343</guid><author>billhost</author><pubDate>Thu, 18 Jun 2009 22:29:00 +0800</pubDate><description><![CDATA[本文给出了十五个评定软件开发人员的标准，可以帮助程序员朋友从一个好的程序员成为一个优秀的程序员，和大家共飨！ 怎样评定一名软件开发人员？这是一个颇为奇怪的问题。现在已经有了很多的理论和形式来做这件事，人力资源部门也试着帮你管理和反省自己的行为。然而，怎样才是一个伟大的软件开发人员，在今天，你该怎样发展你的职业生涯？以下是我评定团队中软件开发人员的“军规”。按照这些技巧和规则，你可以改善你的现状，由]]></description><category></category></item><item><title><![CDATA[数据库范式1NF 2NF 3NF BCNF(实例）]]></title><link>https://blog.csdn.net/billhost/article/details/4280655</link><guid>https://blog.csdn.net/billhost/article/details/4280655</guid><author>billhost</author><pubDate>Thu, 18 Jun 2009 17:56:00 +0800</pubDate><description><![CDATA[设计范式（范式,数据库设计范式,数据库的设计范式）是符合某一种级别的关系模式的集合。构造数据库必须遵循一定的规则。在关系数据库中，这种规则就是范式。关系数据库中的关系必须满足一定的要求，即满足不同的范式。目前关系数据库有六种范式：第一范式（1NF）、第二范式（2NF）、第三范式（3NF）、第四范式（4NF）、第五范式（5NF）和第六范式（6NF）。满足最低要求的范式是第一范式（1NF）。在第一范式]]></description><category></category></item><item><title><![CDATA[oracle 分析函数(增加中..希望大家帮忙收集)]]></title><link>https://blog.csdn.net/billhost/article/details/4272657</link><guid>https://blog.csdn.net/billhost/article/details/4272657</guid><author>billhost</author><pubDate>Tue, 16 Jun 2009 11:16:00 +0800</pubDate><description><![CDATA[ 1.取后邻近第几行(lead):如果无值,放空语法结构：     lead(value_expr [,offset][,default]) over([query_partition_clause] order by Order_by_clause)     参数说明：     value_expr 值表达式，通常是字段，也可是是表达式。value_expr本身不支持分析函数，也]]></description><category></category></item><item><title><![CDATA[oracle 集合]]></title><link>https://blog.csdn.net/billhost/article/details/4271138</link><guid>https://blog.csdn.net/billhost/article/details/4271138</guid><author>billhost</author><pubDate>Mon, 15 Jun 2009 18:04:00 +0800</pubDate><description><![CDATA[ 属性: I.表类型--1.索引组织表,存放在内存中的表.  DECLARE    TYPE t_indexTable IS TABLE OF emp%ROWTYPE NOT NULL INDEX BY BINARY_INTEGER;    v_indexTable t_indexTable;    CURSOR v_cur IS       SELECT * FROM emp; ]]></description><category></category></item><item><title><![CDATA[oracle 字符串转成行]]></title><link>https://blog.csdn.net/billhost/article/details/4251516</link><guid>https://blog.csdn.net/billhost/article/details/4251516</guid><author>billhost</author><pubDate>Mon, 08 Jun 2009 14:28:00 +0800</pubDate><description><![CDATA[ oracle 将以逗号隔开的字符串85,86,87 转成行 SELECT   SUBSTR (T.RPT_ID,                 INSTR (T.RPT_ID,,,1,C.LV)+ 1,                 INSTR (T.RPT_ID,,,1,C.LV + 1)- (INSTR (T.RPT_ID,,,1,C.LV)+ 1))      ]]></description><category></category></item><item><title><![CDATA[2.Start with]]></title><link>https://blog.csdn.net/billhost/article/details/4219988</link><guid>https://blog.csdn.net/billhost/article/details/4219988</guid><author>billhost</author><pubDate>Wed, 27 May 2009 12:10:00 +0800</pubDate><description><![CDATA[Start with...Connect By子句递归查询一般用于一个表维护树形结构的应用。创建示例表：CREATE TABLE TBL_TEST(  ID    NUMBER,  NAME  VARCHAR2(100 BYTE),  PID   NUMBER                                  DEFAULT 0); 插入测试数据：INSERT INTO TBL_T]]></description><category></category></item><item><title><![CDATA[1.with语句]]></title><link>https://blog.csdn.net/billhost/article/details/4219983</link><guid>https://blog.csdn.net/billhost/article/details/4219983</guid><author>billhost</author><pubDate>Wed, 27 May 2009 12:06:00 +0800</pubDate><description><![CDATA[ 语法就是 可以支持多个：with t1 as (...),t2 as (..)t3 as ..select ..例子： with t as (select * from emp where depno=10) select * from t where empno=xxx ]]></description><category></category></item><item><title><![CDATA[记录表的防问次数]]></title><link>https://blog.csdn.net/billhost/article/details/4219942</link><guid>https://blog.csdn.net/billhost/article/details/4219942</guid><author>billhost</author><pubDate>Wed, 27 May 2009 11:52:00 +0800</pubDate><description><![CDATA[SQL> show parameter audit;SQL> conn /as sysdbaSQL> show parameter audit;NAME                                 TYPE        VALUE------------------------------------ ----------- -----audit_sys_oper]]></description><category></category></item></channel></rss>