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

postgresqlÀïÓÐûÓÐÏñoracleÖеÄÄÇÀà·ÖÎöº¯Êý?

postgresqlÀïÓÐûÓÐÏñoracleÖеÄÄÇÀà·ÖÎöº¯Êý?
Èç¹ûûÓеϰ,ÓÐûÓÐʲôÆäËû°ì·¨¿ÉÒÔʵÏÖÀàËÆ¹¦ÄÜÄØ?

¾ßÌåÊÇʲô·ÖÎöº¯Êý?

ÒýÓÃ
ÓÐÈçϺ¯Êý¡£

Function
row_number()
rank()
dense_rank()
percent_rank()
cume_dist()
ntile(num_buckets, integer)
lag(value, any [, offset, integer [, default, any ]])
lead(value, any [, offset, int¡­¡­
лл
ÎÒ¸ÕÊÔÁËÏÂrow_number()ÊÇÓеÄ
http://www.postgresql.org/docs/8.4/interactive/functions-window.html
¸Õ¸ÕÈ¥ËÑÁËһϠËѵ½ÁËÕâ¸öÁ´½Ó
²»¹ýÀïÃæÃ»ÓÐÿ¸öº¯Êý¸ü¼ÓÏêϸµÄ½²½â
ÇëÎÊÒ»ÏÂÓÖûÓÐʲôºÃµãµÄµØ·½»òÕßÎĵµ¿ÉÒÔѧϰPOSTGRESQL

ÒýÓÃ
¾ßÌåÊÇʲô·ÖÎöº¯Êý?
ºÇºÇ ÏÖÔÚµ¹»¹Ã»¾ßÌ嵽ij¸öº¯Êý
Ö»ÊÇ×î½ü¿ÉÄÜ»áÔÚGREENPLUMÉÏ×ö¿ª·¢
ÒÔǰ´ÓÀ´Ã»Óùý Ö»ÓùýORACLE
ËùÒÔÏÖÔÚÏë±È½Ïһ϶þÕߵIJ»Í¬Ö®´¦Ñ§Ï°Ñ§Ï°POSTGRESQLµÄÓï·¨

PS£ºÄãµÄС»¨¶àµÃ¹ý·Ö¡­¡­

ÇëÎÊÒ»ÏÂÓÖûÓÐʲôºÃµãµÄµØ·½»òÕßÎĵµ¿ÉÒÔѧϰPOSTGRESQL
Ö±½Óµ½PostgreSQL ¹ÙÍøÉÏÏÂÔØËüµÄÎĵµ¾ÍÐÐÁË£¬²»¹ý²»Èç£Ï£Ò£Á£Ì£Ã£ÅµÄÏêϸ¡£

Manuals

Release Online Version Downloadable Version 
8.4 •With user comments
•Without user comments
 •Comprehensive Manual: A4 PDF (17 MB)
•Comprehensive Manual: US PDF (17 MB)
•Windows help file (3.3 MB)
 
8.3 •With user comments
•Without user comments
 &


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

javaºÍoracle - °¤ÌßÖ°ÑÄ / ²ÅÈëÖ°³¡

±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ