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

Îʼ¸¸ö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¹Ù·½Îĵµ£¬½²µÄºÜ»ù´¡


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

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

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

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

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

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

ÓÃ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ºÅ