Latest stories

  • PL/SQL Procedure Example

    A procedure is similar to a PL/SQL block, but it has a name and is stored in the database permanently. The schema object is the main way that business logic is implemented on the server side. By breaking up complex […] More

    Read More

  • Exception Handling in PL/SQL

    In this tutorial, you will learn about exceptions in PL/SQL and how to write code to handle them. One of the most crucial stages of developing a database application is handling exceptions. Unhandled exceptions pose a threat to application availability, […] More

    Read More

  • What is Cursor in PL/SQL?

    In this tutorial, you will learn, what is cursor in PL/SQL and how it works. One of the most important aspects of database programming is writing SQL in PL/SQL. All SQL statements contained within a PL/SQL block are processed as […] More

    Read More

  • How to Get Table Definition in Oracle?

    Use dbms_metadata.get_ddl() function to get the table definition in Oracle. Below is an example: DBMS_METADATA.GET_DDL() Example The following SQL query will get the table definition for the EMP table in the current schema of Oracle Database: select DBMS_METADATA.GET_DDL('TABLE','EMP') from DUAL; […] More

    Read More

  • PL/SQL Online MCQ Quiz

    Below is the PL/SQL Online MCQ Quiz. It shows the basic ten multiple-choice questions of PL/SQL programming and lets you choose the answer on a single page. And once you click on the Finish button at the end, it will […] More

    Read More