¹ØÓÚ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£©µÈ¶ÔÏóȨÏÞ£¬¶ø´æ´¢¹ý³Ì¡¢´æ´¢º¯Êýµ
Ïà¹ØÎĵµ£º
ʹÓõÄÊÇ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 ......
2009-04-22 22:00
À´Ô´£ºÖйú
IT
ʵÑé
ÊÒ ×÷ÕߣºØýÃû
Oracle
¿Í
Ȥ
¶ËÓë·þ
Îñ
Æ÷¶ËµÄ
Á¬
½ÓÊÇͨ
¹ý
¿Í
Ȥ
¶Ë
·¢
³ö
Á¬
½Ó
Çë
Çó£¬ÓÉ·þ
Îñ
Æ÷¶Ë
¼à
ÌýÆ÷
¶Ô
¿Í
Ȥ
¶Ë
Á¬
½Ó
Çë
Çó
½ø
ÐкϷ¨
¼ì²é
£¬Èç¹û
Á¬
½Ó
Çë
ÇóÓÐЧ£¬
Ôò½ø
ÐÐ
Á¬
½Ó£¬·ñ
Ôò
¾Ü
¾ø¸ÃÁ¬
½Ó¡£ ......
Oracle Instant ClientÊÇÃâ°²×°µÄOracle¿Í»§¶Ë£¬ÓÉÓÚËüûÓб»OracleµÄ°²×°³ÌÐòËù·â×°£¬Ê¹Óû§¸üÈÝÒ×Àí½âËüµÄ½á¹¹¡£
Instant Client¼ò½é
ÔÚÆä×îеÄVersion 11.1.0.7.0ÖУ¬°üÀ¨ÏÂÃæµÄ°ü£º
µÚÒ»¡¢»ù±¾°ü¡£
ÓÐÁ½ÖÖ£ºÈ«¹¦ÄÜ°üºÍ¼ò»¯°ü£¬¸ù¾ÝÐèÒªÏÂÔØ¡£
1) Instant Client Package - Basic: All files required ......
oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
1¡¢´´½¨¹ý³ÌµÄÓï·¨£º
Code
create [or replace] procedure procedure_name
[(argument[{in|out|in out}] type,
argument[{in|out|in out}] type)]&n ......
³ö´¦£ºhttp://hi.baidu.com/vcy168/blog/item/877945d908c3d52611df9ba0.html
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ ......