Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

OracleµÄǰ¶ËÔ¼ÊøÊÇʲôÒâ˼

ÊéÉÏ˵ Ô¼Êø Ò»¹²ÓÐÁ½ÖÖ ÆäÖÐÒ»ÖÖǰ¶ËÔ¼ÊøÈçÏÂÃèÊö
ÓÐһЩ·½·¨¿ÉÒÔÓÃÓÚÖ´ÐÐǰ¶Ë£¨¼´ÓÃÓÚÊäÈëÊý¾ÝµÄÊäÈëÐÎʽÖУ©Ô¼Êø£¨¸ÃÊý¾Ý¿â³ÆÎªÏµÍ³ºó¶Ë£©

ǰ¶ËÔ¼Êø ÊÇʲôÒâ˼£¿

ÄÄλ´ó´óÂé·³ ½âÊÍÏ лл ¡£

ǰ¶ËÔ¼Êø:¿ÉÒÔÀí½â³É insert  ±í֮ǰµÄÔ¼Êø

Â¥ÉϵĴó´ó˵µÄ Ô¼Êø ÊÇ·ÅÔÚcreate ½Ðǰ¶ËÔ¼Êø £¬·ÅÔÚinsert µÄʱºòºó¶ËÔ¼Êø¡£
²»¹ýºóÀ´¿´Á˼¸±éÊéÉϵÄÒâ˼£¬Ç°¶ËÔ¼Êø ÊéÉϵĽâÊÍÊÇ ·ÅÔÚ¿Í»§¶ËµÄ java´úÂëÖеÄÊý¾ÝÔ¼Êø£¨»òÕßÊÇɸѡ´«³öÐèÒªÔ¶³Ì´«ÈëµÄÊý¾Ý£©¡£

лл¥ÉϵĻظ´


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

oracleʹÓÃutl_httpµÄÎÊÌâ

declare
  soap_request varchar2(30000);
  soap_respond varchar2(30000);
  http_req utl_http.req;
  http_resp utl_http.resp;

BEGIN
  soap_request:= ' ......

OracleµÄÔ¼ÊøÊÇ·ñ¿ÉÒÔ¸´ÓÃ

Oracle µÄ Ô¼ÊøÊÇÊÇ·ñ¿ÉÒÔ¸´Óã¿£¨µ÷ÓÃÔ¼ÊøÃû³Æ¾Í¿ÉÒÔÖ±½ÓʹÓøÃÔ¼Êø£©ÔÚÄÄÀï¿ÉÒÔ¹ÜÀíÔ¼Êø¡£
plsqlÓÐÕâ¸ö¹¦ÄÜô£¿


SQL code:
Ö±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraints

ÒýÓÃ
SQL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ