Îʼ¸¸öORACLEµÄ»ù´¡ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒûÓÐÓùýoracle,Ö»Óùýsql server2000¡£ÎÒÔÚ¹ÙÍøÏÂÁËÒ»¸ö11windows°æµÄ¡£
oracleÒ²ÊÇ·ÖΪ¿â£¬¿âÏÂÃæÊDZíÂð£¿ÎÒÔõô²é¿´¿âºÍ±í°¡£¿
ÎҵĿªÊ¼²Ëµ¥Àï¿´µ½
database control-orcl
Ó¦ÓóÌÐò¿ª·¢
ÅäÖúÍÒÆÖ²¹¤¾ß
¹ÜÀí¼¯³É¹¤¾ß
warehouse builder
ËüÃÇÊǸÉʲôÓõģ¿
Database --> Instance --> Schema(User) --> Tables
數據庫 實Àý ·½°¸(ÓÃ戶) ±íµÈ數據庫對Ïó
Oracle ½ÐʵÀýÁË£¬ÊµÀýÏÂÃæÓÐ±í£¬Ë÷ÒýµÈ¡£
OracleµÄ¹ÜÀí½çÃæ½ÐOEM£¬Í¨¹ýÍøÒ³ÐÎʽ£ºhttp://localhost:1158/em
Ò²¿ÉÒÔÓÃToad£¬plsq developer¡£ Õâ2¸öµÚÈý·½µÄ¹¤¾ßÒ²¿ÉÒÔºÜÖ±½ÓµÄ¿´µ½Ïà¹ØÐÅÏ¢¡£
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977
database control-orcl ÊÇ´ò開OracleÆó業¹ÜÀíÆ÷µÄ連½Ó
Ó¦ÓóÌÐò¿ª·¢ °üÀ¨Oracle³£ÓõÄ數據庫開發µÄ³ÌÐò£¬Èçsqlplus
³õ學從sqlplus開ʼ°É
cmd -- dbca ´´½¨Êý¾Ý¿âʵÀý
oracleûÓÐÊý¾Ý¿â¸ÅÄÔÚÕâÀï½ÐÊý¾Ý¿âʵÀý
²»¶®....·¹ý
ѧϰÁË
½¨Òélz¿ÉÒÔ¿´¿´Oracle Concepts¹Ù·½Îĵµ£¬½²µÄºÜ»ù´¡
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
p_mobileNumber in VARCHAR2,
p_cityid out NUMBER
) Return NUMBER
IS
p_areacode varc ......