易截截图软件、单文件、免安装、纯绿色、仅160KB

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


相关文档:

oracle死锁查询及处理

查询发生死锁的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))
---------------------------------------------------------
关于数据库死锁的检查方法
一、        ......

Oracle 游标的使用与管理

1、查看ORACLE最大游标数
C:\Documents and Settings\Administrator>sqlplus "sys/admin@test151 as sysdba"     (sys以dba登录test151服务)
SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 11月 5 09:08:04 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights ......

oracle lob 简单介绍

何为LOB?
lob为oracle数据库的一个大对象数据类型,可以存储超过4000bytes的字符串,二进制数据,OS文件等大对象信息.最大可存储的容量根oracle的版本和oracle 块大小有关.
有那几种可供选择的LOB类型?
目前ORACLE提供了CLOB,NCLOB,BLOB,BFILE共四种LOB类型,CLOB,NLOB为大字符串类型,NLOB为多语言集字符类型,类似于NV ......

Oracle 10g 启动与关闭

在执行启动关闭命令之前需要正确设置下列环境变量:
    ORACLE_BASE
    ORACLE_HOME 安装过程中显示的oracle home 目录
    ORACLE_SID
    PATH=$PAHT:$ORACLE_HOME/bin
    以 oracle 账号登陆 Linux,或者从 root 下输入 su - or ......

ORACLE 10g下载地址

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号