oracleÖжÔÅÅÐòµÄ×ܽá
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M');
¡¡¡¡-- °´²¿Ê×ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_STROKE_M');
¡¡¡¡-- °´±Ê»ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_RADICAL_M');
¡¡¡¡--ÅÅÐòºó»ñÈ¡µÚÒ»ÐÐÊý¾Ý
¡¡¡¡select * from (select * from perexl order by
nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M') )C where rownum=1
¡¡¡¡--½µÐòÅÅÐò
¡¡¡¡select * from perexl order by zongrshu desc
¡¡¡¡--ÉýÐòÅÅÐò
¡¡¡¡select * from perexl order by zongrshu asc
¡¡¡¡--½«nullsʼÖÕ·ÅÔÚ×îǰ
¡¡¡¡select * from perexl order by danwei nulls first
¡¡¡¡--½«nullsʼÖÕ·ÅÔÚ×îºó
¡¡¡¡select * from perexl order by danwei desc nulls last
¡¡¡¡--decodeº¯Êý±Ènvlº¯Êý¸üÇ¿´ó£¬Í¬ÑùËüÒ²¿ÉÒÔ½«ÊäÈë²ÎÊýΪ¿Õʱת»»ÎªÒ»Ìض¨Öµ
¡¡¡¡select * from perexl order by decode(danwei,null,'µ¥Î»ÊÇ¿Õ', danwei)
¡¡¡¡-- ±ê×¼µÄrownum·ÖÒ³²éѯʹÓ÷½·¨
¡¡¡¡select *from (select c.*, rownum rn from personnel c)where rn >= 1and rn <= 5
¡¡¡¡--ÔÚoracleÓï¾ärownum¶ÔÅÅÐò·ÖÒ³µÄ½â¾ö·½°¸
¡¡¡¡--µ«ÊÇÈç¹û, ¼ÓÉÏorder by ÐÕÃû ÅÅÐòÔòÊý¾ÝÏÔʾ²»ÕýÈ·
¡¡¡¡select *from (select c.*, rownum rn from personnel c order by ³öÉúÄêÔÂ)where rn >=
1and rn <= 5
¡¡¡¡--½â¾ö·½·¨£¬ÔÙ¼ÓÒ»²ã²éѯ£¬Ôò¿ÉÒÔ½â¾ö
¡¡¡¡select *from (select rownum rn, t.*from (select ÐÕÃû, ³öÉúÄêÔÂ from personnel order
by ³öÉúÄêÔÂ desc) t)where rn >= 1and rn <= 5
¡¡¡¡--Èç¹ûÒª¿¼Âǵ½Ð§ÂʵÄÎÊÌ⣬ÉÏÃæµÄ»¹¿ÉÒÔÓÅ»¯³É£¨Ö÷ÒªÁ½ÕßÇø±ð£©
¡¡¡¡select *from (select rownum rn, t.*from (select ÐÕÃû,³öÉúÄêÔÂ from personnel order
by ³öÉúÄêÔÂ desc) t where rownum <= 10) where rn >= 3
¡¡¡¡--nvlº¯Êý¿ÉÒÔ½«ÊäÈë²ÎÊýΪ¿Õʱת»»ÎªÒ»Ìض¨Öµ,ÏÂÃæ¾ÍÊǵ±µ¥Î»Îª¿ÕµÄʱºòת»»³É“µ¥Î»ÊǿՔ
¡¡¡¡select * from perexl order by nvl(danwei,'µ¥Î»ÊÇ¿Õ')
Ïà¹ØÎĵµ£º
SELECT
DECODE(ÁÐ,0,'Q'1,'P',2,'O')¡¡AS ret
from dual
--·ÖÎö: µ± ÁÐ=0ʱ,½«"Q"¸³Öµ
--µ± ÁÐ =1ʱ,½«"P"¸³Öµ
--µ± ÁÐ=2ʱ,½«"O"¸³Öµ
--NVL()º¯Êý:
--NVL(ARG,VALUE)´ï±êÈç¹ûÇ°ÃæµÄARGֵΪNULLÄÇô·µ»ØµÄֵΪºóÃæµÄVALUE¶þÕß½áºÏʹÓÃ:
DECODE(NVL(±äÁ¿ ''),'','-','OK')
//·ÖÎö:
--Èô ±äÁ¿ ÊÇ·ñΪ¿Õ.ÈôΪ¿Õ¸³¸ø¿ ......
Oracle JOB ¼ä¸ôʱ¼äÏê½â
INTERVAL²ÎÊýÉèÖãº
ÿÌìÔËÐÐÒ»´Î 'SYSDATE + 1'
ÿСʱÔËÐÐÒ»´Î &nbs ......
´æ´¢¹ý³Ì
==========================================================================
==========================================================================
¡¾ÑµÁ·15.1¡¿ ´´½¨Ò»¸öÏÔʾ¹ÍÔ±×ÜÈËÊýµÄ´æ´¢¹ý³Ì¡£
²½Öè1£ºµÇ¼SCOTTÕË»§(»òѧÉú¸öÈËÕË»§)¡£
²½Öè2£º ......
package DBbean;
import java.sql.*;
public class ConnBean
{
private Connection con;
//³õʼ»¯Á¬½Ó¡£
public ConnBean()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
......
/**
*
*/
package com.huawei.widget.util;
import java.math.BigDecimal;
/**
* @author tanjixuan
* @since 2008-12-20
*
*/
public final class DatabaseUtil
{
// oracleתÒå×Ö·û
public static final char ORACLE_ESCAPE_CHAR = '\\';
// orac ......