oracleÖг£Óú¯Êý´óÈ«
1¡¢ÊýÖµÐͳ£Óú¯Êý
¡¡
¡¡º¯Êý¡¡¡¡·µ»ØÖµ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÑùÀý¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÏÔʾ
ceil(n) ´óÓÚ»òµÈÓÚÊýÖµnµÄ×îСÕûÊý¡¡¡¡select ceil(10.6) from dual; 11
floor(n) СÓÚµÈÓÚÊýÖµnµÄ×î´óÕûÊý¡¡ select ceil(10.6) from dual; 10
mod(m,n) m³ýÒÔnµÄÓàÊý,Èôn=0,Ôò·µ»Øm select mod(7,5) from dual; 2
power(m,n) mµÄn´Î·½¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ select power(3,2) from dual; 9
round(n,m) ½«nËÄÉáÎåÈë,±£ÁôСÊýµãºómλ¡¡¡¡select round(1234.5678,2) from dual; 1234.57
sign(n) Èôn=0,Ôò·µ»Ø0,·ñÔò,n>0,Ôò·µ»Ø1,n<0,Ôò·µ»Ø-1 select sign(12) from dual; 1
sqrt(n) nµÄƽ·½¸ù¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡select sqrt(25) from dual ; 5
2¡¢³£ÓÃ×Ö·ûº¯Êý
initcap(char) °Ñÿ¸ö×Ö·û´®µÄµÚÒ»¸ö×Ö·û»»³É´óд¡¡¡¡select initicap('mr.ecop') from dual; Mr.Ecop
lower(char) Õû¸ö×Ö·û´®»»³ÉСд¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡select lower('MR.ecop') from dual; mr.ecop
replace(char,str1,str2) ×Ö·û´®ÖÐËùÓÐstr1»»³Éstr2 select replace('Scott','s','Boy') from dual; Boycott
substr(char,m,n) È¡³ö´Óm×Ö·û¿ªÊ¼µÄn¸ö×Ö·ûµÄ×Ó´®¡¡¡¡select substr('ABCDEF',2,2) from dual; CD
length(char) Çó×Ö·û´®µÄ³¤¶È¡¡¡¡¡¡¡¡select length('ACD') from dual; 3
|| ²¢ÖÃÔËËã·û¡¡¡¡¡¡ select 'ABCD'||'EFGH' from dual; ABCDEFGH
3¡¢ÈÕÆÚÐͺ¯Êý
sysdate µ±Ç°ÈÕÆÚºÍʱ¼ä select sysdate from dual;
last_day ¡¡±¾ÔÂ×îºóÒ»Ìì select last_day(sysdate) from dual;
add_months(d,n)¡¡µ±Ç°ÈÕÆÚdºóÍÆn¸öÔ select add_months(sysdate,2) from dual;
months_between(d,n) ÈÕÆÚdºÍnÏà²îÔÂÊý select months_between(sysdate,to_date('20020812','YYYYMMDD')) from dual;
next_day(d,day) dºóµÚÒ»ÖÜÖ¸¶¨dayµÄÈÕÆÚ select next_day(sysdate,'Monday') from dual;
day ¸ñʽ¡¡¡¡ÓС¡¡¡'Monday' ÐÇÆÚÒ»¡¡¡¡'Tuesday' ÐÇÆÚ¶þ
'wednesday' ¡¡ÐÇÆÚÈý 'Thursday' ÐÇÆÚËÄ 'Friday' ÐÇÆÚÎå
'Saturday' ÐÇÆÚÁù 'Sunday' ÐÇÆÚÈÕ
4¡¢ÌØÊâ¸ñʽµÄÈÕÆÚÐͺ¯Êý
Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»£¬Èýλ select to_char(sysdate,'YYY') from dual;
Q ¼¾¶È,1-3ÔÂΪµÚÒ»¼¾¶È¡¡¡¡¡¡¡¡select to_char(sysdate,'Q') from dual;
MM ¡¡Ô·ÝÊý¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡select to_char(sysdate,'MM') from dual;
RM Ô·ݵÄÂÞÂ
Ïà¹ØÎĵµ£º
How to land your dream Oracle DBA job
By Don Burleson, Contributor
14 Jan 2010
If you look at the Help Wanted ads, some Oracle DBA jobs look very appealing, with salaries that rival those of engineers and other professionals. Some have starting salaries as high as $85,000, with senior Orac ......
ÔÚORACLEÊý¾Ý¿âÖÐ,ÐèÒª¶ÔSQLÓï¾ä½øÐÐÓÅ»¯µÄ»°ÐèÒªÖªµÀÆäÖ´Ðмƻ®,´Ó¶øÕë¶ÔÐԵĽøÐе÷Õû.ORACLEµÄÖ´Ðмƻ®µÄ»ñµÃÓм¸ÖÖ·½·¨,ÏÂÃæ¾ÍÀ´×ܽáÏÂ
1¡¢EXPLAINµÄʹÓÃ
Oracle RDBMSÖ´ÐÐÿһÌõSQLÓï¾ä£¬¶¼±ØÐë¾¹ýOracleÓÅ»¯Æ÷µÄÆÀ¹À¡£ËùÒÔ£¬Á˽âÓÅ»¯Æ÷ÊÇÈçºÎÑ¡Ôñ(ËÑË÷)·¾¶ÒÔ¼°Ë÷ÒýÊÇÈçºÎ±»Ê¹Óõ쬶ÔÓÅ»¯SQLÓï ......
Oracle Application Development Framework
¡¡¡¡
Oracle ADF
ÊÇÒ»¸ö¶Ëµ½¶ËµÄ
J2EE
¿ò¼Ü£¬Ëüͨ¹ýÌṩÏֳɵĻù´¡¼Ü¹¹·þÎñÒÔ¼°¿ÉÊӵġ¢ÉùÃ÷ʽ¿ª·¢ÌåÑé¼ò»¯ÁË¿ª·¢¡£
ΪÁ˼ò»¯
J2EE
³ÌÐò¿ª·¢¸´ÔÓÐÔ¶ø×¨ÃÅ¿ª·¢µÄÒ»ÖÖ½â¾ö·½°¸¡£
ADF
......
ÔÎĵØÖ·£º
http://blog.sina.com.cn/s/blog_60e4205e0100esaf.html
ÕÒ³öÕýÔÚÖ´ÐеÄJOB±àºÅ¼°Æä»á»°±àºÅ
SELECT SID,JOB from
DBA_JOBS_RUNNING;
Í£Ö¹¸ÃJOBµÄÖ´ÐÐ
SELECT SID,SERIAL# from
V$SESSION WHERE ......
¹éµµÈÕÖ¾¼Ç¼×ÅÊý¾Ý¿âµÄ²Ù×÷¼Ç¼£¬ÊÇ×öÊý¾Ý»Ö¸´µÄÒÀ¾Ý£¬Èç¹ûÊý¾Ý¿â¿ªÆôÁ˹鵵ģʽ£¬ÄÇô¾Í»á²úÉú´óÁ¿µÄ¹éµµÈÕÖ¾£¬µ±È»Èç¹ûÓÐRMAN±¸·ÝµÄ»°£¬¿ÉÒÔÔÚ±¸·ÝÖ®ºóɾ³ýÒѾ±¸·Ý¹ýµÄÈÕÖ¾£¬Èç¹ûÊÇûÓвÉÓÃrman±¸·ÝµÄ»°£¬¾ÍÐèÒª×Ô¼ºÀ´É¾³ýÕâд¹éµµÈÕÖ¾¡£ ÏÂÃæµÄ¼¸¸ö½Å±¾¾Í¼õÇáÁËDBAµÄ¹¤×÷Á¿¡£
Linux ƽ̨:
0 2 * * * ......