OracleÖм¸¸ö¹ØÓÚÈÕÆÚ·½ÃæµÄSQLʵÀý
¡í1:È¡µÃµ±Ç°ÈÕÆÚÊDZ¾Ôµĵڼ¸ÖÜ
SQL> select to_char(sysdate,'YYYYMMDD W HH24:MI:SS') from
dual;
TO_CHAR(SYSDATE,'YY
-------------------
20030327 4 18:16:09
SQL> select to_char(sysdate,'W') from dual;
T
-
4 ¡í2:È¡µÃµ±Ç°ÈÕÆÚÊÇÒ»¸öÐÇÆÚÖеĵڼ¸Ìì,×¢ÖØÐÇÆÚÈÕÊǵÚÒ»Ìì
SQL> select
sysdate,to_char(sysdate,'D') from dual;
SYSDATE T
--------- -
27-MAR-03 5 ÀàËÆ: select to_char(sysdate,'yyyy') from dual;
--Äê
select to_char(sysdate,'Q' from dual; --¼¾
select to_char(sysdate,'mm') from dual; --ÔÂ
select to_char(sysdate,'dd') from dual; --ÈÕ
ddd ÄêÖеĵڼ¸Ìì
WW ÄêÖеĵڼ¸¸öÐÇÆÚ
W ¸ÃÔÂÖеڼ¸¸öÐÇÆÚ
D ÖÜÖеÄÐÇÆÚ¼¸
hh Сʱ(12)
hh24 Сʱ(24)
Mi ·Ö
ss Ãë ¡í3:È¡µ±Ç°ÈÕÆÚÊÇÐÇÆÚ¼¸ÖÐÎÄÏÔʾ:
SQL> select
to_char(sysdate,'day') from dual;
TO_CHAR(SYSDATE,'DAY')
----------------------
ÐÇÆÚËÄ ¡í4:¼ÙÈçÒ»¸ö±íÔÚÒ»¸ödateÀàÐ͵Ä×Ö¶ÎÉÏÃæ½¨Á¢ÁËË÷Òý£¬ÈçºÎʹÓÃ
alter session
set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
¡í5: µÃµ½µ±Ç°µÄÈÕÆÚ
select sysdate from dual; ¡í6: µÃµ½µ±ÌìÁ賿0µã0·Ö0ÃëµÄÈÕÆÚ
select trunc(sysdate) from dual; -- µÃµ½ÕâÌìµÄ×îºóÒ»Ãë
select trunc(sysdate) + 0.99999 from dual; -- µÃµ½Ð¡Ê±µÄ¾ßÌåÊýÖµ
select trunc(sysdate) + 1/24 from dual; select trunc(sysdate) + 7/24
from dual; ¡í7:µÃµ½Ã÷ÌìÁ賿0µã0·Ö0ÃëµÄÈÕÆÚ
select trunc(sysdate+1)
from dual; select trunc(sysdate)+1 from dual;
¡í8: ±¾ÔÂÒ»ÈÕµÄÈÕÆÚ
select trunc(sysdate,'mm') from dual;
¡í9:µÃµ½ÏÂÔÂÒ»ÈÕµÄÈÕÆÚ
select trunc(add_months(sysdate,1),'mm') from dual; ¡í10:·µ»Øµ±Ç°ÔµÄ×îºó
Ò»Ìì?
select last_day(sysdate) from dual;
select last_day(trunc(sysdate)) from dual;
select trunc(last_day(sysdate)) from dual;
select trunc(add_months(sys
Ïà¹ØÎĵµ£º
1.Ñ¡Ôñ²Ù×÷µÄÊý¾Ý¿â
Á¬½Óµ½·þÎñÆ÷Ö®ºó£¬Ê×ÏÈÐèҪѡÔñÒª½øÐвÙ×÷µÄÊý¾Ý¿â¡£Ê¹ÓÃPHPµÄMSSQLÀ©Õ¹¿âÖеÄmssql_select_db()º¯Êý¼´¿ÉʵÏÖÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£¸Ãº¯Êý¸ñʽÈçÏ£º
bool mssql_select_db(string database_name[,resource link_identifier)
¸Ãº¯Êý¸÷²ÎÊýÒâÒ壺
a. ²ÎÊý database_nameΪָ¶¨µÄ·þÎñÆ÷ÉÏ¿ÉÓõÄÊý¾Ý ......
char¡¢varchar¡¢textºÍnchar¡¢nvarchar¡¢ntext
charºÍvarcharµÄ³¤¶È¶¼ÔÚ1µ½8000Ö®¼ä£¬ËüÃǵÄÇø±ðÔÚÓÚcharÊǶ¨³¤×Ö·ûÊý¾Ý£¬¶øvarcharÊDZ䳤×Ö·ûÊý¾Ý¡£Ëùν¶¨³¤¾ÍÊdz¤¶È¹Ì¶¨
µÄ£¬µ±ÊäÈëµÄÊý¾Ý³¤¶ÈûÓдﵽָ¶¨µÄ³¤¶Èʱ½«×Ô¶¯ÒÔÓ¢ÎĿոñÔÚÆäºóÃæÌî³ä£¬Ê¹³¤¶È´ïµ½ÏàÓ¦µÄ³¤¶È£»¶ø±ä ......
ÆôÓÃc2ÉóºËÃüÁîÈçÏ£º
EXEC sp_configure 'c2 audit mode', '1' RECONFIGURE
SQL ServerÒÔ128KB´óСµÄ¿éΪµ¥Î»°ÑÊý¾ÝдÈë¸ú×ÙÎļþ¡£Òò´Ë£¬µ±SQL Server·ÇÕý³£Í£Ö¹Ê±£¬×î¶à¿ÉÄܶªÊ§128
......
Îҵݲװ¹ý³Ì
1¡¢±à¼ /etc/apt/sources.list £º
sudo cp /etc/apt/sources.list /etc/apt/sources.list.bak #±¸·Ý
sudo gedit /etc/apt/sources.list
¼ÓÈëÏÂÃæÕâ¸öÔ´£º
deb http://oss.oracle.com/debian unst ......
1 ¡¢°²×°Ç°µÄ×¼±¸
1.1 ¼ì²éÓ²¼þ
ÎïÀíÄڴ棺 # grep MemTotal /proc/meminfo
½»»»¿Õ¼ä£º # grep SwapTotal /proc/meminfo
½»»»¿Õ¼äµÄ´óСÊǸù¾ÝÎïÀíÄÚ´æµÄ´óСÀ´ÉèÖõģ¬ÎïÀíÄÚ´æÉÙÓÚ 2G µÄÔò½»»»¿Õ¼äÉèΪÎïÀíÄÚ´æµÄÁ½±¶£¬ÎïÀíÄÚ´æ´óÓÚ 2G µÄÔò½»»»¿Õ¼äºÍÎïÀíÄÚ´æ´óСһÑù¡£Èç¹û²»·ûºÏÉÏÊö¹æ¶¨£¬ÄÇô¾ÍÐèÒªÖØÐÂÉèÖý ......