ÈçÌ⣬ÎÒºÜÏëÖªµÀ¾¿¾¹Ê²Ã´ÑùµÄ¾³½ç¾ÍË㾫ͨ£¿ÓÐÄÄЩ¾ßÌåµÄ£¬¿É²âµÄÖ¸±êÄܹ»²âÊÔµ½µ×ÊDz»ÊǾ«Í¨°¡£¿Ò»Ö±ºÜÀ§»ó
¡£¾³£¿´µ½ÕÐÆ¸ÐÅÏ¢ÉÏ XXX ¾«Í¨£¬XXX¾«Í¨¡£µ«ÊÇÕæµÄ¸ã²»Çå³þËûÃÇ˵µÄ¾«Í¨ÊǸöʲô¸ÅÄÄÇЩ¾«Í¨µÄ´óϺÃÇ£¬Äܲ»ÄÜ̸϶Ծ«Í¨µÄÀí½âºÍ¸ÐÊܰ¡£¿
àÅÎÒÒ²ÏëÖªµÀ
oracle¾«Í¨ÓеãÁýͳ£¬ÊÇ¿ª·¢¾«Í¨»¹ÊǹÜÀí¾«Í¨ÄØ ......
×î½üÔÚÕÒoracleµÄ·ÖÒ³´æ´¢¹ý³Ì£¬ÔÚgoogleÉÏÒ»ËÑ£¬»ù±¾¾ÍÊÇÕâôÁ½ÖÖ£¬¶¼ÊÇ»ùÓÚrownumµÄ£º
1.²ÉÓÃrow_number½âÎöº¯Êý
SELECT xx.* from(
SELECT t.*,row_number() over(ORDER BY id)AS num
from t_order t
)xx
WHERE num BETWEEN 5 AND 15;
--·µ»ØµÚ5-15ÐÐÊý¾Ý
2.²ÉÓÃrownum¹Ø¼ü×Ö(Èý²ãǶÌ×) ......
ΪʲôûÊä³ö°¡
!!
²»ÒªÁ´½Ó±¾µØµÄͼƬµØÖ·
´«µ½csdn¿Õ¼äÀÔÙÁ´½Ó
¾ÍÊÇÕâ¸öͼƬ£¬ÎªÊ²Ã´Ã»Êä³ö°¡
ÊäÈëset serveroutput onºó»Ø³µ
È»ºóÔÙÊäÈëÄãµÄ³ÌÐò¾Í»áÏÔʾ
ÊÇÒòΪû´ò¿ªÊä³ö
ÒýÓÃ
ÊäÈëset serveroutput onºó»Ø³µ
È»ºóÔÙÊäÈëÄãµÄ³ÌÐò¾Í»áÏÔʾ
ÊÇÒò ......
´ó¼ÒºÃ£¡
¹«Ë¾ÔÚÉÏÒ»¸öÏîÄ¿£¬ÒªÓõ½oracle,֮ǰһֱ¶¼ÊÇÓõÄsqlSERver,ÏÖÔÚͻȻÓÃoracle£¬¸Ðµ½ÎÞ´ÓÏÂÊÖ£¬Á¬×î»ù±¾µÄÁ´½ÓÊý¾Ý¿â£¬½¨Êý¾Ý¿â£¬½¨±í¶¼²»ÖªµÀ¸Ã´ÓÄÄÀ↑ʼ£¬ÓÚÊÇÉÏÍø²éÁË×ÊÁϱ»ÀïÃæµÄÃû´Ê±ÈÈç˵¡°±í¿Õ¼ä¡±ÅªµÄÔÎͷתÏòµÄ£¬ÒÔǰ¶ÔsqlserverµÄÈÏʶ·¢ÏÖÔÚoracleÉϲ»ÊÊÓÃÁË£¬ËÄܰïÎÒ½âÊÍÒ»ÏÂoracle ......
oracleÖÐÓÃcheckÔ¼ÊøÔõô¼ì²éÊÖ»úºÅÂ룿֪µÀµÄ»Ø¸ö ллÁË£¡
ÕýÔò±í´ïʽ°É
²»¹ýÎÒ²»Ôõô»á
ºÇºÇ
µÈµÈÆäËûÅóÓÑÀ´¸øÄã½â´ð
¿ÉÒÔÓÃÕýÔòcheck(regexp_like(colname,'[0-9]{11}'))
²»¹ý¾ßÌåÔõô×öÒª×ܽá³ö¹æÂÉ
ºÇºÇ ¼ÈȻ¥ÉϵÄÒѾ»Ø´ðÁË
ÎÒÀ´¸øÄã½âÊÍÒ»ÏÂ?
[0-9]±íʾ±ØÐëÊÇÊý×Ö
{11}±íÊ¾Ö ......
racleDataBaseÊÇ×Ô¼º¶¨ÒåµÄÒ»¸ö²Ù×÷Êý¾Ý¿âµÄÀ࣬NoReturnSqlÊÇÖ´Ðмòµ¥µÄsqlÓï¾äµÄ·½·¨
public void NoReturnSql(string Sql)
{
Open();
Cm = new OracleCommand(Sql, Cn);
Cm.ExecuteNonQuery();
& ......