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

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË


ͬÒ⣬Oracle »á×Ô¼º½â¾öÕâЩÎÊÌ⣬ÎÒÃÇÖ»ÐèҪͨ¹ýSQL ÃüÁîÀ´²Ù×÷¾Í¿ÉÒÔÁË..






------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716

PROCEDURE USP_S_LR_DENGJIK(DENGJIBH_IN IN LR_DENGJIK.DENGJIBH%TYPE,
  GERENBH_IN IN LR_DENGJIK.GERENBH%TYPE,
  JUMINBH_IN IN LR_DENGJIK.JUMINBH%TYPE,
  JUZHULX_IN IN LR_DENGJIK.JUZHULX%TYPE,
  LIANXIR_IN IN LR_DENGJIK.LIANXIR%TYPE,
  LIANXIDH_IN IN LR_DENGJIK.LIANXIDH%TYPE,
  LAONIANZ_IN IN LR_DENGJIK.LAONIANZ%TYPE,
  SHENGHUOSY_IN IN LR_DENGJIK.SHENGHUOSY%TYPE,
  ZILINL_IN IN LR_DENGJIK.ZILINL%TYPE,


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

sqlËÙ¶ÈÂýµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

select a.exec_sqn, a.dept_code 
  from ipmonmex a, lis_test_reg b 
where a.exec_sqn = b.exec_sqn 
  and b.barcode = '1002052716' 
Ö´ÐÐËٶȵÄ2·ÖÖÓ×óÓÒ£¬ÊµÔÚÊÇ̫ ......

oracle 10µÄÊý¾Ý¿âÇ¨ÒÆ¡£¡£¡£¼± - Oracle / ¿ª·¢

»¹Çó¸öoracleÊý¾Ý¿âµ¼³ö±í¸ñ£¬´æ´¢¹ý³Ì£¬ÒÔ¼°µ¼³ö´¥·¢Æ÷Ö®ÀàµÄ·½·¨¡£
ÒÔ¼°µ¼Èë¡£¡£¡£
Õâô˵°É£¬¾ÍÊÇoracle 10µÄÊý¾Ý¿âÇ¨ÒÆ¡£¡£¡£
·Ç³£¸Ðл

Ò²¾ÍÊÇ£¬ÎÒÔÚÒ»¸ö»úÆ÷ÉÏÓÐÁËÊý¾Ý¿â£¬Òª°ÑÕâ¸öÊý¾Ý¿â×ªÒÆµ½ÁíÍâÒ»¸ö° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ