1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Difference between pl/sql and sqllit

Discussion in 'SQL PL/SQL' started by monkey, Apr 19, 2014.

  1. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Hello!
    What is the difference between pl/sql and sqlit?
    Many thanks!
     
  2. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    Re: Transactions

    PL/SQL is a procedural language. It allows you to create programming logic such as loop and IF-THEN conditions. You can define and assign values to variables. You can execute SQL statements from inside PL/SQL and process the results.

    SQL is strictly a language that allows you to query the database (SELECT), manipulate data (INSERT/UPDATE/DELETE/MERGE) or manipulate database objects (CREATE/ALTER). You cannot create a loop in SQL. You have very limited conditional logic capabilities (through DECODE and CASE). You cannot create variables.