Skills required for Oracle test 1Z0-147.

Oracle has specified around ninety objectives for 1Z0-147 (Oracle9i: Program with PL/SQL) test, which are grouped under eleven topics. Following are the important areas in which an individual should possess good knowledge before taking the test: Writing PL/SQL programs. Designing......
continue reading "Skills required for Oracle test 1Z0-147." »

Things to practice for Oracle test 1Z0-147.

The 1Z0-147 (Oracle9i: Program with PL/SQL) test focuses on a candidate's ability to develop applications by using the PL/SQL. It requires the candidate to have a good command over PL/SQL. One should be capable of understanding the requirements of an application and program accordingly. Before......
continue reading "Things to practice for Oracle test 1Z0-147." »

Developing an Oracle Application.

When writing a program to interact with the Oracle database, an application developer has the following choices: Client/Server Model: In a traditional client/server program, the code of an application runs on a computer other than the Oracle database server. Database calls are......
continue reading "Developing an Oracle Application." »

What is a trigger?

Trigger A trigger is a kind of procedure that executes implicitly when a table or view is modified or some user actions or database system actions occur. Similar to a stored procedure, a trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can......
continue reading "What is a trigger?" »

What is PL/SQL?

PL/SQL is Oracle's procedural extension to SQL, which is the standard database access language. PL/SQL is an advanced fourth-generation programming language (4GL) and offers seamless SQL access, tight integration with the Oracle server and tools, portability, security, and modern software......
continue reading "What is PL/SQL?" »

What is the structure of a PL/SQL block?

Procedural Language/Structured Query Language (PL/SQL) is a procedural language extension to SQL, the standard data access language for relational databases. PL/SQL is not an Oracle product in its own right; rather, it is a technology used by Oracle server and certain Oracle tools. PL/SQL......
continue reading "What is the structure of a PL/SQL block?" »