Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ͨ¹ýÊý¾Ý×Öµä²éѯ¿´Ö´Ðмƻ®

SELECT a.ADDRESS,
       sql_text,
       executions,
       rows_processed,
       cpu_time,
       a.DISK_READS,
      ......

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 ......

OracleÓû§¹ÜÀí³£ÓòÙ×÷

 
ÒÔÏÂÁгöµÄÊÇOracle
Óû§¹ÜÀí¹ý³ÌÖг£ÓõÄһЩָÁÒÔ¹©´ó¼Ò²Î¿¼¡£
Oracle
Óû§¹ÜÀíÖ®Ò»¡¢´´½¨profile
Îļþ¡£

1.          
SQL>Create
profile
ÎļþÃû limit
2.          
   ......

Óà Navicat for Oracle ¹ÜÀí Oracle10g/11g Êý¾Ý¿â

  Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
    °²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿Í»§¶Ë£¬Ëü¿ÉÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ