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 ʵÏÖµÄ ×î¸ßЧdump³ÌÐò£¬ ±ÈOTL ÒÔ¼°ÆäËûµÄ½Ó¿Ú¶¼¿ìºÜ¶à
ÄÜÖ´ÐÐÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬½øÐÐÊä³öÊä³ö
/*
* oracle_dump.cpp
*
* Created on: 2010-2-1
* Author: clm971910@gmail.com
*
* ѹËõ
* 4216351 dump done
* ÍêÕû 106 Ãë
* д·Ö¸ô·û 8Ãë
* ѹËõд´Å ......
±¾ÎĵµÊÇOracle
Database 11.2.0.1 for RHEL5 Server(°üÀ¨x86ºÍx86_64ƽ̨)µÄ¾²Ä¬°²×°Ö¸ÄÏ. ËùÓвÙ×÷ÎÞÐèʹÓÃͼÐνçÃæ. ¾²Ä¬°²×°ÄܼõÉÙ°²×°³ö´íµÄ¿ÉÄÜÐÔ, Ò²ÄÜ´ó´ó¼Ó¿ì°²×°ËÙ¶È.
# ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂrootÓû§²Ù×÷; ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂoracleÓû§²Ù×÷;
1.1 ÉÏ´«Èí¼þ
¼ÙÈç·ÅÔÚ/wangnc/oracle/11g/Ä ......
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 ......
ÊäÈë²ÎÊý£ºstr ——Òª½ØÈ¡µÄ×Ö·û´®, ch——Òª²éÕÒµÄ×Ö·û´®
½ØÈ¡ch֮ǰ£¨²»°üÀ¨ch£©µÄ×Ö·û´®£º substr(str, 0, instr(str, ch) - 1)
½ØÈ¡chÖ®ºó£¨²»°üÀ¨ch£©µÄ×Ö·û´®£º substr(str, , instr(str, ch) + 1, length(str)) ......
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 ......