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

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,'µ¥Î»ÊÇ¿Õ')


Ïà¹ØÎĵµ£º

oracle nvl decode

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¼ä¸ôʱ¼äÏê½â

Oracle JOB ¼ä¸ôʱ¼äÏê½â
INTERVAL²ÎÊýÉèÖãº
ÿÌìÔËÐÐÒ»´Î                        'SYSDATE + 1'
ÿСʱÔËÐÐÒ»´Î           &nbs ......

oracle PL SQLѧϰ°¸Àý£¨Èý£©

´æ´¢¹ý³Ì
========================================================================== 
========================================================================== 
¡¾ÑµÁ·15.1¡¿  ´´½¨Ò»¸öÏÔʾ¹ÍÔ±×ÜÈËÊýµÄ´æ´¢¹ý³Ì¡£
  ²½Öè1£ºµÇ¼SCOTTÕË»§(»òѧÉú¸öÈËÕË»§)¡£
  ²½Öè2£º ......

jspÁ¬½Óoracle£¨javabean£©


package DBbean;
import java.sql.*;
public class ConnBean
{
private Connection con;
//³õʼ»¯Á¬½Ó¡£
public ConnBean()
{
        
  try
  {
   Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
   ......

´¦ÀíoracleÊý¾Ý

/**
 *
 */
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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ