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

win7ÏÂÈçºÎ°²×°oracle 11g - Oracle / ·Ç¼¼ÊõÇø

win7ÏÂÈçºÎ°²×°oracle 11g
ÍøÉÏËѰɣ¡Ó¦¸Ã²î²»¶à°¡


http://www.itpub.net/thread-1264048-1-1.html

Ö±½Ó°²×°¡£Ã»Óö¼ûÀ§ÄÑ¡£



Ö±½Ó°²×°....

ÎÒÒ²ÓÐÕâ¸öÎÊÌ⣬¿´¿´ÈçºÎ½â¾ö£¬ÉÏÍøËÑË÷ºÃÁË


Ïà¹ØÎÊ´ð£º

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......

oracle ÈÕÆÚ - Oracle / »ù´¡ºÍ¹ÜÀí

дPL/SQL·¢ÏÖ,
  DBMS_OUTPUT.PUT_LINE(to_date('2010/05/19','yyyy/MM/dd'));
ºǫ́Êä³ö»¹ÊÇ10-05-19
ÎÞÂÛ¸ñʽÔõô¸Ä¶¼ÊÇÕâÑùÊäÈë,²»Ã÷°×°¡!!!
ÓÃDevoloperÀ´¿ª·¢µÄ..
dbms_output.put_line()ÀïÃæµÄ²ÎÊýÊ ......

ÓÃibatisµ÷ÓÃoracleº¯ÊýµÄÎÊÌâ - Java / Web ¿ª·¢

oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
  p_mobileNumber in VARCHAR2,
  p_cityid out NUMBER
) Return NUMBER
IS
  p_areacode varc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ