oracleÖÐtimestampÎÊÌâ
ÎÊÌâÃèÊö£º
µ±Êý¾Ý¿âµÄ×Ö·û¼¯ÎªÖÐÎÄʱ£¬timestampÀàÐ͵Ä×Ö¶ÎΪÒÔϸñʽ£º
04-3ÔÂ -10 03.57.41.631000 ÏÂÎç
ÎÒÔÚÓÃJDOM½«Êý¾Ýµ¼³öΪXMLʱ£¬timestampÀàÐÍ×ֶεÄÖµ·´ÉúÁ˱仯£¬±ä³ÉÁËһϸñʽ
<CREATE_DATE>2010-3-4.15.57. 30. 505000000</CREATE_DATE>
½â¾ö·½°¸£º
ÔÚ²éѯ¸Ã×Ö¶ÎʱÊ×ÏÈÓÃto_char£¨£©º¯Êý½«Æäת»»Îª×Ö·û´®¸ñʽ¼´¿É
Ïà¹ØÎĵµ£º
ÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬½¨Á¢ÁËÒ»¸öÓû§test£¬È»ºóʹÓÃÃüÁîdrop user test cascadeɾ³ýÁËÓû§£¬½Ó×ÅҲɾ³ýÁËÕâ¸öÓû§µÄÊý¾ÝÎļþ/opt/oracle/oradata/test/testdata.dbf¡£µ±ÔڵǼÊý¾Ý¿âʱ£¬Äܹ»Æô¶¯ÊµÀý£¬µ«ÊÇ´ò²»¿ªÊý¾Ý¿â£¬ÏµÍ³±¨´í£º
ORA-01157: c ......
author£ºskate
time£º2010/03/03
oracle³£ÓÃÊý¾ÝÀàÐÍ
½ñÌìͬÊÂÎÊЩÊý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓеĻ¹ÕæÓеã¼Ç²»ÇåÁË£¬ÓÚÊǾͼòµ¥×ܽáϳ£ÓõÄÊý¾ÝÀàÐÍÒÔ±¸ÈÕºó²éÓÃ
1¡¢Char
¶¨³¤¸ñʽ×Ö·û´®£¬ÔÚÊý¾Ý¿âÖд洢ʱ²»×ãλÊýÌî²¹¿Õ¸ñ£¬ËüµÄÉùÃ÷·½Ê½ÈçÏÂCHAR(L)£¬LΪ×Ö·û´®³¤¶È£¬
ȱʡΪ1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORA ......
Ò»¡¢ÐèÒª²éѯµÄÊý¾Ý
1
¡¢²éѯ³öÔÂн´óÓÚ
'SMITH'
µÄËùÓÐÔ±¹¤×ÊÁÏ
select *from emp where
sal>(select sal from emp where name="SMITH");
2
¡¢²éѯËùÓÐÔ±¹¤µÄÐÕÃû¼°Áìµ¼ÐÕÃû
select e1.ename,e2.ename from
emp e1,emp e2 where e1.mgr=e2.empno(+);
3
......
ת×Ô£ºhttp://hi.baidu.com/magus163/blog/item/a4f783178e39ef00c93d6de6.html
¡¾ÕâƪÎÄÕÂÀý×Ó½²½âµÄ±È½ÏÏêϸ£¬ÎÒ¾Íת¹ýÀ´ÁË¡¿
Oracle9iÒýÈëÁËMERGEÃüÁî,ÄãÄܹ»ÔÚÒ»¸öSQLÓï¾äÖжÔÒ»¸ö±íͬʱִÐÐinsertsºÍupdates²Ù×÷. MERGEÃüÁî´ÓÒ»¸ö»ò¶à¸öÊý¾ÝÔ´ÖÐÑ¡ÔñÐÐÀ´updating»òinsertingµ½Ò»¸ö»ò¶à¸ö±í.
Oracle 10gÖÐMERGEÓÐÈ ......