Null Statement Examples | SQL Statements | Teradata Vantage - 17.05 - Null Statement Examples - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

Example: Null Statement

The semicolon in the following request is a null statement.

     /* This example shows a comment followed by
        a semicolon used as a null statement */
     ;  UPDATE Pay_Test SET ...

Example: Null Statement and Statement Separator

The first SEMICOLON in the following request is a null statement. The second SEMICOLON is taken as statement separator.

     /*    This example shows a semicolon used as a null
           statement and as a statement separator */
           ;  UPDATE Payroll_Test SET Name = 'Wedgewood A'
              WHERE Name = 'Wedgewood A'
           ;  SELECT ...
     -- This example shows the use of an ANSI component
     -- used as a null statement and statement separator ;

Example: Single Null Statement

A SEMICOLON that precedes the first or only statement of a request is taken as a null statement.

     ; DROP TABLE temp_payroll;