oracleÓÐÄÄЩ·½±ãÒ×ÓõĿͻ§¶Ë?
oracleÓÐÄÄЩ·½±ãÒ×ÓõĿͻ§¶Ë?
²Î¿¼£º
http://school.itzcn.com/special-spid-48.html
ÔÎ...
ÎÒ˵µÄÊÇoracle
ÎÒÃÇÓõÄtoad »¹ÓÐ pl/sql ¶¼ÊǺÃÓõġ£
¸öÈ˸оõtoad²»Õ¦µØ¡£ »¹ÊÇplsql °É£¡
¸òó¡ Ì«¸´ÔÓÁ˵ã..
Ö÷ÒªÊÇ
pl/sql developer
Æä´Î
sql plus
pl/sql »¹ÊDZȽϺÃÓõÄ
sql plus
Hi,
1)Sql plus
2)PL/SQL
3)Toad
4)sql developer
5)Golden32
toad
sql navigator
ÎÒÃÇͬʶ¼ÓÃPL/sql
ËüÊÇÊý¾Ýºǫ́,»ù±¾ÉÏËùÓеÄÃæÏó¶ÔÏóÓï¾ä¶¼Ö§³ÖËü...
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......