易截截图软件、单文件、免安装、纯绿色、仅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


相关文档:

Java设计模式之:Iterator链表模式

先来了解一下链表模式的原理:
首先写一个JavaBean,内容是要添加的元素和该元素的节点。
public class NodeBean implements Serializable
{
   
    private Object data; //元素本身
    private NodeBean next; //下一个节点
   
  &n ......

Oracle job 管理

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 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 ......

android java编程注意事项

1、创建了一个对象后:
(1)没有在适当的地方释放掉
(2)在应该释放的地方没有做释放操作
例如:下面一段程序:
   m_progressDlg = ProgressDialog.show(this, getString(R.string.market),getString(R.string.is_visiting), true);
   new Thread() {
    public v ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号