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£¨Óû§ÒѾ±»ÊÚÓ
Ïà¹ØÎĵµ£º
£¨1£© varchar2(n):¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´®£¬ÆäÖÐ n ÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ 32767 ×Ö½Ú¡£µ±Ê¹ÓøÃÊý¾ÝÀàÐͶ¨Òå±äÁ¿ÊÇ£¬±ØÐë×¢Ò⣬ÔÚPL/SQL¿éÖÐʹÓøÃÊý¾ÝÀàÐͲÙ×Ývarchar2±íÁÐʱ£¬ÆäÊýÖµµÄ³¤¶È²»Ó¦¸Ã³¬¹ý 4000 ×Ö½Ú¡£
......
Ê×ÏÈÀ´¸´Ï°Ò»ÏÂÐм¶ËøµÄ»úÖÆ¡£µ±Ò»¸öÊÂÎñ¿ªÊ¼Ê±±ØÑ¡ÏÈÉêÇëÒ»¸öTXËø£¨±£»¤»Ø¹ö¶Î¡¢»Ø¹öÊý¾Ý¿é£©£¬Ö»ÓÐÏÈÉêÇëµ½»Ø¹ö¶Î×ÊÔ´ºó²ÅÄÜ¿ªÊ¼Ò»¸öÊÂÎñ£¬²ÅÄܽøÐÐDML²Ù×÷¡£Õâ¸ö¶¯×÷Íê³Éºó£¬ÊÂÎñ¾Í¿ÉÒÔ¿ªÊ¼ÐÞ¸ÄÊý¾ÝÁË¡£µ±ÐÞ¸ÄÊý¾Ý±íµÄ¼Ç¼ʱ£¬×ñÑÒÔϵIJÙ×÷˳Ðò¡£
1.»ñµÃ±íµÄTMËø£¨±£»¤ÊÂÎñÖ´Ðйý³ÌÖÐÆäËüÓû§²»ÄÜÐ޸ıí½á¹¹£©
2.ÔÚ ......
·½·¨Ò»£º
----------------------------------------------------------------
---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 Instant ClientÊÇÃâ°²×°µÄOracle¿Í»§¶Ë£¬ÓÉÓÚËüûÓб»OracleµÄ°²×°³ÌÐòËù·â×°£¬Ê¹Óû§¸üÈÝÒ×Àí½âËüµÄ½á¹¹¡£
Instant Client¼ò½é
ÔÚÆä×îеÄVersion 11.1.0.7.0ÖУ¬°üÀ¨ÏÂÃæµÄ°ü£º
µÚÒ»¡¢»ù±¾°ü¡£
ÓÐÁ½ÖÖ£ºÈ«¹¦ÄÜ°üºÍ¼ò»¯°ü£¬¸ù¾ÝÐèÒªÏÂÔØ¡£
1) Instant Client Package - Basic: All files required ......