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

oracle±Ê¼Ç

½ñÌìÖØÐÂÕûÀíµçÄÔ£¬ÕÒµ½Ò»¸öÎļþ£¬¿´ÁËÏÂÈÕÆÚ£¨2006.11.3£© £¬Å²»Ð¡ÐÄÔÙ¶ªÁË£¬´æµ½ÍøÉÏÀ´É¹É¹¡£
SQL ÓïÑÔ·ÖÀࣺ
1  DDL£¨Êý¾Ý¶¨Òå £©ÓÃÓÚ´´½¨ºÍ¶¨ÒåÊý¾Ý¿â¶ÔÏ󣬲¢ÇÒ½«¶ÔÕâЩ¶ÔÏóµÄ¶¨Òå±£´æÔÚÊý¾Ý×ÖµäÖС£
creat  table     ´´½¨±í
alter  table     Ð޸ıí
drop   table     ɾ³ý±í
truncate  table  ɾ³ý±íÖÐËùÓÐÐÐ
create  index    ´´½¨Ë÷Òý
drop index       ɾ³ýË÷Òý
2  DML 
insert  ½«¼Ç¼²åÈëµ½Êý¾Ý¿â
update  ÐÞ¸ÄÊý¾Ý¿âµÄ¼Ç¼
delete   ɾ³ýÊý¾Ý¿âµÄ¼Ç¼
3  DCL
  ÔÊÐíÓà grantÃüÁîΪÓû§»ò½ÇÉ«ÊÚÓèϵͳȨÏÞ»òÕë¶Ô¾ßÌå¶ÔÏóÊÚȨ
  ÓÃrevokeÃüÁî´ÓÓû§»ò½ÇÉ«´¦ÊÕ»Øϵͳ»ò¶ÔÏóȨÏÞ
4 ÊÂÎñ´¦Àí
    commit  rollback   savepoint 
     commit  ±£´æ¸ü¸Ä
     rollback ɾ³ý¸ü¸Ä
    savepoint  ±ê¼ÇÏ£Íû»ØÍ˵ÄÖмäµã
 
5  Êý¾Ý¼ìË÷
    select
2.2  SQL*plusÈëÃÅ£º
2.2.2
×¢Ò⣺SQL*plusÃüÁî²»ÊÇSQLÃüÁÊäÈëʱÃüÁî½áβ²»Óüӓ£»”¡£
¡¡¡¡edit ¡¡¡¡ÐÞ¸ÄÃüÁî
    /   ¡¡¡¡Ö´ÐиոÕÐ޸ĵÄÄÚÈÝ
¡¡(clear  screen)ÇåÆÁ
    linesize  ÉèÖÃÐеij¤¶È
¡¡¡¡pagesize  ͨ³£ÉèÖÃΪ9999(set pagesize 9999)
   
ora-12560 :ЭÒéÊÊÅäÆ÷´íÎó
lsnrctl start   Æô¶¯¼àÌýÆ÷
net start oracleservice (pcszh) Æô¶¯·þÎñ
2.3.1
Êý¾Ý¿â¹ÜÀíÔ±ÈÏÖ¤·½Ê½£º
1²Ù×÷ϵͳÈÏÖ¤£º
connect/as  sysdba
connect/sa sysoper
2ʹÓÃÃÜÂëÎļþÑéÖ¤·½Ê½£º
Èç¹û»¹Ã»Óд´½¨²Ù×÷ϵͳÕʺţ¬ÔòʹÓÃorapwdʹÓóÌÐòÀ´´´½¨ÃÜÂëÎļþ
orapwd  file=filename password=password  entries=max_users
½«³õʼ»¯²ÎÊýremote_login_passwordfile ÉèÖÃΪexclusive
Èç¹ûÓû§»¹²»ÔÚÊý¾Ý¿âÖУ¬ÔòÐèÒªÏÈ´´½¨sysdbaÓû§²¢ÊÚȨsysoperÓû§»òϵͳȨÏÞ¡£
grant sysdba to user;(¸ÃÓï¾ä½«Óû§Ìí¼Óµ½ÃÜÂëÎļþÖУ¬´Ó¶ø¿ÉÒÔ×÷Ϊdba½øÐÐÁ¬½Ó²Ù×÷)
connect scott/tiger as sysdba£¨Óû§ÒѾ­±»ÊÚÓ


Ïà¹ØÎĵµ£º

oracle ³£ÓñêÁ¿ÀàÐÍ

 £¨1£© varchar2(n):¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´®£¬ÆäÖÐ n ÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ 32767 ×Ö½Ú¡£µ±Ê¹ÓøÃÊý¾ÝÀàÐͶ¨Òå±äÁ¿ÊÇ£¬±ØÐë×¢Ò⣬ÔÚPL/SQL¿éÖÐʹÓøÃÊý¾ÝÀàÐͲÙ×Ývarchar2±íÁÐʱ£¬ÆäÊýÖµµÄ³¤¶È²»Ó¦¸Ã³¬¹ý 4000 ×Ö½Ú¡£
......

Oracle Ðм¶ËøµÄ¿ªÏú

Ê×ÏÈÀ´¸´Ï°Ò»ÏÂÐм¶ËøµÄ»úÖÆ¡£µ±Ò»¸öÊÂÎñ¿ªÊ¼Ê±±ØÑ¡ÏÈÉêÇëÒ»¸öTXËø£¨±£»¤»Ø¹ö¶Î¡¢»Ø¹öÊý¾Ý¿é£©£¬Ö»ÓÐÏÈÉêÇëµ½»Ø¹ö¶Î×ÊÔ´ºó²ÅÄÜ¿ªÊ¼Ò»¸öÊÂÎñ£¬²ÅÄܽøÐÐDML²Ù×÷¡£Õâ¸ö¶¯×÷Íê³Éºó£¬ÊÂÎñ¾Í¿ÉÒÔ¿ªÊ¼ÐÞ¸ÄÊý¾ÝÁË¡£µ±ÐÞ¸ÄÊý¾Ý±íµÄ¼Ç¼ʱ£¬×ñÑ­ÒÔϵIJÙ×÷˳Ðò¡£
1.»ñµÃ±íµÄTMËø£¨±£»¤ÊÂÎñÖ´Ðйý³ÌÖÐÆäËüÓû§²»ÄÜÐ޸ıí½á¹¹£©
2.ÔÚ ......

oracleÁÐתÐз½·¨×ܽá

·½·¨Ò»£º
----------------------------------------------------------------
---Muti-row to line(col2row)
----------------------------------------------------------------
create or replace type str_tab is table of varchar2(20);
/
grant all on str_tab to public;
create public synonym str_tab for ......

Ãâ°²×°µÄOracle¿Í»§¶Ë

 Oracle Instant ClientÊÇÃâ°²×°µÄOracle¿Í»§¶Ë£¬ÓÉÓÚËüûÓб»OracleµÄ°²×°³ÌÐòËù·â×°£¬Ê¹Óû§¸üÈÝÒ×Àí½âËüµÄ½á¹¹¡£
Instant Client¼ò½é
ÔÚÆä×îеÄVersion 11.1.0.7.0ÖУ¬°üÀ¨ÏÂÃæµÄ°ü£º
µÚÒ»¡¢»ù±¾°ü¡£
ÓÐÁ½ÖÖ£ºÈ«¹¦ÄÜ°üºÍ¼ò»¯°ü£¬¸ù¾ÝÐèÒªÏÂÔØ¡£
1)  Instant Client Package - Basic: All files required ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ