Data in Oracle can be accessed using SQL, ODBC, JDBC, SQLJ, OLE
DB, ODP.NET, SQL/XML, XQuery, and WebDAV. Programs deployed within the
database can be written in PL/SQL and Java.
10 | Chapter 1: Introducing Oracle
SQL
The ANSI standard Structured Query Language (SQL) provides basic functions for
data manipulation, transaction control, and record retrieval from the database. Most
business users of the database interact with Oracle through applications or business
intelligence tools that provide interfaces hiding the underlying SQL and its complexity.
PL/SQL
Oracle??™s PL/SQL, a procedural language extension to SQL, is commonly used to
implement program logic modules for applications. PL/SQL can be used to build
stored procedures and triggers, looping controls, conditional statements, and error
handling. Youcan compile and store PL/SQL procedures in the database. Youcan
also execute PL/SQL blocks via SQL*Plus, an interactive tool provided with all versions
of Oracle. PL/SQL program units can be precompiled.
Java
Oracle8i introduced the use of Java as a procedural language and a Java Virtual
Machine (JVM) in the database (originally called JServer).
Pages:
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56