Example - Advanced SQL Engine - Teradata Database

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
tpf1598412463935.ditamap
dita:ditavalPath
tpf1598412463935.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantage™

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’.