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£¨Óû§ÒѾ±»ÊÚÓ
Ïà¹ØÎĵµ£º
SELECT a.ADDRESS,
sql_text,
executions,
rows_processed,
cpu_time,
a.DISK_READS,
  ......
ʹÓõÄÊÇ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
Óû§¹ÜÀíÖ®Ò»¡¢´´½¨profile
Îļþ¡£
1.
SQL>Create
profile
ÎļþÃû limit
2.
  ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿Í»§¶Ë£¬Ëü¿ÉÒ ......