16 PL/SQL Developer 13.0 User’s Guide
The saved program file has a format that is compatible with Oracle SQL*Plus. As an example, the
source file containing the 'odd' and 'even' function looks like this:
create or replace function Even(Value in integer) return boolean is
Result boolean;
begin
-- Check if there is a remainder after dividing by 2
Result := (Value mod 2 = 0);
return(Result);
end Even;
/
create or replace function Odd(Value in integer) return boolean is
Result boolean;
begin
Result := not Even(Value);
return(Result);
end Odd;
/
When this file is executed through SQL*Plus, both functions will be created.
4.3 Modifying a program
You can open a previously saved program file by pressing the Open button on File ribbon and selecting
the Program file item. If the file was recently used, you can also open it by selecting Reopen from the
File ribbon. When you start editing, a blue colored indicator at the bottom of the window lights up. This
indicates that the file is modified, but not yet saved. There is also a yellow colored indicator, which
indicates that the file is modified, but not yet compiled.
4.4 Compiling a program
You can compile a program file by pressing the Execute button on the Session ribbon or on the Quick
Access Toolbar. All program units in the program file are compiled, starting with the first one,
regardless of the program unit that is currently selected. When an error occurs, compilation is
terminated and the editor is positioned at the source line that caused the error:
If there is more than one error and you wish to correct them, you can click on the next error message at
the bottom of the Program Editor to go to the error location. If you have configured PL/SQL Developer
to use the HTML manuals as described in chapter 32.2, you can double-click on a compilation error to
display the corresponding paragraph in the Oracle Error Messages manual.
剩余283页未读，继续阅读
dreamlife
- 粉丝: 13
- 资源: 9
我的内容管理
展开
最新资源
- 最优条件下三次B样条小波边缘检测算子研究
- 深入解析：wav文件格式结构
- JIRA系统配置指南：代理与SSL设置
- 入门必备：电阻电容识别全解析
- U盘制作启动盘：详细教程解决无光驱装系统难题
- Eclipse快捷键大全：提升开发效率的必备秘籍
- C++ Primer Plus中文版：深入学习C++编程必备
- Eclipse常用快捷键汇总与操作指南
- JavaScript作用域解析与面向对象基础
- 软通动力Java笔试题解析
- 自定义标签配置与使用指南
- Android Intent深度解析：组件通信与广播机制
- 增强MyEclipse代码提示功能设置教程
- x86下VMware环境中Openwrt编译与LuCI集成指南
- S3C2440A嵌入式终端电源管理系统设计探讨
- Intel DTCP-IP技术在数字家庭中的内容保护
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
