OracleµÄǰ¶ËÔ¼ÊøÊÇʲôÒâ˼
ÊéÉÏ˵ Ô¼Êø Ò»¹²ÓÐÁ½ÖÖ ÆäÖÐÒ»ÖÖǰ¶ËÔ¼ÊøÈçÏÂÃèÊö
ÓÐһЩ·½·¨¿ÉÒÔÓÃÓÚÖ´ÐÐǰ¶Ë£¨¼´ÓÃÓÚÊäÈëÊý¾ÝµÄÊäÈëÐÎʽÖУ©Ô¼Êø£¨¸ÃÊý¾Ý¿â³ÆÎªÏµÍ³ºó¶Ë£©
ǰ¶ËÔ¼Êø ÊÇʲôÒâ˼£¿
ÄÄλ´ó´óÂé·³ ½âÊÍÏ лл ¡£
ǰ¶ËÔ¼Êø:¿ÉÒÔÀí½â³É insert ±í֮ǰµÄÔ¼Êø
Â¥ÉϵĴó´ó˵µÄ Ô¼Êø ÊÇ·ÅÔÚcreate ½Ðǰ¶ËÔ¼Êø £¬·ÅÔÚinsert µÄʱºòºó¶ËÔ¼Êø¡£
²»¹ýºóÀ´¿´Á˼¸±éÊéÉϵÄÒâ˼£¬Ç°¶ËÔ¼Êø ÊéÉϵĽâÊÍÊÇ ·ÅÔÚ¿Í»§¶ËµÄ java´úÂëÖеÄÊý¾ÝÔ¼Êø£¨»òÕßÊÇɸѡ´«³öÐèÒªÔ¶³Ì´«ÈëµÄÊý¾Ý£©¡£
лл¥ÉϵĻظ´
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
declare
soap_request varchar2(30000);
soap_respond varchar2(30000);
http_req utl_http.req;
http_resp utl_http.resp;
BEGIN
soap_request:= ' ......
Oracle µÄ Ô¼ÊøÊÇÊÇ·ñ¿ÉÒÔ¸´Óã¿£¨µ÷ÓÃÔ¼ÊøÃû³Æ¾Í¿ÉÒÔÖ±½ÓʹÓøÃÔ¼Êø£©ÔÚÄÄÀï¿ÉÒÔ¹ÜÀíÔ¼Êø¡£
plsqlÓÐÕâ¸ö¹¦ÄÜô£¿
SQL code:
Ö±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraints
ÒýÓÃ
SQL ......