OracleµÄǰ¶ËÔ¼ÊøÊÇʲôÒâ˼
ÊéÉÏ˵ Ô¼Êø Ò»¹²ÓÐÁ½ÖÖ ÆäÖÐÒ»ÖÖǰ¶ËÔ¼ÊøÈçÏÂÃèÊö
ÓÐһЩ·½·¨¿ÉÒÔÓÃÓÚÖ´ÐÐǰ¶Ë£¨¼´ÓÃÓÚÊäÈëÊý¾ÝµÄÊäÈëÐÎʽÖУ©Ô¼Êø£¨¸ÃÊý¾Ý¿â³ÆÎªÏµÍ³ºó¶Ë£©
ǰ¶ËÔ¼Êø ÊÇʲôÒâ˼£¿
ÄÄλ´ó´óÂé·³ ½âÊÍÏ лл ¡£
ǰ¶ËÔ¼Êø:¿ÉÒÔÀí½â³É insert ±í֮ǰµÄÔ¼Êø
Â¥ÉϵĴó´ó˵µÄ Ô¼Êø ÊÇ·ÅÔÚcreate ½Ðǰ¶ËÔ¼Êø £¬·ÅÔÚinsert µÄʱºòºó¶ËÔ¼Êø¡£
²»¹ýºóÀ´¿´Á˼¸±éÊéÉϵÄÒâ˼£¬Ç°¶ËÔ¼Êø ÊéÉϵĽâÊÍÊÇ ·ÅÔÚ¿Í»§¶ËµÄ java´úÂëÖеÄÊý¾ÝÔ¼Êø£¨»òÕßÊÇɸѡ´«³öÐèÒªÔ¶³Ì´«ÈëµÄÊý¾Ý£©¡£
лл¥ÉϵĻظ´
Ïà¹ØÎÊ´ð£º
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÎÒÏëÔÚÊý¾Ý±íÖвåÈëһЩÈÕÆÚÊý¾Ý¡£·Ö±ðÓÐyear week start_date end_date ¶¼´ú±í×ÅÊÇʲôÄê·Ý¡£ÔÚÕâÒ»ÄêÀïµÄµÚ¼¸¸öÖÜÆÚ¡£¿ªÊ¼Ê±¼äÊǼ¸Ô¼¸ºÅ µ½¼¸Ô¼¸ºÅ£¨Àý£º2009 1 2008-12-28 2009-1-3£©ÒòΪҪ²åÈëÒ»ÄêµÄÊý¾ÝÈç¹ûÒ ......
Ò»¶Ô¶à¹ØÏµ²éѯ
±í:
ea,eb,ga,gb
±í¹ØÏµÈçÏÂ
ea1=eb1
ga1=gb1
eb1=gb31 and eb3 = gb33
ÊÂÀýÊý¾Ý¼°¹ØÏµÈçÏÂ:
SQL code:
SELECT ea1, eb3, gb1, gb3, gb31, gb33
from (S ......
ΪʲôÔÚwindows7ÉÏ×°²»ÉÏoracleÊý¾Ý¿â£¿£¿£¿
ÒòΪ²»Ö§³Ö
¿ÉÒÔ°²×°Êý¾Ý°¡£¬ ÄãÓõÄÄǸö°æ±¾µÄWindows 7°¡£¬Ä¿Ç°7600µÄ¼æÈÝÐÔÓкܴóÌáÉýÁË£¬£¬ÎÒÊÇÓÃSQL Sever 2005£¬¾ÍûÓÐÎÊÌ⣬oracleÓ¦¸ÃÒ²¿ÉÒԵģ¬Èç¹û²» ......
select sname,(2009-10-05)-birth
from student;
birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿
¼ÓÉÏdatediffº¯ÊýÊÔÊÔ
select sname, to_char(sysdate,'YYYY')- to_char( ......