oracle³éÈ¡º¯Êý extract()
auhtor£ºskate
time£º2010/03/03
oracle³éÈ¡º¯Êý
½ñÌìÅóÓÑÎʸöÎÊÌ⣬ÈçºÎ³éȡʱ¼äµÄ“Сʱ”
oracleµÄ³éÈ¡º¯ÊýÊÇ extrac()Óï·¨:
SELECT EXTRACT(YEAR from SYSDATE) from DUAL; return Current Year
SELECT EXTRACT(MONTH from SYSDATE) from DUAL; return Current Month
SELECT EXTRACT(DAY from SYSDATE) from DUAL; return Current Day
SELECT EXTRACT(HOUR from TIMESTAMP '2010-10-10 10:10:10') from DUAL;
SELECT EXTRACT(MINUTE from TIMESTAMP '2010-10-10 10:10:10') from DUAL;
Àý×ÓÈçÏ£º
SQL> SELECT EXTRACT(YEAR from SYSDATE) from DUAL
2 ;
EXTRACT(YEARfromSYSDATE)
------------------------
2010
SQL> SELECT EXTRACT(month from SYSDATE) from DUAL
2 ;
EXTRACT(MONTHfromSYSDATE)
-------------------------
3
SQL> SELECT EXTRACT(day from SYSDATE) from DUAL;
EXTRACT(DAYfromSYSDATE)
-----------------------
3
SQL> SELECT EXTRACT(hour from SYSDATE) from DUAL;
SELECT EXTRACT(hour from SYSDATE) from DUAL
ORA-30076: ¶ÔÎö³öÀ´Ô´ÎÞЧµÄÎö³ö×Ö¶Î
SQL> SELECT EXTRACT(minute from SYSDATE) from DUAL;
SELECT EXTRACT(minute from SYSDATE) from DUAL
ORA-30076: ¶ÔÎö³öÀ´Ô´ÎÞЧµÄÎö³ö×Ö¶Î
SQL> SELECT EXTRACT(HOUR from TIMESTAMP '2010-10-10 10:10:10') from DUAL;
EXTRACT(HOURfromTIMESTAMP'2010
------------------------------
10
SQL> SELECT EXTRACT(minute from TIMESTAMP '2010-10-10 10:10:10') from DUAL;
EXTRACT(MINUTEfromTIMESTAMP'20
------------------------------
Ïà¹ØÎĵµ£º
ora-38301´íÎó,»ØÊÕÕ¾
Ç°¼¸ÌìÓÐͬʸæËßÎÒ£¬ÓÐ̨·þÎñÆ÷Éϵıí¿Õ¼äÎÞ·¨É¾³ý£¬ÈÃÎÒ¿´¿´¡£µÇ¼µ½·þÎñÆ÷£¬É¾³ý±í¿Õ¼ä£¬Êý¾Ý¿âͬʱ±¨ora-00604ºÍora-38301´íÎó¡£Æð³õÒÔΪÊÇÓÐÊý¾Ý¿â¶ÔÏó±»Ëø¶¨£¬ÖØÆôÊý¾Ý¿âºó£¬·¢ÏÖ»¹ÊDZ¨Í¬ÑùµÄ´íÎó¡£Googleºó·¢ÏÖ¿ÉÄÜÓë10gµÄÒ»¸öÐÂÌØÐÔ»ØÊÕÕ¾Óйأ¬Çå¿Õ»ØÊÕÕ¾purge recyclebinºó£¬½øÐÐɾ³ý»¹ÊDZ ......
ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3¡¢½«ÃÜÂëÓÐÐ ......
ÔÚoracleÖÐÅúÁ¿Êý¾ÝµÄµ¼³öÊǽèÖúsqlplusµÄspoolÀ´ÊµÏֵġ£ÅúÁ¿Êý¾ÝµÄµ¼ÈëÊÇͨ¹ýsqlloadÀ´ÊµÏֵġ£
´óÁ¿Êý¾ÝµÄµ¼³ö²¿·ÖÈçÏ£º
/***************************
* sql½Å±¾²¿·Ö demo.sql begin
**************************/
/**************************
* @author meconsea
* @date 20050 ......
Ò»¡¢Íü¼Ç³ýSYS¡¢SYSTEMÓû§Ö®ÍâµÄÓû§µÄµÇ¼ÃÜÂë¡£
ÓÃSYS (»òSYSTEM)Óû§µÇ¼¡£
CONN SYS/PASS_WORD AS SYSDBA;
ʹÓÃÈçÏÂÓï¾äÐÞ¸ÄÓû§µÄÃÜÂë¡£
ALTER USER user_name IDENTIFIED BY newpass;
......