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

ORACLE Rank, Dense_rank, row_number

Ŀ¼
======================================================
1.ʹÓÃrownumΪ¼Ç¼ÅÅÃû
2.ʹÓ÷ÖÎöº¯ÊýÀ´Îª¼Ç¼ÅÅÃû
3.ʹÓ÷ÖÎöº¯ÊýΪ¼Ç¼½øÐзÖ×éÅÅÃû
Ò»¡¢Ê¹ÓÃrownumΪ¼Ç¼ÅÅÃû£º
¡¾1¡¿²âÊÔ»·¾³£º
SQL> desc user_order;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
REGION_ID                                          NUMBER(2)
CUSTOMER_ID                                        NUMBER(2)
CUSTOMER_SALES                                     NUMBER
¡¾2¡¿²âÊÔÊý¾Ý£º
SQL> select * from user_order order by customer_sales;
REGION_ID CUSTOMER_ID CUSTOMER_SALES
---------- ----------- --------------
         5           1              151162
        10          29             903383
         6           7     &nb


Ïà¹ØÎĵµ£º

¹ØÓÚORACLE ORA

 ÓÉÓÚϵͳÒÆÖ²£¬Ô­À´µÄÊý¾Ý¿â±àÂëºÍʱÇø¶¼»»ÁË£¬Ô­À´µÄһЩSQLÎÄÒ²³ö´íÁË¡£¡£
¾­³£±À³ö"ORA-01846: not a valid day of the week
"´íÎó¡£
¾­²âÊÔ£¬ÒÔÏÂÕâ¸ö¼òµ¥Óï¾äÒ²»á´í£¡£¡
SQL> select next_day(sysdate,'FRIDAY') from DUAL;
 select next_day(sysdate,'FRIDAY') from DUAL
 ORA-01 ......

Oracle Êý×Öº¯ÊýÓ÷¨

 1. round(Num,n) :  ËÄÉáÎåÈëÊý×ÖNum£¬±£ÁônλСÊý£¬²»Ð´NĬÈϲ»ÒªÐ¡Êý£¬ËÄÉáÎåÈëµ½ÕûÊý¸öλ
 select ROUND(21.237,2) from dual; 
 ½á¹û£º 21.24
 2. trunc(Num,n) : ½ØÈ¡Êý×ÖNum£¬±£ÁônλСÊý£¬²»Ð´NĬÈÏÊÇ0£¬¼´²»ÒªÐ¡Êý
 select TRUNC(21.237,2) from dual;
 ½á¹û£º21.2 ......

ORACLEÈçºÎʹÓÃDBMS_METADATA.GET_DDL»ñÈ¡DDLÓï¾ä

1.µÃµ½Ò»¸ö±íµÄddlÓï¾ä£º
SET SERVEROUTPUT ON
SET LINESIZE 1000
SET FEEDBACK OFF
set long 999999             ------ÏÔʾ²»ÍêÕû
SET PAGESIZE 1000    ----·ÖÒ³
 
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.S ......

OracleÖ÷¼ü×Ô¶¯Ôö³¤

OracleÖ÷¼ü×Ô¶¯Ôö³¤
Õ⼸Ìì¸ãOracle£¬ÏëÈñíµÄÖ÷¼üʵÏÖ×Ô¶¯Ôö³¤£¬²éÍøÂçʵÏÖÈçÏ£º
create table simon_example
(
  id number(4) not null primary key,
  name varchar2(25)
)
-- ½¨Á¢ÐòÁУº
-- Create sequence
create sequence SIMON_SEQUENCE        &nb ......

¡¾ÊÕ²ØÕûÀí¡¿OracleÊý¾Ý¿âÌåϵ¼Ü¹¹

 Ô­Îļûhttp://blog.csdn.net/kele1121/archive/2009/10/30/4742051.aspxÓëhttp://www.itpub.net/thread-1105403-1-1.html
 Ëùν
Oracle
µÄÌåϵ¼Ü¹¹£¬ÊÇÖ¸
Oracle
Êý¾Ý¿â¹ÜÀíϵͳµÄµÄ×é³É²¿·ÖºÍÕâЩ×é³É²¿·ÖÖ®¼äµÄÏ໥¹Øϵ£¬°üÀ¨
ÄÚ´æ½á¹¹¡¢ºǫ́½ø³Ì¡¢ÎïÀíÓëÂß¼­½á¹¹µÈ¡£
Oracle
Êý¾Ý¿âµÄÌåϵºÜ¸´ÔÓ£¬¸´Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ