oracle 返回一个java对象，和返回多个java对象的方法
返回多个对象：
PROCEDURE AUTO_SEL_INVOICE_DETAIL(
P_RESULT_LIST OUT SYS_REFCURSOR) AS
BEGIN
OPEN P_RESULT_LIST FOR
SELECT DISTINCT CC.CHARGE_COLLECTION_ID CHARGE_COLLECTION_ID, CC.COLLECT_DATE COLLECT_DATE, CC.TOTAL_AMOUNT TOTAL_AMOUNT, CC.STATEMENT_NO STATEMENT_NO, CC.PORT_CODE PORT_CODE, CC.CUSTOMER_TYPE CUSTOMER_TYPE, CC.CUSTOMER_CODE CUSTOMER_CODE, CC.CUSTOMER_NAME CUSTOMER_NAME, CP.PAYER_TYPE PAYER_TYPE, CP.PAYER_CODE PAYER_CODE, CP.PAYER_NAME PAYER_NAME, CC.ROTATION_NO ROTATION_NO, CD.CHARGE_TYPE_ID CHARGE_TYPE_ID, CD.CHARGE_TYPE CHARGE_TYPE, CD.CARGO_CATEGORY_ID CARGO_CATEGORY_ID, CD.CARGO_CATEGORY CARGO_CATEGORY, CD.TARIFF_CODE_ID TARIFF_CODE_ID, TC.TARIFF_CODE TARIFF_CODE, CD.TARIFF_RATE_ID TARIFF_RATE_ID, CD.TARIFF_RATE TARIFF_RATE, TR.APPLY_TO UOM, CD.SHORT_CODE SHORT_CODE, CD.QUANTITY QUANTITY, CD.TARIFF_AMOUNT TARIFF_AMOUNT, CD.BRN_NO BRN_NO, CD.BOL_NO BOL_NO, CD.SRN_NO SRN_NO,
CD.TER_ID TER_ID, CD.TER_DETAIL_ID TER_DETAIL_ID, CD.TER_CODE TER_NO, CD.TER_RATE TER_RATE, CD.TER_AMOUNT TER_AMOUNT, CD.NET_AMOUNT NET_AMOUNT, CC.TERMINAL_ID TERMINAL_ID, BB.LINE_CODE LINE_CODE, CD.TRADE_CODE TRADE_CODE, TC.ACTIVITY_CODE OPER_EVENT, CD.BOE_NO BOE_NO, EB.DEST_PORT EX_DESC_PORT, BOL.DEST_PORT IM_DEST_PORT, BOL.ORIGIN_PORT ORIGIN_PORT, EB.DISCHG_PORT_1 DISCHG_PORT_1, BOL.COM_CODE COM_CODE, CC.CREATED_BY CREATED_BY, CC.CREATED_DATE CREATED_DATE
from GCB_CHARGE_COLLECTION CC INNER JOIN GCB_CHARGE_DTLS CD ON CC.CHARGE_COLLECTION_ID = CD.CHARGE_COLLECTION_ID INNER JOIN GCB_TARIFF_CODE TC ON CD.TARIFF_CODE_ID = TC.TARIFF_CODE_ID INNER JOIN GCB_TARIFF_RATE TR ON CD.TARIFF_RATE_ID = TR.TARIFF_RATE_ID LEFT JOIN GCB_CHARGE_PAYMENT CP ON CC.CHARGE_COLLECTION_ID = CP.CHARGE_COLLECTION_ID LEFT JOIN BERTH_BOOKING BB ON CC.ROTATION_NO = BB.ROTATION
相关文档：
SVRMGR> select * from dba_jobs;
初始化相关参数job_queue_processes
alter system set job_queue_processes=39 scope=spfile;//最大值不能超过1000 ;job_queue_interval = 10 //调度作业刷新频率秒为单位
DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the c ......
Oracle中临时表产生过量Redo的说明
最近,在Oracle9i中你用过临时表吗?
它是否给你带来了性能提高?你注意过么?
--------------------------------------------------------------------------------
好了言归正传.
我们知道临时表在DML操作中可以减少redo的生成,从而在保存中间结果集时可以带来较大的性能提高.
可是,� ......
查询发生死锁的select语句
select sql_text from v$sql where hash_value in
(select sql_hash_value from v$session where sid in
(select session_id from v$locked_object))
---------------------------------------------------------
关于数据库死锁的检查方法
一、 ......
检测锁：
SELECT A.OWNER,
A.OBJECT_NAME,
B.XIDUSN,
B.XIDSLOT,
B.XIDSQN,
B.SESSION_ID,
B.ORACLE_USERNAME,
B.OS_USER_NAME,
B.PROCESS,
B.LOCKED_MODE,
C.MACHINE,
C.STATUS,
C.SERVER,
C.SID,
C.SERIAL#,
C.PROGRAM
from ALL_OBJECTS A,
V$LOCKED_OBJECT B,
SYS.GV_$SESSION C
WHERE ( A.OBJE ......
触发器是指存放在数据库中，并被隐藏执行的存储过程。在Oracle8i之前，只允许基于表或视图的DML操作(insert,update,delete)建立触发器，在oracle8i之后，不仅支持DML操作，也允许基于系统事件(启动数据库，关闭数据库，登录)和DDL操作建立触发器。
一、触发器简介
触发器是指隐含执行的存储过程，它可以使 ......
