文章分类 -  TOAD学习

ORACLE客户端的安装
摘要：ORACLE客户端的安装目前ORACLE没有发布ORACLE INSTANT CLIENT可执行文件，但是INSTANT CLIENT压缩包还是有下载滴，不过环境变量配置起来比较麻烦，而且经常遇到错误，其实可以用ORACLE Oracle Database 10g Express Edition for Microsoft Windows 已发布的Oracle Database 10g Express Client (OracleXEClient.exe)替换,下载地址http://www.oracle.com/technetwork/database/express-edition/down 阅读全文
posted @ 2011-10-25 10:55 Bruce.zeng 阅读(139) 评论(0) 推荐(0)
动态SQL和PL/SQL的 EXECUTE IMMEDIATE使用
摘要：EXECUTE IMMEDIATE option for Dynamic SQL and PL/SQLBy DatabaseJournal.com Staff by Amar Kumar PadhiEXECUTE IMMEDIATE is the replacement for DBMS_SQL package from Oracle 8i onwards. It parses and immediately executes a dynamic SQL statement or a PL/SQL block created on the fly. Dynamically created an 阅读全文
posted @ 2011-10-19 16:38 Bruce.zeng 阅读(273) 评论(0) 推荐(0)
Toad调试存储过程、触发器
摘要：Starting with the 10g release, Oracle now offers a new interface, known as JDWP, for debugging PL/SQL and stored Java procedures. Toad fully supports both interfaces, but we recommend you continue to use DBMS_DEBUG unless you need to debug your Java code.Toad supports both Oracle debugger API’s.Debu 阅读全文
posted @ 2011-10-18 15:33 Bruce.zeng 阅读(1441) 评论(0) 推荐(0)