Answer to Question #250344 in Databases | SQL | Oracle | MS Access for Bigboy97

Question

Explain to Top Management the various program categories that will enable you to operate a database in Oracle. Discuss at least three of these program categories.

Answer 1

All versions of Oracle Database include languages ​​and interfaces that allow programmers to retrieve and manipulate data from the database. Database programming tools are typically of interest to developers who create commercial applications based on Oracle, as well as IT departments who create applications for their own organizations. You can use SQL, ODBC, JDBC, SQLJ, OLE DB, ODP.NET, SQL / XML, PL/SQL, XQuery, Java and WebDAV to access data in Oracle.

SQL: The ANSI standard's Structured Query Language (SQL) includes basic tools for manipulating data, managing transactions, and retrieving records from a database. Most business users interact with Oracle through business intelligence applications or tools that provide interfaces that hide SQL and its inherent complexity.

PL / SQL is an Oracle-developed procedural extension to the SQL language. It is usually used to implement logical program modules for applications. Stored procedures, triggers, loops, conditionals, and error handling can be written in PL / SQL. PL / SQL procedures can be compiled and stored in the database. Blocks written in PL / SQL can also be executed directly using the interactive SQL * Plus tool available in all versions of Oracle. PL / SQL code blocks can be compiled in advance.

Java: In Oracle8i, Java was first used to write stored procedures, and the Java virtual machine (JVM) was built directly into the DBMS (originally called JServer). The JVM provides support for writing Java stored procedures, methods, and triggers, as well as Enterprise JavaBeans ™ (EJB), CORBA, IIOP, and HTTP technologies.

Incorporating Java into Oracle Database enables Java programmers to apply their knowledge to Oracle application development. Java applications can be deployed client-side, inside an application server, or in a database, as appropriate. Oracle Database 11g includes the Java JIT compiler, activated by default.