17.10 - Example - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

This example is based on the data from the previous example.

Consider a column created with a CHARACTER data type.

CREATE TABLE Test3 (Col3 CHAR(5)); 

The column is loaded by selecting, without a sign FORMAT phrase, values from an “unattached” column, as follows.

INSERT INTO Test3 (Col3) 
SELECT Col2 FROM Test2 ;

The values that are inserted are the following:

Col3  
-----
   
 5678 
-9012

The sign FORMAT phrase must be included in the query specification in order to insert the values ‘5678B’ and ‘9012L’.