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

¹ØÓÚORACLEÊý¾Ý¿âÖÐȨÏ޺ͽÇÉ«µÄ̽Ë÷

OracleÊý¾Ý¿âÊÇÒ»ÖÖ´óÐ͹ØϵÐ͵ÄÊý¾Ý¿â£¬ÎÒÃÇÖªµÀµ±Ê¹ÓÃÒ»¸öÊý¾Ý¿âʱ£¬½ö½öÄܹ»¿ØÖÆÄÄЩÈË¿ÉÒÔ·ÃÎÊÊý¾Ý¿â£¬ÄÄЩÈ˲»ÄÜ·ÃÎÊÊý¾Ý¿âÊÇÎÞ·¨Âú×ãÊý¾Ý¿â·ÃÎÊ¿ØÖƵġ£DBAÐèҪͨ¹ýÒ»ÖÖ»úÖÆÀ´ÏÞÖÆÓû§¿ÉÒÔ×öʲô£¬²»ÄÜ×öʲô£¬ÕâÔÚOracleÖпÉÒÔͨ¹ýΪÓû§ÉèÖÃȨÏÞÀ´ÊµÏÖ¡£È¨ÏÞ¾ÍÊÇÓû§¿ÉÒÔÖ´ÐÐijÖÖ²Ù×÷µÄȨÀû¡£¶ø½ÇÉ«ÊÇΪÁË·½±ãDBA¹ÜÀíȨÏÞ¶øÒýÈëµÄÒ»¸ö¸ÅÄËüʵ¼ÊÉÏÊÇÒ»¸öÃüÃûµÄȨÏÞ¼¯ºÏ¡£
1         ȨÏÞ
OracleÊý¾Ý¿âÓÐÁ½ÖÖ;¾¶»ñµÃȨÏÞ£¬ËüÃÇ·Ö±ðΪ£º
¢Ù  DBAÖ±½ÓÏòÓû§ÊÚÓèȨÏÞ¡£
¢Ú  DBA½«È¨ÏÞÊÚÓè½ÇÉ«£¨Ò»¸öÃüÃûµÄ°üº¬¶à¸öȨÏ޵ļ¯ºÏ£©£¬È»ºóÔÙ½«½ÇÉ«ÊÚÓèÒ»¸ö»ò¶à¸öÓû§¡£
ʹÓýÇÉ«Äܹ»¸ü¼Ó·½±ãºÍ¸ßЧµØ¶ÔȨÏÞ½øÐйÜÀí£¬ËùÒÔDBAÓ¦¸ÃÏ°¹ßÓÚʹÓýÇÉ«ÏòÓû§½øÐÐÊÚÓèȨÏÞ£¬¶ø²»ÊÇÖ±½ÓÏòÓû§ÊÚÓèȨÏÞ¡£
       OracleÖеÄȨÏÞ¿ÉÒÔ·ÖΪÁ½Àࣺ
•ÏµÍ³È¨ÏÞ
•¶ÔÏóȨÏÞ
1.1  ϵͳȨÏÞ
ϵͳȨÏÞÊÇÔÚÊý¾Ý¿âÖÐÖ´ÐÐijÖÖ²Ù×÷£¬»òÕßÕë¶ÔijһÀàµÄ¶ÔÏóÖ´ÐÐijÖÖ²Ù×÷µÄȨÀû¡£ÀýÈ磬ÔÚÊý¾Ý¿âÖд´½¨±í¿Õ¼äµÄȨÀû£¬»òÕßÔÚÈκÎģʽÖд´½¨±íµÄȨÀû£¬ÕâЩ¶¼ÊôÓÚϵͳȨÏÞ¡£ÔÚOracle9iÖÐÒ»¹²ÌṩÁË60¶àÖÖȨÏÞ¡£
       ϵͳȨÏÞµÄȨÀûºÜ´ó£¬Í¨³£Çé¿öÏ£º
¢Ù  Ö»ÓÐDBA²ÅÓ¦µ±ÓµÓÐalter databaseϵͳȨÏÞ£¬¸ÃȨÏÞÔÊÐíÓû§¶ÔÊý¾Ý¿âÎïÀí½á¹¹ºÍ¿ÉÓÃÐÔ½øÐÐÐ޸ġ£
¢Ú    Ó¦ÓóÌÐò¿ª·¢ÕßÒ»°ãÓ¦¸ÃÓµÓÐCreate Table¡¢Create ViewºÍCreate TypeµÈϵͳȨÏÞ£¬ÓÃÓÚ´´½¨Ö§³ÖÇ°¶ËµÄÊý¾Ý¿âģʽ¶ÔÏó¡£
¢Û    ÆÕͨÓû§Ò»°ãÖ»¾ßÓÐCreate SessionϵͳȨÏÞ£¨¿ÉÒÔͨ¹ýConnection½ÇÉ«»ñµÃ£©£¬Ö»ÓÐCreate SessionϵͳȨÏÞµÄÓû§²ÅÄÜÁ¬½Óµ½Êý¾Ý¿â
¢Ü    Ö»ÓоßÓÐGrant Any PrivilegeϵͳȨÏÞÓû§£¬»òÕß»ñÈ¡Á˾ßÓÐWith Admin OptionÑ¡ÏîµÄϵͳȨÏÞµÄÓû§£¬²ÅÄܹ»³ÉΪÆäËüÓû§ÊÚÓèȨÏÞ¡£
1.2¶ÔÏóȨÏÞ
       ¶ÔÏóȨÏÞÊÇÕë¶Ôij¸öÌض¨µÄģʽ¶ÔÏóÖ´ÐвÙ×÷µÄȨÀû¡£Ö»ÄÜÕë¶Ôģʽ¶ÔÏóÀ´ÉèÖú͹ÜÀí¶ÔÏóȨÏÞ¡£
        ¶ÔÓÚģʽ¶ÔÏó£º±í¡¢ÊÓͼ¡¢ÐòÁС¢´æ´¢¹ý³Ì¡¢´æ´¢º¯Êý¡¢°ü¶¼¿ÉÒÔ¶ÔÏóÉèÖÃȨÏÞ¡£²»Í¬ÀàÐÍģʽ¶ÔÏó¾ßÓв»Í¬µÄ¶ÔÏóȨÏÞ¡£±ÈÈ磬±í¡¢ÊÓͼµÈ¶ÔÏó¾ßÓвéѯ£¨Select£©¡¢Ð޸ģ¨Update£©¡¢É¾³ý£¨Delete£©µÈ¶ÔÏóȨÏÞ£¬¶ø´æ´¢¹ý³Ì¡¢´æ´¢º¯Êýµ


Ïà¹ØÎĵµ£º

PHPÁ¬½ÓOracle²¢·ÖÒ³·ÃÎÊ

ʹÓõÄÊÇADODB¿â,ÐèÒªÓÐOCI8¿â.
<?php

//require("adodb5/adodb-exceptions.inc.php");
require("adodb5/adodb.inc.php");
$conn = NewADOConnection("oci8");
$conn->Connect($url, $user, $password, $service_name);
$rs;
try {
$rs = $conn->Execu ......

dzÎöOracle¼àÌýÆ÷°²×°ÓëÅäÖÃ

2009-04-22 22:00
À´Ô´£ºÖйú
IT
ʵÑé
ÊÒ ×÷ÕߣºØýÃû
 
Oracle
¿Í
Ȥ
¶ËÓë·þ
Îñ
Æ÷¶ËµÄ
Á¬
½ÓÊÇͨ
¹ý
¿Í
Ȥ
¶Ë
·¢
³ö
Á¬
½Ó
Çë
Çó£¬ÓÉ·þ
Îñ
Æ÷¶Ë
¼à
ÌýÆ÷
¶Ô
¿Í
Ȥ
¶Ë
Á¬
½Ó
Çë
Çó
½ø
ÐкϷ¨
¼ì²é
£¬Èç¹û
Á¬
½Ó
Çë
ÇóÓÐЧ£¬
Ôò½ø
ÐÐ
Á¬
½Ó£¬·ñ
Ôò
¾Ü
¾ø¸ÃÁ¬
½Ó¡£ ......

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

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

oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç

oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
1¡¢´´½¨¹ý³ÌµÄÓï·¨£º     
Code
create [or replace] procedure procedure_name
  [(argument[{in|out|in out}] type,
    
   argument[{in|out|in out}] type)]&n ......

WindowsXPÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â

 ³ö´¦£ºhttp://hi.baidu.com/vcy168/blog/item/877945d908c3d52611df9ba0.html
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ