• Synonyms
Synonyms are aliases for schema objects. You can use synonyms for security and
convenience; for example, to hide the ownership of an object or to simplify SQL
statements.
• Stored subprograms
Stored subprograms (also called schema-level subprograms) are procedures
and functions that are stored in the database. They can be invoked from client
applications that access the database.
Triggers are stored subprograms that are automatically run by the database when
specified events occur in a particular table or view. Triggers can restrict access to
specific data and perform logging.
• Packages
A package is a group of related subprograms, along with the explicit cursors and
variables they use, stored in the database as a unit, for continued use. Like stored
subprograms, package subprograms can be invoked from client applications that
access the database.
Typically, the objects that an application uses belong to the same schema.
See Also:
• Oracle Database Concepts for a comprehensive introduction to schema
objects
• Creating and Managing Tables
• Managing Indexes
• Creating and Managing Views
• Creating and Managing Sequences
• Creating and Managing Synonyms
• Developing Stored Subprograms and Packages
• Using Triggers
1.2.2 About Oracle Database Access
You can access Oracle Database only through a client program, such as SQL*Plus or
SQL Developer.
The client program's interface to Oracle Database is Structured Query Language
(SQL). Oracle provides an extension to SQL called Procedural Language/SQL (PL/
SQL).
1.2.2.1 About SQL*Plus
SQL*Plus (pronounced sequel plus) is an interactive and batch query tool that is
installed with every Oracle Database installation. It has a command-line user interface
that acts as the client when connecting to the database.
Chapter 1
About Oracle Database
1-3
剩余270页未读，继续阅读
juddy10000
- 粉丝: 1
- 资源: 14
我的内容管理
展开
最新资源
- 解决本地连接丢失无法上网的问题
- BIOS报警声音解析：故障原因与解决方法
- 广义均值移动跟踪算法在视频目标跟踪中的应用研究
- C++Builder快捷键大全：高效编程的秘密武器
- 网页制作入门：常用代码详解
- TX2440A开发板网络远程监控系统移植教程：易搭建与通用解决方案
- WebLogic10虚拟内存配置详解与优化技巧
- C#网络编程深度解析：Socket基础与应用
- 掌握Struts1：Java MVC轻量级框架详解
- 20个必备CSS代码段提升Web开发效率
- CSS样式大全：字体、文本、列表样式详解
- Proteus元件库大全：从基础到高级组件
- 74HC08芯片：高速CMOS四输入与门详细资料
- C#获取当前路径的多种方法详解
- 修复MySQL乱码问题：设置字符集为GB2312
- C语言的诞生与演进：从汇编到系统编程的革命
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
