2 Replies Latest reply on Jun 26, 2015 1:27 PM by b23ac5ed-98a0-4929-a1df-d69a45ae606c

    Control flow statements

    b23ac5ed-98a0-4929-a1df-d69a45ae606c

      Dear database developers / programmers,

       

      I'm currently studying the structure of SQL and I have one intriguing question:

       

      The SQL language exists out of six kinds of statements, defined at Oracle's website (http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_1001.htm), which are:

      1.       Data Definition Language

      2.       Data Manipulation Language

      3.       Transaction Control Statements

      4.       Session Control Statements

      5.       System Control Statement

      6.       Embedded SQL Statements


      In my point of view something explicitly is missing here. The SQL language supports control flow statements, which is a kind of imperative way of writing code, to influence the execution order of the statements. It has while loops, try-catch blocks, if/else statements and etc. Now these statements do not really belong to the data definition language or the manipulation language. Nor does it belong to transaction, session and system control statements.

       

      But to which of these categories belong these statements then? Or is one category missing?