win7ÏÂÈçºÎ°²×°oracle 11g - Oracle / ·Ç¼¼ÊõÇø
win7ÏÂÈçºÎ°²×°oracle 11g
ÍøÉÏËѰɣ¡Ó¦¸Ã²î²»¶à°¡
http://www.itpub.net/thread-1264048-1-1.html
Ö±½Ó°²×°¡£Ã»Óö¼ûÀ§ÄÑ¡£
Ö±½Ó°²×°....
ÎÒÒ²ÓÐÕâ¸öÎÊÌ⣬¿´¿´ÈçºÎ½â¾ö£¬ÉÏÍøËÑË÷ºÃÁË
Ïà¹ØÎÊ´ð£º
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
дPL/SQL·¢ÏÖ,
DBMS_OUTPUT.PUT_LINE(to_date('2010/05/19','yyyy/MM/dd'));
ºǫ́Êä³ö»¹ÊÇ10-05-19
ÎÞÂÛ¸ñʽÔõô¸Ä¶¼ÊÇÕâÑùÊäÈë,²»Ã÷°×°¡!!!
ÓÃDevoloperÀ´¿ª·¢µÄ..
dbms_output.put_line()ÀïÃæµÄ²ÎÊýÊ ......
oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
p_mobileNumber in VARCHAR2,
p_cityid out NUMBER
) Return NUMBER
IS
p_areacode varc ......