Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle ´æ´¢¹ý³Ì·µ»Ø½á¹û¼¯ÓÃ

Oracle ´æ´¢¹ý³Ì·µ»Ø½á¹û¼¯Óà ref cursor ʵÏÖ¡£ÊÔÑé²½ÖèÈçÏ£º
1. ½¨Á¢ ref cursor ÀàÐͺ͹ý³Ì
CREATE OR REPLACE PACKAGE types
AS
    TYPE ref_cursor IS REF CURSOR;
END;
/
CREATE TABLE STOCK_PRICES(
    RIC VARCHAR(6) PRIMARY KEY,
    PRICE NUMBER(7,2),
    UPDATED DATE );
/
CREATE OR REPLACE FUNCTION sp_get_stocks(v_price IN NUMBER)
    RETURN types.ref_cursor
AS
    stock_cursor types.ref_cursor;
BEGIN
    OPEN stock_cursor FOR
    SELECT ric,price,updated from stock_prices WHERE price < v_price;
    RETURN stock_cursor;
END;
2. Óà sqlplus ²âÊÔ¹ý³Ì
SQL> var results refcursor
SQL> exec :results := sp_get_stocks(20.0)
SQL> print results
3. ´Ó Java µ÷ÓÃ
import java.sql.*;
import java.io.*;
import oracle.jdbc.driver.*;
public class JDBCDemo {
    /**
    * Compile-time flag for deciding which query to use
    */
    private boolean useOracleQuery = true;
    /**
    * Class name of Oracle JDBC driver
    */
    private String driver = "oracle.jdbc.driver.OracleDriver";
    /**
    * Initial url fragment
    */
    private String url = "jdbc:oracle:thin:@";
    /**
    * Standard Oracle listener port
    */
    private String port = "1521";
    /**
    * Oracle style of calling a stored procedure
    */
    private String oracleQuery = "begin ? := sp_get_stocks(?); end;";
    /**
    * JDBC style of calling a stored procedure
    */
    private String genericQuery = "{ call ? := sp_get_stocks(?) }";
    /**


Ïà¹ØÎĵµ£º

oracle´Ó9.2.0.1Éý¼¶µ½9.2.0.8²½Öè

 ±³¾°£ºÔÚwindows 2003 serverÉϰ²×°ÁËOracle 9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©
  (1)µ½metalinkÏÂÔØÉý¼¶Ñ¹Ëõ°ü£¬patchºÅΪ4547809£¬Ñ¹Ëõ°üÃû³ÆÎª p4547809_92080_WINNT.zip£¬for windows 32bit¡£
  (2)½âѹËõzip£¬Ï±߰üº¬Ò»¸öDisk1ºÍreadme.htmlÎļþ¡£ ......

Oracle С֪ʶ ×ܽá(Ò»)


Oracle ÊÇÒ»¸öÅÓ´óµÄϵͳ£¬ÀïÃæµÄ֪ʶµãºÜ¶à£¬ÔÚѧϰµÄʱºò£¬¿´µ½Ò»Ð©ÖªÊ¶µã£¬¾ÍÌùÁËÏÂÀ´£¬¾¡²»ÖªÖÐÌùÁËÕâô¶à£¬¾ÍÏÈ×ö¸öС½á°É¡£ ÀïÃæÓеÄ֪ʶµãÒѾ­µ¥¶ÀÄóöÀ´Ð´³Éµ¥ÆªµÄblog(http://blog.csdn.net/tianlesoftware)ÁË¡£ÓеĻ¹Ã»ÓнøÐÐÕûÀí¡£ ºÃ¼ÇÐÔ²»ÈçÀñÊÍ·£¬²»¹ýÎÒÓõIJ»ÊDZʡ£ ^_^   ......

Oracle²ÎÊýµ÷ÓÅ

1)ÔÚdelphiÖÐ,¾­³£ÓÐÈËдSQL²¢´«Èëµ½Êý¾Ý¿âÖÐÖ´ÐÐ,Ò»°ã¶¼ÊǰÑsqlÆ´³öÀ´,ÈçÏÂ:
sSql := 'select * from ContainerStateH where container like '+QuotedStr('%'+trim(Edit2.Text)+'%') +' order by BeginDay';
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add(sSql);
ADOQuery1.Open;
µ«ÊÇ´ÓoracleÊý¾Ý¿â½Ç¶È¿¼Â ......

ORACLE ERP¿ª·¢»ù´¡Ö®Ç°ÑÔ


ORACLE ERP¿ª·¢»ù´¡Ö®Ç°ÑÔ
 
 
¡¡¡¡
¡¡¡¡Ç°ÑÔ
¡¡¡¡Å¼ÊÇ2008Äê²Å¿ªÊ¼½Ó´¥£¬Õâ¸ö´«ËµÖеÄOracle ERP¡£¶øÔÚ´ËǰËÄÄê¼ä£¬ÌرðÊÇÔÚ×öJAVA³ÌÐòÔ±¶þÄê¶àµÄʱ¼äÖУ¬Ñø³ÉÁËÒ»ÖֶԼܹ¹¡¢Ä£Ê½¡¢ÃæÏò¶ÔÏóµÄ¿ñÈÈ×·Ç󣬵¼Ö¶ÔEBSÒೣʧÍû¡£ÒòΪEBS11iûÓÐÈí¼þģʽ¡¢Éè¼Æ¡¢·Ö²ãµÈ£¬Ö»ÓÐÏóÃæÌõ°ãµÄPL/SQLÓï¾ä¡£
¡¡¡¡EBSÈë ......

oracle issue

Yes, sure ! You must be the local admin of this computer, and not a domain user.
Moreover, I'm afraid you cannot install it in a domain, maybe you should (just for testing purposes) try to install a standalone Windows system and try installing Oracle 10g on it.
You know, a RDBMS database server mu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ