Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
 &


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

pl/sql - Oracle / ¿ª·¢

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

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

ÇóÒ»sqlÓï¾ä - Oracle / ¿ª·¢

Á½¸ö±í
Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
  
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º
name kemu shunxu
yiy ......

oracle ¿ÉÊÓ»¯¿´±íÄÚÈÝ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ°²×°ÁËoracle 10g¾­¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ