¡¾×ª¡¿oracle´óÊý¾ÝÁ¿µÄµ¼ÈëºÍµ¼³ö
ÔÚoracleÖÐÅúÁ¿Êý¾ÝµÄµ¼³öÊǽèÖúsqlplusµÄspoolÀ´ÊµÏֵġ£ÅúÁ¿Êý¾ÝµÄµ¼ÈëÊÇͨ¹ýsqlloadÀ´ÊµÏֵġ£
´óÁ¿Êý¾ÝµÄµ¼³ö²¿·ÖÈçÏ£º
/***************************
* sql½Å±¾²¿·Ö demo.sql begin
**************************/
/**************************
* @author meconsea
* @date 20050413
* @msn meconsea@hotmail.com
* @Email meconsea@163.com
**************************/
//##--markup html£ºhtml¸ñʽÊä³ö£¬È±Ê¡Îªoff
//##--autocommit£º×Ô¶¯Ìá½»insert¡¢update¡¢delete´øÀ´µÄ¼Ç¼¸Ä±ä£¬È±Ê¡Îªoff
//##--define£ºÊ¶±ðÃüÁîÖеıäÁ¿Ç°×º·û£¬È±Ê¡Îªon£¬Ò²¾ÍÊÇ'&'£¬Åöµ½±äÁ¿Ç°×º·û£¬ºóÃæµÄ×Ö·û´®×÷Ϊ±äÁ¿´¦Àí.
set colsep' '; //##--ÓòÊä³ö·Ö¸ô·û
set echo off; //##--ÏÔʾstartÆô¶¯µÄ½Å±¾ÖеÄÿ¸ösqlÃüÁȱʡΪon
set feedback off; //##--»ØÏÔ±¾´ÎsqlÃüÁî´¦ÀíµÄ¼Ç¼ÌõÊý£¬È±Ê¡Îªon
set heading off; //##--Êä³öÓò±êÌ⣬ȱʡΪon
set pagesize 0; //##--Êä³öÿҳÐÐÊý£¬È±Ê¡Îª24,ΪÁ˱ÜÃâ·ÖÒ³£¬¿ÉÉ趨Ϊ0¡£
set linesize 80; //##--Êä³öÒ»ÐÐ×Ö·û¸öÊý£¬È±Ê¡Îª80
set numwidth 12; &nb
Ïà¹ØÎĵµ£º
·ÖÒ³µÄ×ÚÖ¼ÊÇ¿ØÖƲéѯ³öÀ´µÄÊý¾Ý¸öÊý£¬ÏÂÃæÕâÌõÓï¾ä¶ÔÓÚOracle·ÖÒ³ÒѾ×ã¹»ÁË¡£
£¨×¢£º¸ÃÓï¾äÖ»ÄÜÓÃÓÚOracle£©
SELECT * from (SELECT temp.*, ROWNUM RN from (SELECT * from USERS ORDER BY ID DESC) temp) WHERE RN > 0 AND RN <= 10
SELECT *
from (SELECT AA.*, ROWNUM RN ......
Oracle RAC ͬʱ¾ß±¸HA(High Availiablity) ºÍLB(LoadBalance). ¶øÆä¸ß¿ÉÓÃÐԵĻù´¡¾ÍÊÇFailover(¹ÊÕÏתÒÆ). ËüÖ¸¼¯ÈºÖÐÈκÎÒ»¸ö½ÚµãµÄ¹ÊÕ϶¼²»»áÓ°ÏìÓû§µÄʹÓã¬Á¬½Óµ½¹ÊÕϽڵãµÄÓû§»á±»×Ô¶¯×ªÒƵ½½¡¿µ½Úµã£¬´ÓÓû§¸ÐÊܶøÑÔ£¬ ÊǸоõ²»µ½ÕâÖÖÇл»¡£
Oracle&nbs ......
[×ÊÁÏÀ´×ÔÓÚORACLEƵµÀ http://oracle.chinaitlab.com/induction/398193.html]
¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç:
¡¡¡¡SELECT /*+ALL_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT';
¡¡¡ ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO ......