摘要： Ref:http://blog.csdn.net/yhmhappy2006/article/details/5552574一 概念 游标是SQL的一个内存工作区，由系统或用户以变量的形式定义。游标的作用就是用于临时存储从数据库中提取的数据块。在某些情况下，需要把数据从存放在磁盘的表中调到计算机内存中进行处理，最后将处理结果显示出来或最终写回数据库。这样数据处理的速度才会提高，否则频繁的磁盘数据交换会降低效率。 二 类型 Cursor类型包含三种: 隐式Cursor，显式Cursor和Ref Cursor（动态Cursor）。 1． 隐式Cursor: 1).对于Select …INTO…语句. 阅读全文

摘要： -- create objectscreate or replace type obj_type1 as object ( c1 int, c2 int);/create or replace type obj_tbl_type1 as table of obj_type1;/+++++++++++++++++++++++++++++++++++++++++create or replace function func1return obj_tbl_type1pipelinedis v_obj obj_type1;begin for idx in 1 .. 100 loop v_obj := 阅读全文

摘要： Ref:http://www.adp-gmbh.ch/ora/sql/table_cast.htmlcreate or replace type date_obj as object (dt date)/create or replace type date_table as table of date_obj/create or replace function date_range(from_dt in date, to_dt in date) return date_table as a_date_table date_table := date_table(); cur... 阅读全文

摘要： //deletedelete from table1 a where exists (select 1 from table2 b where a.col1 = b.col1)//insertinsert into table1 ( col1, col2)select 'a', 'b' from dualwhere not exists (select 1 from table2 where index = ?)//updateupdate /*+ bypass_ujvc */ (select col1 from table1 a, table2b where 阅读全文

摘要： /* Formatted on 2012-02-07 오후 4:51:00 (QP5 v5.149.1003.31008) */SELECT * FROM ( SELECT a.lot_id, a.shift_start_timekey, a.event_name, a.old_oper_code, a.oper_code, '-', LAG (old_oper_code, 2) OVER (ORDER BY lot_id, event_timekey) PREVIOUS_2, LAG (old_oper_code, 1) OVER (ORDER BY lot_id, even 阅读全文

摘要： select * from v$nls_parameters 阅读全文

摘要： Public Sub AllInternalPasswords()' Breaks worksheet and workbook structure passwords. Bob McCormick' probably originator of base code algorithm modified for coverage' of workbook structure / windows passwords and for multiple passwords'' Norman Harker and JE McGimpsey 27-Dec-2002 阅读全文

摘要： Ref.http://paranimage.com/15-web-based-html-editor/-End- 阅读全文

摘要： 查看用户select * from dba_users 查看用户表select * from user_tables查看字段select *fromuser_tab_columns/* Formatted on 2012-01-20 오전 10:32:56 (QP5 v5.149.1003.3100... 阅读全文

摘要： From iGoogle메일은 누구나 쓸 수 있지만, 격식을 잘 갖춰 쓰는 것이 중요합니다.특히 영문 메일은 더더욱 그렇죠. 영문 메일은 3가지로 구성되어 있죠.형식은 간단합니다.1. 인사말2. 본문3. 꼬릿말거두 절미하고 본문만 쓰면 매우 실례가 되니깐 메일 쓸 때 인사말, 꼬릿말을 까먹지 말아주세요.그럼 인사말부터 알아봅시다.1. 인사말우리가 배운 영어에는 Hello, Hi, Good Morning, Good Afternoon, Good Night, How are you, How do you do 등 많지만, 외국 엔지니어들은 거 阅读全文