±±´óÇàÄñoracleѧϰ±Ê¼Ç3
»¹ÊǽèÖúoracle sql developerÀ´²Ù×÷oracle£¬sql plus»¹ÊÇÂé·³Ò»µã¡£
¼òµ¥¿´ÁËһϣ¬Óï¾ä»ù±¾É϶¼ºÍÆäËûÊý¾Ý¿âµÄsql²î²»¶à£¬¼Ç¼һϲ»Í¬µÄµØ·½¡£
ÈÕÆÚÀàÐͱà¼
update student set stu_birthday = to_date('2010-03-06 13:14:20','yyyy-MM-dd HH24:mi:ss');
ÐèҪʹÓÃto_date()º¯Êý£¬SQLÖв»Çø·Ö´óСд£¬MMºÍmm±»ÈÏΪÊÇÏàͬµÄ¸ñʽ´úÂ룬ËùÒÔOracleµÄSQL²ÉÓÃÁËmi´úÌæ·ÖÖÓ¡£
ÕâÀï·¢ÏÖ×¢ÊÍsqlʹÓÃ-- ¶ø²»ÊÇ//
ÕâÀïÉèÖÃÁËÈÕÆÚÒÔºóʹÓÃselectÃüÁî²é³öÀ´µÄ¸ñʽÊÇ 06-3Ô -10 ÕâÑù×ӵģ¬²»·ûºÏÏ°¹ß£¬¿ÉÒÔͨ¹ýÐ޸ĻỰµÄ·½Ê½¡£
alter session set NLS_date_format = 'yyyy-mm-dd';
Ð޸ĵ±Ç°»á»°µÄÈÕÆÚÏÔʾ¸ñʽ¡£ÐÞ¸ÄÍêºóselect½á¹û¾ÍÏÔʾΪ2010-03-06
Õª×Ôgoogle½á¹û£º
Êý¾ÝÀàÐÍ£¨datatype£©ÊÇÁУ¨column£©»ò´æ´¢¹ý³ÌÖеÄÒ»¸öÊôÐÔ¡£
OracleÖ§³ÖµÄÊý¾ÝÀàÐÍ¿ÉÒÔ·ÖΪÈý¸ö»ù±¾ÖÖÀࣺ×Ö·ûÊý¾ÝÀàÐÍ¡¢Êý×ÖÊý¾ÝÀàÐÍÒÔ¼°±íʾÆäËüÊý¾ÝµÄÊý¾ÝÀàÐÍ¡£
×Ö·ûÊý¾ÝÀàÐÍ
CHAR CHARÊý¾ÝÀàÐÍ´æ´¢¹Ì¶¨³¤¶ÈµÄ×Ó·ûÖµ¡£Ò»¸öCHARÊý¾ÝÀàÐÍ¿ÉÒÔ°üÀ¨1µ½2000¸ö×Ö·û¡£Èç¹û¶ÔCHARûÓÐÃ÷È·µØ˵Ã÷³¤¶È£¬ËüµÄĬÈϳ¤¶ÈÔòÉèÖÃΪ1.Èç¹û¶Ôij¸öCHARÀàÐͱäÁ¿¸³Öµ£¬Æ䳤¶ÈСÓڹ涨µÄ³¤¶È£¬ÄÇôOracle×Ô¶¯ÓÿոñÌî³ä¡£
VARCHAR2´æ´¢¿É±ä³¤¶ÈµÄ×Ö·û´®¡£ËäȻҲ±ØÐëÖ¸¶¨Ò»¸öVARCHAR2Êý¾Ý±äÁ¿µÄ³¤¶È£¬µ«ÊÇÕâ¸ö³¤¶ÈÊÇÖ¸¶Ô¸Ã±äÁ¿¸³ÖµµÄµÄ×î´ó³¤¶È¶ø·Çʵ¼Ê¸³Öµ³¤¶È¡£²»ÐèÒªÓÿոñÌî³ä¡£×î¶à¿ÉÉèÖÃΪ4000¸ö×Ö·û¡£
ÒòΪVARCHAR2Êý¾ÝÀàÐÍÖ»´æ´¢Îª¸ÃÁÐËù¸³µÄ×Ö·û£¨²»¼Ó¿Õ¸ñ£©£¬ËùÒÔVARCHAR2ÐèÒªµÄ´æ´¢¿Õ¼ä±ÈCHARÊý¾ÝÀàÐÍҪС¡£
OracleÍƼöʹÓÃVARCHAR2
NCHARºÍNVARCHAR2 NCHARºÍNVARCHAR2Êý¾ÝÀàÐÍ·Ö±ð´æ´¢¹Ì¶¨³¤¶ÈÓë¿É±ä³¤¶ÈµÄ×Ö·ûÊý¾Ý£¬µ«ÊÇËüÃÇʹÓõÄÊǺÍÊý¾Ý¿âÆäËûÀàÐͲ»Í¬µÄ×Ö·û¼¯¡£ÔÚ´´½¨Êý¾Ý¿âʱ£¬ÐèÒªÖ¸ ¶¨ËùʹÓõÄ×Ö·û¼¯£¬ÒÔ±ã¶ÔÊý¾Ý¿âÖÐÊý¾Ý½øÐбàÂë¡£»¹¿ÉÒÔÖ¸¶¨Ò»¸ö¸¨ÖúµÄ×Ö·û¼¯£Û¼´±¾µØÓïÑÔ¼¯£¨National Language Set£¬¼ò³ÆNLS£©£Ý¡£NCHARºÍNVARCHAR2ÀàÐ͵ÄÁÐʹÓø¨Öú×Ö·û¼¯¡£
ÔÚOracle9iÖУ¬¿ÉÒÔÒÔ×Ö·û¶ø²»ÊÇ×Ö½ÚΪµ¥Î»À´±íʾNCHARºÍNVARCHAR2Áеij¤¶È¡£
LONG LONGÊý¾ÝÀàÐÍ¿ÉÒÔ´æ·Å2GBµÄ×Ö·ûÊý¾Ý£¬ËüÊÇ´ÓÔçÆÚ°æ±¾Öм̳ÐÀ´µÄ¡£ÏÖÔÚÈç¹ûÏë´æ´¢´ó
Ïà¹ØÎĵµ£º
Òª½â¾öOracleµÄ¿Í»§¶ËÂÒÂëÎÊÌâ¹Ø¼üÊÇÒª°Ñ·þÎñÆ÷¶ËʹÓõÄ×Ö·û¼¯¸ú¿Í»§¶ËʹÓõÄ×Ö·û¼¯Í³Ò»ÆðÀ´¡£Oracle¿Í»§¶Ë£¨Sqlplus£©Í¨¹ýNLS_LANG»·¾³±äÁ¿À´È·¶¨¿Í»§¶ËʹÓõÄ×Ö·û¼¯¡£NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ ......
¾³£ÓÐͬÊÂ×ÉѯoracleÊý¾Ý¿â×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬ÈçÔÚ²»Í¬Êý¾Ý¿â×öÊý¾ÝǨÒÆ¡¢Í¬ÆäËüϵͳ½»»»Êý¾ÝµÈ£¬³£³£ÒòΪ×Ö·û¼¯²»Í¬¶øµ¼ÖÂǨÒÆʧ°Ü»òÊý¾Ý¿âÄÚÊý¾Ý±ä³ÉÂÒÂë¡£ÏÖÔÚÎÒ½«oracle×Ö·û¼¯Ïà¹ØµÄһЩ֪ʶ×ö¸ö¼òµ¥×ܽᣬϣÍû¶Ô´ó¼Ò½ñºóµÄ¹¤×÷ÓÐËù°ïÖú¡£
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯
¡¡¡¡Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ ......
< type="text/javascript">
document.body.oncopy = function() {
if (window.clipboardData) {
setTimeout(function() {
var text = clipboar ......
oracle 10.2.0.4 patchµÄÏÂÔصØÖ·Áбí
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://d ......