Oracle ¿ª·¢³£¼ûÎÊÌâ
1£®Êýѧº¯Êý
¢Ù¾ø¶ÔÖµ
l S£ºselect abs(-1) value
l O£ºselect abs(-1) value from dual
¢ÚÈ¡Õû(´ó)
l S£ºselect ceiling(-001) value
l O£ºselect ceil(-001) value from dual
¢ÛÈ¡Õû£¨Ð¡£©
l S£ºselect floor(-001) value
l O£ºselect floor(-001) value from dual
¢ÜÈ¡Õû£¨½ØÈ¡£©
l S£ºselect cast(-002 as int) value
l O£ºselect trunc(-002) value from dual
¢ÝËÄÉáÎåÈë
l S£ºselect round(23456,4) value 23460
l O£ºselect round(23456,4) value from dual 2346
¢ÞeΪµ×µÄÃÝ
l S£ºselect Exp(1) value l O£ºselect Exp(1) value from dual
¢ßÈ¡eΪµ×µÄ¶ÔÊý
l S£ºselect log(7182818284590451) value
l O£ºselect ln(7182818284590451) value from dual;
¢àÈ¡10Ϊµ×¶ÔÊý
l S£ºselect log10(10) value
l O£ºselect log(10,10) value from dual;
¢áȡƽ·½
l S£ºselect SQUARE(4) value
l O£ºselect power(4,2) value from dual
¢âȡƽ·½¸ù l S£ºselect SQRT(4) value
l O£ºselect SQRT(4) value from dual
ÇóÈÎÒâÊýΪµ×µÄÃÝ
l S£ºselect power(3,4) value
l O£ºselect power(3,4) value from dual
È¡Ëæ»úÊý
l S£ºselect rand() value
l O£ºselect sys.dbms_random.value(0,1) value from dual;
È¡·ûºÅ
l S£ºselect sign(-8) value -1
l O£ºselect sign(-8) value from dual -1
2£®ÊýÖµ±È½Ï
¢ÙÇ󼯺Ï×î´óÖµ l S£ºselect max(value) value from
(select 1 value union
select -2 value union
select 4 value union
&n
Ïà¹ØÎĵµ£º
2.¸ù¾ÝOracle Êý¾Ý¿âscott ģʽϵÄemp ±íºÍdept ±í£¬Íê³ÉÏÂÁвÙ×÷£º
(1) ²éѯ20ºÅ²¿ÃŵÄËùÓÐÔ±¹¤ÐÅÏ¢£»
(2) ²éѯËùÓй¤ÖÖΪCLERK µÄÔ±¹¤µÄÔ±¹¤ºÅ¡¢Ô±¹¤ÃûºÍ²¿Ãźţ»
(3) ²éѯ½±½ðCOMM ¸ßÓÚ¹¤×ÊSAL µÄÔ±¹¤ÐÅÏ¢£»
  ......
ÔÚORACLE ´óÊý¾ÝÁ¿ÏµķÖÒ³½â¾ö·½·¨¡£Ò»°ãÓýØÈ¡ID ·½·¨£¬»¹ÓÐÊÇÈý²ã ǶÌ×·½·¨
Ò»ÖÖ·ÖÒ³·½·¨
<%
int i = 1;
int numPages = 14;
String pages = request.getParameter("page");
int currentPage = 1;
cu ......
ÊÕ¼¯µÄ¼¸ÌõÔÚoracleÖÐͨ¹ýconnect by priorÀ´ÊµÏֵݹé²éѯ
Start with...Connect By×Ó¾äµÝ¹é²éѯһ°ãÓÃÓÚÒ»¸ö±íά»¤Ê÷ÐνṹµÄÓ¦Óá£
´´½¨Ê¾Àý±í£º
CREATE TABLE TBL_TEST
(
ID NUMBER,
NAME VARCHAR2(100 BYTE),
PID NUMBER ......
¡¡¡¡decode()º¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£
DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£DECODEÓÐÊ²Ã´Ó ......