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

ORACLE ×óÓÒÁ´½Ó

Êý¾Ý±íµÄÁ¬½ÓÓÐ:
1¡¢ÄÚÁ¬½Ó(×ÔÈ»Á¬½Ó): Ö»ÓÐÁ½¸ö±íÏàÆ¥ÅäµÄÐвÅÄÜÔÚ½á¹û¼¯ÖгöÏÖ
2¡¢ÍâÁ¬½Ó: °üÀ¨
     £¨1£©×óÍâÁ¬½Ó(×ó±ßµÄ±í²»¼ÓÏÞÖÆ)
     £¨2£©ÓÒÍâÁ¬½Ó(ÓÒ±ßµÄ±í²»¼ÓÏÞÖÆ)
     £¨3£©È«ÍâÁ¬½Ó(×óÓÒÁ½±í¶¼²»¼ÓÏÞÖÆ)
3¡¢×ÔÁ¬½Ó(Á¬½Ó·¢ÉúÔÚÒ»ÕÅ»ù±íÄÚ)
select a.studentno, a.studentname, b.classname
      from students a, classes b
      where a.classid(+) = b.classid;
STUDENTNO STUDENTNAM CLASSNAME
---------- ---------- ------------------------------
            1 aa          Ò»Äê¼¶Ò»°à
            2 bb          Ò»Äê¼¶¶þ°à
                             Ò»Äê¼¶Èý°à
ÒÔÉÏÓï¾äÊÇÓÒÁ¬½Ó£º
¼´"(+)"ËùÔÚλÖõÄÁíÒ»²àΪÁ¬½ÓµÄ·½Ïò£¬ÓÒÁ¬½Ó˵Ã÷µÈºÅÓÒ²àµÄËùÓмǼ¾ù»á±»ÏÔʾ£¬ÎÞÂÛÆäÔÚ×ó²àÊÇ·ñµÃµ½Æ¥Åä¡£Ò²¾ÍÊÇ˵ÉÏÀýÖУ¬ÎÞÂۻ᲻»á³öÏÖij¸ö°à¼¶Ã»ÓÐÒ»¸öѧÉúµÄÇé¿ö£¬Õâ¸ö°à¼¶µÄÃû×Ö¶¼»áÔÚ²éѯ½á¹¹ÖгöÏÖ¡£
 
¼´"(+)"±íʾËùÔÚµÄÁеÄÖµ£¬Èç¹ûûÓÐÆ¥ÅäµÄÖµ£¬Ôò¼ÓÈënullÖµ£¬²¢ÏÔʾ³öÀ´¡£.
 
//ͨ³£½«È«Á¿¼¯ºÏÓ벿·Ö¼¯ºÏÁ¬½Óʱ£¬ÔÚ²¿·Ö¼¯ºÏµÄÁкóÃæ´øÉÏ£¨+£©£¬ÒԴﵽûÓÐÆ¥Åäʱ£¬Ò²ÒªÏÔʾ³öÒ»¸önullµÄЧ¹û¡£
 
 
·´Ö®£º
select a.studentno, a.studentname, b.classname
       from students a, classes b
      where a.classid = b.classid(+);
 
STUDENTNO STUDENTNAM CLASSNAME
---------- ---------- ------------------------------
            1 aa          Ò»Äê¼¶Ò»°à
            2 bb         


Ïà¹ØÎĵµ£º

»ùÓÚ OCI ʵÏÖµÄ oracle ×î¸ßЧdump³ÌÐò

»ùÓÚOCI ʵÏֵĠ×î¸ßЧdump³ÌÐò£¬ ±ÈOTL ÒÔ¼°ÆäËûµÄ½Ó¿Ú¶¼¿ìºÜ¶à
ÄÜÖ´ÐÐÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬½øÐÐÊä³öÊä³ö
/*
* oracle_dump.cpp
*
* Created on: 2010-2-1
* Author: clm971910@gmail.com
*
* ѹËõ
* 4216351 dump done
* ÍêÕû 106 Ãë
* д·Ö¸ô·û 8Ãë
* ѹËõд´Å ......

Oracle11gR2 for Linux ¾²Ä¬°²×°±Ê¼Ç


±¾ÎĵµÊÇOracle
Database 11.2.0.1 for RHEL5 Server(°üÀ¨x86ºÍx86_64ƽ̨)µÄ¾²Ä¬°²×°Ö¸ÄÏ. ËùÓвÙ×÷ÎÞÐèʹÓÃͼÐνçÃæ. ¾²Ä¬°²×°ÄܼõÉÙ°²×°³ö´íµÄ¿ÉÄÜÐÔ, Ò²ÄÜ´ó´ó¼Ó¿ì°²×°ËÙ¶È.
# ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂrootÓû§²Ù×÷;  ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂoracleÓû§²Ù×÷;
1.1 ÉÏ´«Èí¼þ
¼ÙÈç·ÅÔÚ/wangnc/oracle/11g/Ä ......

MsSQL,MySQL,Oracle,Êý¾Ý¿âÁ¬½Ó×Ö¶Î

Ms sql 2000
drivername=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=books
username=sa
password=sa
MySQL
drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/books
username=root
password=root
Oracle
drivername=orac ......

Oracle°´×Ö·û½ØÈ¡×Ö·û´®º¯Êý

ÊäÈë²ÎÊý£ºstr ——Òª½ØÈ¡µÄ×Ö·û´®,  ch——Òª²éÕÒµÄ×Ö·û´®
½ØÈ¡ch֮ǰ£¨²»°üÀ¨ch£©µÄ×Ö·û´®£º substr(str, 0, instr(str, ch) - 1)
½ØÈ¡chÖ®ºó£¨²»°üÀ¨ch£©µÄ×Ö·û´®£º substr(str, , instr(str, ch) + 1, length(str)) ......

Oracle Waits event:DB File Scattered Read

The DB File Scattered Read wait event generally indicates waits related to full table scans or fast
full index scans. As full table scans are pulled into memory, they are scattered throughout the
buffer cache, since it is usually unlikely that they fall into contiguous buffers. A large numb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ