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

OracleÖÐΪʲôwhere rownum > 3 ²éÕÒ²»µ½Êý¾Ý£¿

²éѯ±íempÖÐËùÓÐÊý¾Ý
select emp_id,rownum from emp
µÚÒ»²½£¬²éѯ½á¹û,rownum´ý¶¨
emp_id rownum
1         ?   1
2         ?   2
3         ?   3
4         ?
µÚ¶þ²½£¬ÏÖÔÚ¼ÙÉèÓÃrownum < 3µÄÌõ¼þÀ´¹ýÂË
µÚÒ»ÐУ¬rownum³õʼ·ÖÅäΪ1£¬Âú×ãrownum <3µÄÌõ¼þ£¬È»ºórownum¼Ó1
µÚ¶þÐУ¬rownumÏÖÔÚΪ2,Âú×ã < 3µÄÌõ¼þ,È»ºórownum¼Ó1
.....
µÚ¶þ²½£¬ÏÖÔÚ¼ÙÉèÓà rownum > 2µÄÌõ¼þÀ´¹ýÂË
ÏÖÔÚ¿´µÚÒ»ÐУ¬rownum³õʼ·ÖÅäΪ1£¬ ²»Âú×ãrownum>2µÄÌõ¼þ,rownum²»»á¼Ó1
µÚ¶þÐУ¬rownum»¹ÊÇ1£¬Í¬Ñù²»Âú×ã>2µÄÌõ¼þ
....
ËùÒÔ£¬×îºóµÄ²éѯ½á¹û£¬Ò»ÌõÊý¾ÝҲûÓÐ
Àý×Ó£¬È¡µÚ3Ðе¹µÚ5Ðе±Êý¾Ý
    select * from
               (select t.*,rwonum rn
              from emp t
               where rownum < 5 )
       where rn > 3


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

110¸öoracle³£Óú¯Êý×ܽá

1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- -
ÕÔ A
......

OracleÊý¾Ý¿â»¹Õæ²»ºÃÕû

´ÓÔÚLinuxÉϰ²×°Oracleµ½Í¶ÈëʹÓòż¸Ì죬Åöµ½µÄÎÊÌâ¾Í³É°ÙÉÏǧµÄ¡£ÔÚʹÓÿͻ§¶ËÁ¬½ÓÔ¶³ÌOracleÊý¾Ý¿â·þÎñÆ÷ʱ£¬³öÏÖÁËlistener refused the connection with the following error ora-12519 Listener refused the connection with the following error:ORA-12519, TNS:no appropriate service handler foundThe Connection ......

hibernate¸ù¾Ýʱ¼äÈÕÆÚÀ´²éѯoracleÊý¾Ý¿â

ʹÓÃÄ£ºý²éѯ£º
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd"); 
Date startdate = sdf.parse(start_date);
Date enddate = sdf.parse(end_date);
List list = sess.createCriteria(MyTabel.class)
               .add( ......

oracle ÕÒ³öÁ½±íÖ®¼ä·ÇÖØ¸´Êý¾Ý

select r.rollid as rollid from zh1_rool r where r.date_p >=to_date('2009-11-26 23:59:59','yyyy-mm-dd hh24:mi:ss') and rollid not in
(select t.lot_number as rollid
from inv.mtl_onhand_quantities_detail t
left join mtl_system_items_b mi
on t.inventory_item_id = mi.inventory_ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ