һЩoracleµÄÃüÁî¼°º¯Êý °üÀ¨decodeµÈ
1¡¢set linesize 100; ÉèÖó¤¶È
2¡¢set pagesize 30; ÉèÖÃÿҳÏÔʾÊýÄ¿
3¡¢em a.sql ´ò¿ª¼Çʱ¾
4¡¢@ a Ö´ÐÐÎļþaÖеĴúÂ룬¿ÉÖ¸¶¨ÎļþµÄ·¾¶ @d:a.txt
5¡¢conn Óû§Ãû/ÃÜÂë ¸ù¾ÝÓû§ÃûºÍÃÜÂëÁ¬½ÓÊý¾Ý¿â Èç¹ûÁ¬½Ó³¬¼¶¹ÜÀíÔ±(sys) ÔòÓ¦¼ÓÉÏas sysdba;
6¡¢show user; ÏÔʾµ±Ç°Á¬½ÓµÄÓû§
7¡¢select * from tab; µÃµ½µ±Ç°Óû§ÏµÄËùÓбí
8¡¢desc temp; ²é¿´±í½á¹¹
9¡¢/ ¼ÌÐøÖ´ÐÐÉÏÒ»¸ö²éѯÓï¾ä
clear scr; ÇåÆÁ
×Ö·ûº¯Êý
10¡¢select upper('coolszy') from dual; ½«Ð¡Ð´×Öĸת»»³É´óд£¬dual ΪһÐé±í
11¡¢select lower('KUKA') from dual; ½«´óд×Öĸת»»³ÉСд
12¡¢select initcap('kuka') from dual; ½«Ê××Öĸ´óд
13¡¢select concat('Hello',' world') from dual; Á¬½Ó×Ö·û´®£¬µ«Ã»ÓÐ||ºÃÓÃselect concat('Hello','world') from dual;
14¡¢select substr('hello',1,3) from dual; ½ØÈ¡×Ö·û´®
15¡¢select length('hello') from dual; Çó×Ö·û´®³¤¶È
16¡¢select replace('hello','l','x') from dual; Ìæ»»×Ö·û´®
17¡¢select substr('hello',-3,3) from dual; ½ØÈ¡ºóÈýλ
ÊýÖµº¯Êý
18¡¢select round(789.536) from dual; ËÄÉáÎåÈ룬ÉáȥСÊý
19¡¢select round(789.536,2) from dual; ±£ÁôÁ½Î»Ð¡Êý
20¡¢select round(789.536,-1) from dual; ¶ÔÕûÊý½øÐÐËÄÉáÎåÈë
21¡¢select trunc(789.536) from&n
Ïà¹ØÎĵµ£º
Ò».OracleÊý¾Ý¿âÖг£ÓõÄÊý¾ÝÀàÐÍ
varchar2(³¤¶È)¿É±ä³¤×Ö·û´®
char(³¤¶È) ¶¨³¤
number()±íʾÕûÊý»òÕ߸¡µãÊýnumber(8) number(8,2)
clog ×Ö·ûµÄ´ó¶ÔÏó
blog ¶þ½øÖƵĴó¶ÔÏó
¶þ.Êý¾Ý¿â²éѯ
1£©SELECTÓï¾ä
´Ó±íÖÐÌáÈ¡²éѯÊý¾Ý.Ó﷨ΪSELECT [DISTINCT] {column1,column2,…} from tablename WHERE {con ......
OracleÖÐKill sessionµÄÑо¿
×÷Õߣºeygle |English Version ¡¾×ªÔØÊ±ÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2004/06/kill_session.html
ÎÒÃÇÖªµÀ,ÔÚOracleÊý¾Ý¿âÖÐ,¿ÉÒÔͨ¹ýkill sessionµÄ·½Ê½À´ÖÕÖ¹Ò»¸ö½ø³Ì,Æä»ù±¾Óï·¨½á¹¹Îª:
alter system kill session 'sid,serial# ......
Oracle³£Ó÷ÖÎöº¯Êý
ROW_NUMBER
·µ»ØÓÐÐò×éÖÐÒ»ÐÐµÄÆ«ÒÆÁ¿£¬´Ó¶ø¿ÉÓÃÓÚ°´Ìض¨±ê×¼ÅÅÐòµÄÐкÅ
row_number() over(partition by ... order by ...)
RANK
¸ù¾ÝORDER BY×Ó¾äÖбí´ïʽµÄÖµ£¬´Ó²éѯ·µ»ØµÄÿһÐУ¬¼ÆËãËüÃÇÓëÆäËüÐеÄÏà¶ÔλÖá£×éÄÚµÄÊý¾Ý°´ORDER BY×Ó¾äÅÅÐò£¬È»ºó¸øÃ¿Ò»Ðи³Ò»¸öºÅ£¬´Ó¶øÐγÉÒ»¸öÐòÁУ¬¸ÃÐòÁ ......