Oracle PL/SQL Programming Concepts

PL/SQL is Oracle's Procedural Language extension to SQL. It is commonly used to write data-centric programs to manipulate data in an Oracle database. Here's a basic primer to help beginners get started. Chapter Objectives In this Chapter, you will learn about:     *       The Nature of a Computer Program and Programming Languages     *       Good Programming Practices Computers play a large role in the modern world. No doubt you realize how crucial they have become to running any business today; they have also become one of the sources of...

What is PL/SQL?

What is PL/SQL? PL/SQL stands for Procedural Language extension of SQL. PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL. The PL/SQL Engine: Oracle uses a PL/SQL engine to processes the PL/SQL statements. A PL/SQL code can be stored in the client system (client-side) or in the database (server-side).       About This PL SQL Programming tutorial This Oracle PL SQL tutorial teaches you the basics of programming in PL/SQL with appropriate examples. You can use...

Oracle Programming in PL/SQL

Programming in PL/SQL Databases have been in use long before the personal computer arrived on the scene.  IBM developed the Structured Query Language standard (dubbed SQL, and pronounced “See-Quel”) over 30 years ago as a way to retrieve data from their new “relational” database.  A decade later, Oracle released the first commercial relational database that used SQL, and SQL has become the de-facto query language for the vast majority of popular database products. For the complete story, we recommend the book “Easy Oracle PL/SQL Programming”.  Once you have mastered basic SQL you are ready for the advanced...

PL-SQL Interview Questions with Answers

1. Describe the difference between a procedure, function and anonymous pl/sql block. Level: Low Expected answer : Candidate should mention use of DECLARE statement, a function must return a value while a procedure doesn't have to. 2. What is a mutating table error and how can you get around it? Level: Intermediate Expected answer: This happens with triggers. It occurs because the trigger is trying to update a row it is currently using. The usual fix involves either use of views or temporary tables so the database is selecting from one while updating the other. 3. Describe the use of %ROWTYPE and %TYPE in PL/SQL Level: Low Expected...

PL/SQL interview qiuestions

Which of the following statements is true about implicit cursors? Implicit cursors are used for SQL statements that are not named. Developers should use implicit cursors with great care. Implicit cursors are used in cursor for loops to handle data processing. Implicit cursors are no longer a feature in Oracle. Which of the following is not a feature of a cursor FOR loop? Record type declaration. Opening and parsing of SQL statements. Fetches records from cursor. Requires exit condition to be defined. A developer would like to use referential datatype declaration on a variable. The variable...