• Html
  • CSS
  • JavaScript
  • DBMS & MySQL
  • PL/SQL

Popular Tutorials

  • Html
  • CSS
  • JavaScript

Popular Exercises

Learn PL/SQL Language

Tutorials QNA

A block structured language that can have multiple blocks in it. Our tutorial includes all topics of PL/SQL language.

  1. What is PL/SQL?

    PL/SQL stands for procedural language extension to SQL. It supports procedural features of programming language and SQL both. It was developed by Oracle Corporation in early of 90's to enhance the capabilities of SQL.

  2. What is the purpose of using PL/SQL?

    PL/SQL is an extension of SQL. While SQL is non-procedural, PL/SQL is a procedural language designed by Oracle. It is invented to overcome the limitations of SQL.

  3. What is PL/SQL table? Why it is used?

    Objects of type tables are called PL/SQL tables that are modeled as database table. We can also say that PL/SQL tables are a way to providing arrays. Arrays are like temporary tables in memory that are processed very quickly. PL/SQL tables are used to move bulk data. They simplifies moving collections of data.

  4. Does PL/SQL support CREATE command?

    No. PL/SQL doesn't support the data definition commands like CREATE.

  5. How exception is different from error?

    Whenever an Error occurs Exception arises. Error is a bug whereas exception is a warning or error condition.

© 2022 AnalyzeCode.com All rights reserved.