<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[相信.总会存在的]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/windowluffy</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; windowluffy]]></copyright><item><title><![CDATA[D]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17306111</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17306111</guid><author>windowluffy</author><pubDate>Fri, 13 Dec 2013 18:04:49 +0800</pubDate><description><![CDATA[select * from emp]]></description><category></category></item><item><title><![CDATA[hibernate处理批量更新和批量删除]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17251011</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17251011</guid><author>windowluffy</author><pubDate>Tue, 10 Dec 2013 21:18:24 +0800</pubDate><description><![CDATA[9.4 批量处理数据

通常，在一个Session对象的缓存中只存放数量有限的持久化对象，等到Session对象处理事务完毕，还要关闭Session对象，从而及时释放Session的缓存占用的内存。
批量处理数据是指在一个事务中处理大量数据。以下程序在一个事务中批量更新CUSTOMERS表中年龄大于零的所有记录的AGE字段：
Transaction tx = session.beginTr]]></description><category></category></item><item><title><![CDATA[JPA 常用操作 与 Hibernate 的区别]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17248101</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17248101</guid><author>windowluffy</author><pubDate>Tue, 10 Dec 2013 18:04:12 +0800</pubDate><description><![CDATA[前提:
//创建实体管理器工厂   === 相当于 sessionFactory
EntityManagerFactory emf = Persistence.createEntityManagerFactory("jpa");
//创建实体管理器 === 相当于session
EntityManager em = emf.createEntityManager();
//通过实体管理器获得事务]]></description><category></category></item><item><title><![CDATA[JPA 持久化规范----简单应用]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17246393</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17246393</guid><author>windowluffy</author><pubDate>Tue, 10 Dec 2013 16:42:20 +0800</pubDate><description><![CDATA[结构~~~~~~~~~       
      


/**
 * 客户类
 * @author Administrator
 *
 */
@Entity
public class Customer {

	@Id
	//指定主键生成策略(MSSQL,MYSQL --- identity,  Oracle --- sequence)
	@GeneratedValue(strategy=G]]></description><category></category></item><item><title><![CDATA[oracle 中start with 的用法]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17241695</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17241695</guid><author>windowluffy</author><pubDate>Tue, 10 Dec 2013 12:26:22 +0800</pubDate><description><![CDATA[基本用法~~~~~~~~~~~~~~~~~~~~~~
SELECT * FROM tree

-- where 子句 , 若有,只是过滤最终结果的作用

START WITH father = '爷爷'    -- 从 father 为 '爷爷' 的 那一条记录开始

-- 若有 nocyle 关键字, 则不走环, 仅列出所有映射
CONNECT BY [NOCYCLE] PRIOR son =]]></description><category></category></item><item><title><![CDATA[Oracle With 子句]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17238741</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17238741</guid><author>windowluffy</author><pubDate>Tue, 10 Dec 2013 08:51:10 +0800</pubDate><description><![CDATA[以例子学习with：
with
--查询部门和部门的总薪水
  dept_costs as (
                 select d.department_name,sum(e.salary) dept_total
                   from departments d,employees e
                  where d.departme]]></description><category></category></item><item><title><![CDATA[Java 文本上传]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17232915</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17232915</guid><author>windowluffy</author><pubDate>Mon, 09 Dec 2013 23:57:05 +0800</pubDate><description><![CDATA[public class TextServer {

	public static void main(String[] args) throws Exception{
		
		ServerSocket serverSocket = new ServerSocket(10005);
		
		Socket socket = serverSocket.accept();
		
		// socke]]></description><category></category></item><item><title><![CDATA[Java 网络编程注意事项]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17231993</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17231993</guid><author>windowluffy</author><pubDate>Mon, 09 Dec 2013 23:02:34 +0800</pubDate><description><![CDATA[1.结束
//结束标记
bufOut.newLine();
//缓冲刷出
bufOut.flush();

//关闭输出,另外一端不在继续读
socket.shutdownOutput();]]></description><category></category></item><item><title><![CDATA[DBMS_WARNING]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17198607</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17198607</guid><author>windowluffy</author><pubDate>Sun, 08 Dec 2013 09:53:30 +0800</pubDate><description><![CDATA[create procedure compile(pkg_name varchar2) is
       warn_value varchar2(200);
       compile_stmt varchar2(200) :=
           'alter package '|| pkg_name ||' compile';
begin
  warn_value :=  ---- 保存]]></description><category></category></item><item><title><![CDATA[触发器]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17198263</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17198263</guid><author>windowluffy</author><pubDate>Sun, 08 Dec 2013 08:57:36 +0800</pubDate><description><![CDATA[ORACLE PL/SQL编程之八： 

把触发器说透 

 

大家一定要评论呀，感谢！光发表就花了我将近一个下午。

本篇主要内容如下：

8.1 触发器类型

8.1.1 DML触发器

8.1.2 替代触发器

8.1.3 系统触发器

8.2 创建触发器

8.2.1 触发器触发次序

8.2.2 创建DML触发器

8.2.3 创建替代(]]></description><category></category></item><item><title><![CDATA[创建 Directory 对象]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17188709</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17188709</guid><author>windowluffy</author><pubDate>Sat, 07 Dec 2013 16:09:40 +0800</pubDate><description><![CDATA[1.在操作系统下创建目录
mkdir /temp/data_files


2.创建directory对象
create directory data_files as '/temp/data_files';


3.对directory对象授权
grant read on directory data_files to scott,manager_role,public;]]></description><category></category></item><item><title><![CDATA[Bulk Binding]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17184899</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17184899</guid><author>windowluffy</author><pubDate>Sat, 07 Dec 2013 10:42:35 +0800</pubDate><description><![CDATA[● Bulk Binding FORALL
: Example

create or replace procedure raise_salary(precent number) is
       type numlist is table of number
       index by binary_integer;
       id numlist;
begin
  id(1):]]></description><category></category></item><item><title><![CDATA[Returning Clause(子句)]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17184753</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17184753</guid><author>windowluffy</author><pubDate>Sat, 07 Dec 2013 09:49:08 +0800</pubDate><description><![CDATA[create or replace procedure update_salary(emp_id number) is
name employees.last_name%type;
new_salary employees.salary%type;
begin
  update employees
  set salary=salary*1.1
  where employee_id=emp_id]]></description><category></category></item><item><title><![CDATA[DBMS_SQL 包 ( 8i 后 建议用 Native Dynamic SQL 代替)]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17171819</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17171819</guid><author>windowluffy</author><pubDate>Fri, 06 Dec 2013 19:46:22 +0800</pubDate><description><![CDATA[Using DBMS_SQL 
with a Parameterized DML Statement
create procedure insert_row(table_name varchar2,
       id varchar2,name varchar2,region number) is
    csr_id integer;
    stmt   varchar2(200);]]></description><category></category></item><item><title><![CDATA[Native Dynamic SQL]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17160911</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17160911</guid><author>windowluffy</author><pubDate>Fri, 06 Dec 2013 09:18:33 +0800</pubDate><description><![CDATA[1.Dynamic SQL with DML Statements
●Deleting rows from any table:

create function del_rows(table_name varchar2)
return number is
begin
  execute immediate 'delete from '||table_name;
  return sql%r]]></description><category></category></item><item><title><![CDATA[Job 管理]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17151071</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17151071</guid><author>windowluffy</author><pubDate>Thu, 05 Dec 2013 22:52:12 +0800</pubDate><description><![CDATA[begin
  dbms_scheduler.create_job(
        job_name => 'test_job',
        job_type => 'plsql_block',
                 -- 指定job_action 中的执行内容
                 -- 1.plsql_block      ------- plsql块]]></description><category></category></item><item><title><![CDATA[【希尔】排序------ T(n) = O(n^1.5),S(n) = O(1) ---- 不稳定]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17137507</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17137507</guid><author>windowluffy</author><pubDate>Thu, 05 Dec 2013 10:37:47 +0800</pubDate><description><![CDATA[public static void doSort(RS[] arrRS,int n_arrRS,int[] arrDelta,int n_arrDelta) {
		//每个delta增量,都进行一次【希尔插入】
		//当delta增量为【1】时,【希尔插入】即等同【直接插入排序】
		for(int i=0; i<n_arrDelta; ++i){
			shellInsert(arrRS,]]></description><category></category></item><item><title><![CDATA[【快速】排序, T(n) = O(nlgn),O(n^2)   S(n) = O(lgn)   ---  不稳定]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17136389</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17136389</guid><author>windowluffy</author><pubDate>Thu, 05 Dec 2013 09:33:21 +0800</pubDate><description><![CDATA[public static void quickSort(RS[] arrRS,int low,int high){
		
		// 保存【分割点】
		int partition;
		
		// 【段长】大于1
		if(low < high){
			
			// 一次分割,获得【分割点】 和  两个【子段】
			partition = quickPartition(arrRS,low,h]]></description><category></category></item><item><title><![CDATA[解决oracle11g ORA-00119 ORA-00132方法 invalid specification for system parameter LOCAL_LISTENER]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17131729</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17131729</guid><author>windowluffy</author><pubDate>Thu, 05 Dec 2013 00:39:37 +0800</pubDate><description><![CDATA[在linux下启动oracle11g是报如下错误：




ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00130: invalid listener address XIANGDE_LISTENER




在网上也有很多人遇到这种问题，大家的解决方法基本都是一致的，但]]></description><category></category></item><item><title><![CDATA[Oracle 只安装 服务端, 使用 PL/SQL developer]]></title><link>https://blog.youkuaiyun.com/windowluffy/article/details/17127025</link><guid>https://blog.youkuaiyun.com/windowluffy/article/details/17127025</guid><author>windowluffy</author><pubDate>Wed, 04 Dec 2013 21:59:21 +0800</pubDate><description><![CDATA[1. 到官网弄个 instantclient ,随便解压到一个目录下面


2.pl/sql derveloper 首选项




3.配置 TNS_ADMIN 环境变量 ,要求指向 tnsnames.ora]]></description><category></category></item></channel></rss>