OracleÈÕÆÚº¯Êý£º
select sysdate from dual; ´Óα±í²éϵͳʱ¼ä£¬ÒÔĬÈϸñʽÊä³ö¡£
sysdate+(5/24/60/60) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
sysdate+5/24/60 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5·ÖÖÓ
sysdate+5/24 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Сʱ
sysdate+5 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ìì
ËùÒÔÈÕÆÚ¼ÆËãĬÈϵ¥Î»ÊÇÌì
round (sysdate,’day’) ²»ÊÇËijýÎåÈëÁË£¬ÊǹýÁËÖÐÎçÁôÏ£¬²»¹ýµÄÂÔµô
¸ñʽת»»º¯Êý£º
to_charÏÔʾÈÕÆÚ£º
´ÓÊý×Öת»¯Îªchar to_char(date,'¸ñʽ')
´ÓÈÕÆÚת»¯Îªchar to_char(date, 'fmt' )
select to_char(sysdate, 'yyyy mm dd hh24:mi:ss') from dual;
select to_char(sysdate, 'fmyyyy mm dd hh24:mi:ss') from dual;
²é³öÈýÔ·ÖÈëÖ°µÄÔ±¹¤£º
select first_name,start_date from s_emp where to_char(start_date,'mm')='03';
to_date±í´ïÈÕÆÚ£º
×Ö·ûתÈÕÆÚ
select to_date('2000 11 20', 'yyyy mm dd ') from dual;
select round(to_date('10-OCT-06' ,'dd-mon-RR') ) from dual;
to_number
×Ö·ûתÊý×Ö
select to_number('10') from dual ;
º¯Êý¡¢±í´ïʽ¡¢ÒþʽÊý¾ÝÀàÐÍת»»»áµ¼ÖÂË÷ÒýÓò»ÉÏ£¬whereÌõ¼þºóÃæÖ»Äܷŵ¥Ðк¯Êý£¬ËüÆðÁËÒ»¸ö¹ýÂ˵ĵÄ×÷Óá£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
½üÈÕÔÚѧϰOracle 10GµÄ¹ý³ÌÖÐÓöµ½Ò»¸öÎÊÌ⣬¹Ø±ÕÊý¾Ý¿â£¨shutdown immediate£©ºó£¬ÔÙÖØÆôÊý¾Ý¿â(startup)£¬Æô¶¯Ê§°Ü£¬12514µÄ´íÎó£¬Èç¹ûͨ¹ýsqlplus /nolog½øÈëÊý¾Ý¿âÒÔºó£¬ÓÃconnÁ¬½Ó£¬Ò»Ñù²»ÐС£ÖØдò¿ªÒ»¸öcmd´°¿Ú£¬ÊäÈ룺
sqlplus
Óû§Ãû£ºsys@sim as sysdba£¬ÃÜÂëÊäÈëÍê³Éºó£¬ÈÔÈ»³öÏÖÈçÏ´íÎó£º
ORA ......
ÔÚÊý¾Ý²Ö¿â»·¾³ÖУ¬ÎÒÃÇͨ³£ÀûÓÃÎﻯÊÓͼǿ´óµÄ²éѯÖØд¹¦ÄÜÀ´ÌáÉýͳ¼Æ²éѯµÄÐÔÄÜ£¬µ«ÊÇÎﻯÊÓͼµÄ²éѯÖØд¹¦ÄÜÓÐʱºòÎÞ·¨ÖÇÄܵØÅжϲéѯÖÐһЩÏà¹ØÁªµÄÌõ¼þ£¬ÒÔÖÁÓÚÓ°ÏìÐÔÄÜ¡£±ÈÈçÎÒÃÇÓÐÒ»ÕÅÏúÊÛ±ísales£¬ÓÃÓÚ´æ´¢¶©µ¥µÄÏêϸÐÅÏ¢£¬°üº¬½»Ò×ÈÕÆÚ¡¢¹Ë¿Í±àºÅºÍÏúÊÛÁ¿¡£ÎÒÃÇ´´½¨Ò»ÕÅÎﻯÊÓͼ£¬°´Ô´洢ÀÛ¼ÆÏúÁ¿ÐÅÏ¢£¬¼ ......
INºÍEXISTSÇø±ð
in ÊÇ°ÑÍâ±íºÍÄÚ±í×÷hash join£¬¶øexistsÊǶÔÍâ±í×÷loop£¬Ã¿´ÎloopÔÙ¶ÔÄÚ±í½øÐвéѯ¡£
Ò»Ö±ÒÔÀ´ÈÏΪexists±ÈinЧÂʸߵÄ˵·¨ÊDz»×¼È·µÄ¡£
Èç¹û²éѯµÄÁ½¸ö±í´óСÏ൱£¬ÄÇôÓÃinºÍexists²î±ð²»´ó¡£
Èç¹ûÁ½¸ö±íÖÐÒ»¸ö½ÏС£¬Ò»¸öÊÇ´ó±í£¬Ôò×Ó²éѯ±í´óµÄÓÃexists£¬×Ó²éѯ±íСµÄÓÃin£º
ÀýÈ磺±íA£¨Ð¡±í£©£¬±íB ......
ÓÉÓÚϵͳÒÆÖ²£¬ÔÀ´µÄÊý¾Ý¿â±àÂëºÍʱÇø¶¼»»ÁË£¬ÔÀ´µÄһЩ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 ......