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 &
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇ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 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......