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

Oracle ±Ê¼Ç


          µÚ1Ò³
 
1. Oracle µÄʹÓÃ
1.1. SQLPLUS µÄÃüÁî
³õʼ»¯±íµÄλÖãº
set
NLS_LANG=american_america.us7ascii  (ÉèÖñàÂë²Å¿ÉÒÔʹÓÃÏÂÃæ½Å±¾)
cd
$ORACLE_HOME/rdbms   cd demo     summit2.sql
*********************************
ÎÒÃÇĿǰʹÓõÄÊÇoralce 9i  
9201 °æ±¾
select * from
v$version;
 
»Ö¸´Á·Ï°±íÃüÁ
sqlplus  **/** @summit2.sql   //shellÒªÔÚÕâ¸öÎļþµÄλÖá£
 
 
µÇ½ oracleµÄÃüÁ
sqlplus   Óû§Ãû/ÃÜÂë
 
show   user        
ÏÔʾµ±Ç°µÇ½µÄÉí·Ý.
set    pause on
set    pause off  
·ÖÒ³ÏÔʾ.
 
oracle ÖÐĬÈÏÈÕÆÚºÍ×Ö·ûÊÇ×ó¶ÔÆë£¬Êý×ÖÊÇÓÒ¶ÔÆë
table or view
does  not 
exist ; ±í»òʾͼ²»´æÔÚ
 
edit ÃüÁîÓÃÓÚ×Ô¶¯´ò¿ªvi Ð޸ĸÕÐÞÖ´ÐйýµÄ sql µÄÃüÁî¡£
Ð޸ķ½·¨¶þ£º
l  3 Ïȶ¨Î»µ½ÐР   c   /¾É´®/д®
 
Ö´Ðгö´íʱ£¬ÀûÓôíÎóºÅÀ´²é´íÎó:
!oerr ora
942    (×°Íêϵͳºó»á×°Ò»¸ö oerr ¹¤¾ß£¬ÓÃÓÚͨ¹ý´íÎóºÅÀ´²é¿´´íÎóµÄ¾ß
ÌåÐÅÏ¢)
 
ÏëÔÚ sql ÖÐÖ´ÐÐ
unix ÃüÁîʱ£¬°ÑËùÓеÄÃüÁîǰ¼ÓÒ»¸ö!¾Í¿ÉÒÔ£¬  »òÕß
host( ÓÃÓÚ
´Ó sql ´ÓÇл»ÖÁunix»·¾³ÖÐÈ¥)
 
/***  ³õ´ÎʹÓÃʱעÒâ  ****
ÔËÐнDZ¾Ê±µÄÃüÁ
ÏÈÇл»µ½ unix»·¾³Ï£¬cd
$oracle_home   cd sqlplus  cd demo ÏÂÃæÓÐÁ½¸ö½Ç±¾
½¨±íÓï¾ä¡£           µÚ2Ò³
@demobld.sql
sqlplus
nanjing/nanjing @demobid.sql Ö±½ÓÔËÐнDZ¾£¬ºóÃæ¸úµ±Ç°Ä¿Â¼»òÕßÊǾø¶Ô
·¾¶
 
±£´æ¸Õ²ÅµÄ sql Óï¾ä£º   save ÃüÁî      µÚ¶þ´Î±£´æÊ±ÒªÌ滻֮ǰµÄ½Ç±¾ save
ÎļþÃû  
replace
°Ñ¸Õ²Å±£µÄ sql ÖØÐ·ÅÈë  buffer ÖÐ
 
spool on  ¿ªÆô¼Ç¼
spool off  ¹Ø±Õ¼Ç¼
spool   ÎļþÃû  ´ËÃüÁî»á°ÑËùÓеIJÙ×÷´æÔÚij¸öÎļþÖÐÈ¥
 
³£¼ûËõд£º
nls national
langua


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

OracleÊÕ¹ºSun£¬ÒâÔÚIBM£¬Ãëɱ΢Èí

¡¡¡¡Sun±¾À´¾ÍºÜÀ÷º¦£¬Î޷ǽüÄêÀ´Ó¯ÀûÄÜÁ¦ÓÐËùϽµ£¬Oracle¿¿Êý¾Ý¿â׬ÁË´ó°Ñ³®Æ±¡£Á½¼ÒÁªºÏÒÔºóÐγɓCPU-¸ß¶ËÖ÷»ú-²Ù×÷ϵͳ-¿ª·¢»·¾³-Êý¾Ý¿â-ÓïÑÔ-Ó¦ÓÃÈí¼þ”Ò»ÌõÁú²úÆ·Ïߣ¬´ËǰÓдËÄÜÁ¦µÄÖ»ÓÐIBM¡£
¡¡¡¡Á½¼Ò½ñºóµÄÕÐÅÆ²úÆ·¶Ô±ÈÈçÏ£º
SUN&Oracle IBM
CPU Ultra Power
Ö÷»ú UltraϵÁÐ RS,ASµÈPowerϵÁ ......

Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ

¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿â
ϵͳǰ,ÓÐË­¶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQL
µÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
j8m ......

oracleµÄÕýÔò±í´ïʽ(regular expression)¼òµ¥½éÉÜ

Ŀǰ£¬ÕýÔò±í´ïʽÒѾ­ÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
 
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ ÖØ¸´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
 
Oracle 10gÖ§³ÖÕýÔò±í´ïʽµÄËĸöк¯Êý ......

OracleÖÐÊý¾Ý¿âÓû§ºÍ±í¿Õ¼ä¹ØÏµ

Ò»¸öÓû§¿ÉÒÔʹÓÃÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¬Ò»¸ö±í¿Õ¼äÒ²¿ÉÒÔ¹©¶à¸öÓû§Ê¹Óá£Óû§ºÍ±í¿Õ¼äûÓÐÁ¥Êô¹ØÏµ£¬±í¿ÕÊÇÒ»¸öÓÃÀ´¹ÜÀíÊý¾Ý´æ´¢Âß¼­¸ÅÄ±í¿Õ¼äÖ»ÊǺÍÊý¾ÝÎļþ·¢Éú¹ØÏµ£¬Êý¾ÝÎļþÊÇÎïÀíµÄ£¬Ò»¸ö±í¿Õ¼ä¿ÉÒÔ°üº¬¶à¸öÊý¾ÝÎļþ£¬¶øÒ»¸öÊý¾ÝÎļþÖ»ÄÜÁ¥ÊôÒ»¸ö±í¿Õ¼ä¡£ 
      Óû§ÊôÓÚÊý¾Ý¿âʵÀýµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ