oracle ³£Ó÷ÖÎöº¯Êý
Oracle³£Ó÷ÖÎöº¯Êý
ROW_NUMBER
·µ»ØÓÐÐò×éÖÐÒ»ÐеÄÆ«ÒÆÁ¿£¬´Ó¶ø¿ÉÓÃÓÚ°´Ìض¨±ê×¼ÅÅÐòµÄÐкÅ
row_number() over(partition by ... order by ...)
RANK
¸ù¾ÝORDER BY×Ó¾äÖбí´ïʽµÄÖµ£¬´Ó²éѯ·µ»ØµÄÿһÐУ¬¼ÆËãËüÃÇÓëÆäËüÐеÄÏà¶ÔλÖá£×éÄÚµÄÊý¾Ý°´ORDER BY×Ó¾äÅÅÐò£¬È»ºó¸øÿһÐи³Ò»¸öºÅ£¬´Ó¶øÐγÉÒ»¸öÐòÁУ¬¸ÃÐòÁдÓ1¿ªÊ¼£¬ÍùºóÀÛ¼Ó¡£Ã¿´ÎORDER BY±í´ïʽµÄÖµ·¢Éú±ä»¯Ê±£¬¸ÃÐòÁÐÒ²ËæÖ®Ôö¼Ó¡£ÓÐͬÑùÖµµÄÐеõ½Í¬ÑùµÄÊý×ÖÐòºÅ£¨ÈÏΪnullʱÏàµÈµÄ£©¡£È»¶ø£¬Èç¹ûÁ½ÐеÄÈ·µÃµ½Í¬ÑùµÄÅÅÐò£¬ÔòÐòÊý½«ËæºóÌøÔ¾¡£ÈôÁ½ÐÐÐòÊýΪ1£¬ÔòûÓÐÐòÊý2£¬ÐòÁн«¸ø×éÖеÄÏÂÒ»ÐзÖÅäÖµ3£¬DENSE_RANKÔòûÓÐÈκÎÌøÔ¾
rank() over(partition by ... order by ...)
DENSE_RANK
¸ù¾ÝORDER BY×Ó¾äÖбí´ïʽµÄÖµ£¬´Ó²éѯ·µ»ØµÄÿһÐУ¬¼ÆËãËüÃÇÓëÆäËüÐеÄÏà¶ÔλÖá£×éÄÚµÄÊý¾Ý°´ORDER BY×Ó¾äÅÅÐò£¬È»ºó¸øÿһÐи³Ò»¸öºÅ£¬´Ó¶øÐγÉÒ»¸öÐòÁУ¬¸ÃÐòÁдÓ1¿ªÊ¼£¬ÍùºóÀÛ¼Ó¡£Ã¿´ÎORDER BY±í´ïʽµÄÖµ·¢Éú±ä»¯Ê±£¬¸ÃÐòÁÐÒ²ËæÖ®Ôö¼Ó¡£ÓÐͬÑùÖµµÄÐеõ½Í¬ÑùµÄÊý×ÖÐòºÅ£¨ÈÏΪnullʱÏàµÈµÄ£©¡£Ãܼ¯µÄÐòÁзµ»ØµÄʱûÓмä¸ôµÄÊý
dense_rank() over(partition by ... order by ...)
COUNT
¶ÔÒ»×éÄÚ·¢ÉúµÄÊÂÇé½øÐÐÀÛ»ý¼ÆÊý£¬Èç¹ûÖ¸¶¨*»òһЩ·Ç¿Õ³£Êý£¬count½«¶ÔËùÓÐÐмÆÊý£¬Èç¹ûÖ¸¶¨Ò»¸ö±í´ïʽ£¬count·µ»Ø±í´ïʽ·Ç¿Õ¸³ÖµµÄ¼ÆÊý£¬µ±ÓÐÏàֵͬ³öÏÖʱ£¬ÕâЩÏàµÈµÄÖµ¶¼»á±»ÄÉÈë±»¼ÆËãµÄÖµ£»¿ÉÒÔʹÓÃDISTINCTÀ´¼Ç¼ȥµôÒ»×éÖÐÍêÈ«ÏàͬµÄÊý¾Ýºó³öÏÖµÄÐÐÊý
count(...) over(partition by ... order by ...)
MAX
ÔÚÒ»¸ö×éÖеÄÊý¾Ý´°¿ÚÖвéÕÒ±í´ïʽµÄ×î´óÖµ
max(...) over(partition by ... order by ...)
MIN
ÔÚÒ»¸ö×éÖеÄÊý¾Ý´°¿ÚÖвéÕÒ±í´ïʽµÄ×îСֵ
min(...) over(partition by ... order by ...)
SUM
¸Ãº¯Êý¼ÆËã×éÖбí´ïʽµÄÀÛ»ýºÍ
sum(...) over(partition by ... order by ...)
AVG
ÓÃÓÚ¼ÆËãÒ»¸ö×éºÍÊý¾Ý´°¿ÚÄÚ±í´ïʽµÄƽ¾ùÖµ
avg(...) over(partition by ... order by ...)
FIRST_VALUE
·µ»ØÊý¾Ý×éÖеÚÒ»¸öÖµ
first_value(...) over(partition by ... order by ...)
LAST_VALUE
·µ»ØÊý¾Ý×éÖÐ×îºóÒ»¸öÖµ
last_value(...) over(partition by ... order by ...)
LAG
¿ÉÒÔ·ÃÎʽá¹û¼¯ÖеÄÆäËüÐжø²»ÓýøÐÐ×ÔÁ¬½Ó¡£ËüÔÊÐíÈ¥´¦ÀíÓα꣬¾ÍºÃÏñÓαêÊÇÒ»¸öÊý×éÒ»Ñù¡£ÔÚ¸ø¶¨×éÖпɲο¼µ±Ç°ÐÐ֮ǰµÄÐУ¬ÕâÑù¾Í¿ÉÒÔ´Ó×éÖÐÓ뵱ǰÐÐÒ»ÆðÑ¡ÔñÒÔÇ°µÄÐС£OffsetÊÇÒ»¸öÕýÕûÊý
Ïà¹ØÎĵµ£º
²©ÑåÅàѵ²¿ÊǹúÄÚΨһĿǰµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
Ä¿Ç°£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒƶ¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......
×°ÁËÒ»Ò¹µÄÈí¼þ£¬ÏÈÊÇMySQL£¬myEclipse,Oracle ,²»¶ÏµÄ³ö´í£¬OracleServise²»ÄÜÆô¶¯£¬ºÜÊÇ·³ÈË£¬Ð¶ÔØÁËOracelÁ½´Î£¬ÓÖÖØ×°£¬´íÎóµÃµ½Ò»Ð©½â¾ö£¬×¢²á±í³öÏÖÁ˺öàµÄÎÊÌ⣬ÒÔÇ°ÔÚжÔØÈí¼þµÄʱºò£¬¶¼Ã»ÓÐÓÃרÓõŤ¾ß£¬×¢²á±íÒ»ÍÅÂÒ£¬ÕæÊÇÏ൱µÄºó»Ú£¬ÏÖÔÚ¿´À´ÒªÏë¸Ä¹ýÀ´È·ÊµÊǺÜÄѵÄÀ²£¡ÒÔºóÕâ·½ÃæÒª¶à¼ ......
£¨1£©²éѯC01¿Î³Ì³É¼¨²»ÎªNullµÄѧÉúµÄÐÕÃûºÍ³É¼¨¡£
·ÖÎö£ºÒòΪÉæ¼°µ½¿Î³Ì³É¼¨ºÍѧÉúÐÕÃû£¬ÐèÒª¶Ôstudent±íºÍsc±í½øÐÐÁ¬½Ó¡£
´úÂ룺
select sname,grade from student,sc where student.sno=sc.sno and c ......
ÔÚÐéÄâ»úRed Hat Enterprise Linux 4 update 4Öа²×°oracle 10.2.0.1
1)²é¿´ÏµÍ³ÄÚ´æ
[root@linux4 ~]# grep MemTotal /proc/meminfo
2)²é¿´½»»»Çø´óС
[root@linux4 ~]# grep SwapTotal /proc/meminfo
3)
²é¿´/tmpĿ¼´óС
[root@linux4 ~]# df -m /tmp
4)²é¿´²Ù×÷ϵͳ°æ±¾
[root@linux4 ~]# cat /etc/issue
5)¼ ......
°ì·¨Ò»
select * from V$NLS_PARAMETERS
$conn = oci_connect('scott', 'donkey', 'demo', 'zhs16gbk');
while ($dat = oci_fetch_row($cur)) {
print_r(iconv('gb2312', 'utf-8', $dat[0])); //$nickname = mb_convert_encoding($dat[0], 'utf-8', 'gbk');&n ......