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

Çë½ÌÓÃJDBC´´½¨Ò»¸öoracleµÄÊý¾Ý¿â

ÇëÎÊÓÃJDBC´´½¨Ò»¸öoracleµÄÊý¾Ý¿â~~Ó¦¸ÃÒªÔõô×öÄØ£¿£¿ÊÇÊý¾Ý¿âŶ~~²»ÊDZíŶ~~
×Ô¼º¶¥Ò»ÏÂ~~~

ÄãÊÇÔÚÎÊÎÊÌâÂ𣿣¿£¿£¿£¿£¿£¿£¿
ѧϰ²»ÊÇÕâÑùѧµÄ£¡

ÄãÏÈÈ¥×Ô¼ºÕÒ×ÊÁÏ¿´¿´£¬ÕÕ×Å×ÊÁÏÉϲÙ×÷³ö²»À´£¬ÔÙÀ´ÎÊ£¬ÎʵþßÌåµã¡£

ÕâÖÖÎÊ·¨Ì«¿Õ·º£¬±ðÈËÒª´ðÒ²Ö»ÄܸøÄã¸´ÖÆÕ³ÌùÒ»´ó¶ÎʹÓÃÈëÃÅ£¬Ã»ÒâÒåµÄ¡£

ÊÇÒª´´½¨Ò»¸öÊý¾Ý¿âʵÀýô£¿

ÍøÉÏÄÇЩÎÒÕÒÁ˺ܶàÁË¡£¡£¡£ÕÒµ½µÄ¾ø´ó²¿·Ö¶¼ÊÇÔõôÁ¬½ÓµÄ~~Á¬½ÓµÄ²¿·ÖÒѾ­Ñ§»áÁË~~¿ÉÊǾÍÊÇÔõÑù½¨¿â²»ÖªÔõôŪ~~Ò²ÕÒÁËÊ飬°´ÊéÀïµÄÒ»ÌõÌõµØÅª¡£¡£Ò²Êdzö´í~~~ËùÒÔ²ÅÏëÎÊÏÂÄܲ»ÄÜÌṩ±È½ÏÏêϸµÄ²½Öè~~ŪÁ˺ü¸ÌìµÄ°¡~~~

»ØÒ»ÏÂ4Â¥~~
ÎÒÊÇÏ뽨һ¸öеÄÊý¾Ý¿â~~²»ÊÇʵÀýŶ~~

»¹¸öÕæ¿ÉÒÔ£¿

ÒýÓÃ
»¹¸öÕæ¿ÉÒÔ£¿

ÓÃJAVA²»¿ÉÒÔʵÏÖµÄÂ𣿣¿½¨±íÄÇЩÎһᡣ¡£¾ÍÊǽ¨Êý¾Ý¿âʱ¼´Ê¹ÓÃÊÖ¹¤½¨Ò²ÀÏÊÇʧ°Ü~~½øcmdºó²úÉúʵÀýºó£¬ÀÏÊÇ˵ÎÒÃÜÂë´íÎó~~~ÃÜÂëû´í°¡~~ÊÔÁ˺ܶà±éÁË¡£¡£


Oracle ÊÇÒÔ schema À´¹ÜÀíµÄ£¬¿ÉÒÔ¼òµ¥µØÈÏΪÊǰ´Óû§À´¹ÜÀíµÄ£¬¶ø²»Êǰ´Êý¾Ý¿âÀ´¹ÜÀíµÄ¡£

ÔÚ Oracle ÖÐÖ´ÐÐ CREATE DATABASE ÄÇÊÇÒ»ÏîºÜ¸´ÔӵŤ×÷ÁË£¬Oracle ÐèÒª´´½¨ºÜ¾ÃÄØ¡£Ò»°ã°²×° Oracle ·þÎñ¶Ëºó»á×Ô¼ºÐ½¨Ò»¸öĬÈϵÄÊý¾Ý¿â¡£

oracleÖеÄÊý¾Ý´´½¨Ê±ºÜÂé·³µÄ£¬²»ÏñmysqlÖУ¬Ö´ÐÐÁËcreate database¾ÍÐУ¬Äã×îºÃÓÃoracleµÄ¹ÜÀí¶ËÈ¥´´½¨

Ŷ~~лл¥Éϵĸ÷λÁË~~Ô­±¾»¹ÒÔΪ¿ÉÒÔÓÃJAVA´úÂëʵÏÖ~~~

DML


Ïà¹ØÎÊ´ð£º

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

[Ô­´´] 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;
    ......

oracle ¿ÉÊÓ»¯¿´±íÄÚÈÝ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ°²×°ÁËoracle 10g¾­¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ