Skills required for Oracle test 1Z0-001.

Oracle has specified more than twenty objectives for 1Z0-001 (Introduction to Oracle: SQL and PL/SQL) test. Following are some important areas over which one should have good command before taking the test: Overview of relational databases, SQL, and PL/SQL. Writing basic SQL statements.......
continue reading "Skills required for Oracle test 1Z0-001." »

Things to practice for Oracle test 1Z0-001.

One should have a good knowledge about RDBMS concepts, SQL, and PL/SQL before taking the 1Z0-001 (Introduction to Oracle: SQL and PL/SQL) test, as this test focuses on one's capability to design relational databases and write various types of SQL and PL/SQL statements to interact with databases.......
continue reading "Things to practice for Oracle test 1Z0-001." »

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?" »