强烈建议你用PL/SQL DeveloperPL/SQL Developer is an Integrated Development Environment (IDE) for developing stored program units in an Oracle Database. Using PL/SQL Developer you can conveniently create the server-part of your client/server applications.
As a worst-case scenario, up to now you might have been working like this:You use a text editor to write program units (procedures, triggers, etc.).You use Oracle SQL*Plus to compile the source files.If there is a compilation error, you have to find out where it is located in the source file, correct it, switch back to SQL*Plus to recompile it, only to find the next error.You use SQL*Plus or the client-part of your application to test the program unit.In case of a runtime error, again you have a hard time locating the cause of the problem and correcting it. You use the Explain Plan utility or tkprof to optimize your SQL statements.To view or modify other objects and data in your database, you use SQL*Plus or yet another tool.
As a worst-case scenario, up to now you might have been working like this:You use a text editor to write program units (procedures, triggers, etc.).You use Oracle SQL*Plus to compile the source files.If there is a compilation error, you have to find out where it is located in the source file, correct it, switch back to SQL*Plus to recompile it, only to find the next error.You use SQL*Plus or the client-part of your application to test the program unit.In case of a runtime error, again you have a hard time locating the cause of the problem and correcting it. You use the Explain Plan utility or tkprof to optimize your SQL statements.To view or modify other objects and data in your database, you use SQL*Plus or yet another tool.
解决方案 »
- 多个insert语句一次执行我想顺序取回seq怎么搞?
- 请教oracle高手,OCI初始化时出错
- 求助,oracle监听的问题
- 我想问一下oracle删除问题,非常郁闷!~~~
- 初学数据库,应该学社么,是用ORACLE还是用SQL SERVER
- 启动OEM,如何“登录到Oracle Management Server"?
- 怪事?
- oracle求触发器写法,在线等
- 有做过把oracle spatial空间数据转换成xml格式的?
- windows无法启动OracleMTSRecoveryService服务 函数不正确
- 哪位高手可以帮忙把代码翻译成T-sql的,急!!!!!
- 怎么把oracle中的数据以sql语句的形式备份出来?
是个非常好的工具
是个非常好的工具Toad
rapid SQL
object brower
比如编译包的时候,有时候它不报错,以为编译通过了,可其实是有错的
不知道是不是我不会用