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

oracle 11g r2µÄ»î¶¯»á»°ÊýÎÊÌâ

oracle 11g r2µÄ»î¶¯»á»°Êý,ÓÐʱºòͻȻµÈ´ýÁ¿¾ÍÉÏÀ´ÁË.ÔÚÓ¦ÓóÌÐòÖÐÖ´ÐÐÔöɾ¸Ä»áÏ൱Âý..

  ¹Û²ìÁ˼¸Ìì,µ±ÓÐÈËÅúÁ¿µ¼Èë»òµ¼³öÊý¾Ý,Èçexcel(1000Ìõ×óÓÒ)ͨ¹ýjxl½âÎöÈ»ºójdbcÖ´ÐÐupdateµ½Êý¾Ý¿âÖÐ,´Ëʱ,»î¶¯»á»°ÊýµÄµÈ´ýÁ¿¾ÍÃÍÔö,ϵͳÕûÌå±äÂý.
  µ«ÊDz»ÖªµÀΪʲô
  ÒÔÏÂÎÒÁгöÎÒ¿¼Âǵ½µÄora¼òµ¥²ÎÊý:

SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- -------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 6016M
sga_target big integer 6016M

ÎÒ²ÉÓõÄ×Ô¶¯ÄÚ´æ¹²Ïí¹ÜÀíģʽ,ÎÒ·ÖÅ䏸Êý¾Ý¿â6¸öG. ÔËÐÐÔÚwin2003 64λ»úÆ÷ÉÏ
up ûÈËÀíÎÒ..

Ö´ÐÐupdateµ½Êý¾Ý¿âÖÐ
³ÌÐòÖÐÄãÊÇÅúÁ¿Ìá½»?»¹ÊÇÒ»´ÎÌá½»Ò»Ìõ?

ÒýÓÃ
Ö´ÐÐupdateµ½Êý¾Ý¿âÖÐ
³ÌÐòÖÐÄãÊÇÅúÁ¿Ìá½»?»¹ÊÇÒ»´ÎÌá½»Ò»Ìõ?


ÅúÁ¿Ìá½»µÄstatement.executBatch()



Ë­Äܰï°ïÎÒ »¹Ã»¸ã¶¨°¡....

oracle11g »î¶¯Á¬½ÓÊýÔõôÔö´ó,»òÕßʲô·½·¨ÄܼõÉٵȴýʱ¼ä..


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

eclipseÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ