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

oracleµ¼Èëµ¼³ö¹¤¾ß

Çë½ÌÏ´óÏÀ£¬ÔÚ²»Ê¹ÓÃÃüÁîµÄÇé¿öÏ£¬oracleÊý¾Ý¿âÓÃÄÄÖÖ¹¤¾ß±È½ÏºÃÓã¬ÒòΪÓÃÃüÁîÔ¶³Ì¿ØÖƲÙ×÷ϵͳ²»Ò»Ñù£¬»á³ö´í£¬²»ÄÜÓÃÃüÁîÖ±½ÓÕýÈ·µÄµ¼È룬Çë´ó¼Ò½éÉÜÏÂoracleµÄ×îºÃÓù¤×÷£¬¿ÉÒÔÖ±½Óµ¼Èëµ¼³ö£¬¶øÇÒÒ»²½µ½Î»²»»áÓÐÎÊÌ⣬»¹ÓÐÏ£Íû¿ÉÒÔÊÊÓ¦¶àÖÖ²Ù×÷ϵͳ¡£Navicat¹¤¾ßºÍPL/SQL¾õµÃ²»ÊǺܺÃÓã¬ÈÝÒ׳ö´í£¬¿´¿´ÓÐûÓÐÆäËûµÄ£¬Ð»Ð»ÁË
ÓÃsqlServerµÄÄǸö¹¤¾ß°É..¸Ð¾õÂúºÃµÄ..¾Í²»ÏþµÃÄã×°ÁËsqlserverûÓÐ..
͵ÀÁ¾ÍÓÃÄǸö

toadÈçºÎ£¿
Ä¥µ¶²»Îó¿³²ñ¹¦£¬»¨µãʱ¼äÊìϤһÏÂexp,imp°É
²Î¿¼£º
http://blueicer.blog.51cto.com/395686/101600

лл»Ø´ð£¬sqlServerûÓÐÓùý£¬¸Õ×°ÁËsqldeveloper£¬¿´¿´Õâ¸öÔõÑù
toadÕâ¸öÓÐ×°ÁË£¬µ«ÊÇûȥÊìϤºÃÏñ²»ÔõôºÃÓã¬ÃüÁî²»ÈÃʹÓã¬ÈÝÒ׳ö´í£¬µ½ÁËÓ¢ÎĵIJÙ×÷ϵͳÎļþ¾Í±»Ëð»µÁË

PL/SQL ºÜºÃÓð¡
Èç¹ûÊý¾ÝÁ¿ÉÙ£¬¿ÉÒÔºÍExcelÖ±½Ó¸´ÖÆÕ³ÌùÊý¾Ý£¬×î·½±ã

plsql devloperÎı¾Êý¾Ýµ¼Èëµ¼³öºÜºÃÓÃ
Èç¹ûµ¼Èëµ¼³öexcel »¹ÊÇʹÓÃtoad°É


sqldeveloper±È½ÏÒ²ºÃÓ㬱¾µØ²»Óð²×°OracleÒ²¿ÉÒÔʹÓøù¤¾ßÁ¬½ÓÔ¶³ÌOracle

ÒýÓÃ
Çë½ÌÏ´óÏÀ£¬ÔÚ²»Ê¹ÓÃÃüÁîµÄÇé¿öÏ£¬oracleÊý¾Ý¿âÓÃÄÄÖÖ¹¤¾ß±È½ÏºÃÓã¬ÒòΪÓÃÃüÁîÔ¶³Ì¿ØÖƲÙ×÷ϵͳ²»Ò»Ñù£¬»á³ö´í£¬²»ÄÜÓÃÃüÁîÖ±½ÓÕýÈ·µÄµ¼È룬Çë´ó¼Ò½éÉÜÏÂoracleµÄ×îºÃÓù¤×÷£¬¿ÉÒÔÖ±½Óµ¼Èëµ¼³ö£¬¶øÇÒÒ»²½µ½Î»²»»áÓÐÎÊÌ⣬»¹ÓÐÏ£Íû¿ÉÒÔÊÊÓ¦¶àÖÖ²Ù×÷ϵͳ¡£Navicat¹¤¾ßºÍPL/SQL¾õµÃ²»ÊǺܺÃÓã¬ÈÝÒ׳ö´í£¬¿´¿´ÓÐûÓÐÆäËûµÄ£¬Ð»Ð»ÁË


Ò»°ãplsql×ãÒ࣡

ÒýÓÃ
Çë½ÌÏ´óÏÀ£¬ÔÚ²»Ê¹ÓÃÃüÁîµÄÇé¿öÏ£¬oracleÊý¾Ý¿âÓÃÄÄÖÖ¹¤¾ß±È½ÏºÃÓã¬ÒòΪÓÃÃüÁîÔ¶³Ì¿ØÖƲÙ×÷ϵ


Ïà¹ØÎÊ´ð£º

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 / ¿ª·¢

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

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

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

ÒýÓÃ
oracle ......

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 ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ