Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

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

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

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ