Teradata RDBMS SQL/Data Dictionary Quick Reference by NCR

By NCR

This ebook is a brief reference for the SQL dialect supported by means of the Teradata Relational Database administration process. The ebook can be a short connection with the supported facts description words for the Teradata RDBMS and the information Dictionary.The viewers for this speedy reference is all clients of Teradata SQL who want quickly, non-detailed information regarding find out how to constitution a SQL assertion.

Show description

Read Online or Download Teradata RDBMS SQL/Data Dictionary Quick Reference PDF

Similar databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This booklet is a short reference for the SQL dialect supported by means of the Teradata Relational Database administration approach. The ebook is usually a brief connection with the supported info description words for the Teradata RDBMS and the knowledge Dictionary. The viewers for this fast reference is all clients of Teradata SQL who desire fast, non-detailed information regarding find out how to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make varieties and studies important increase types to entry the information you wish and make studies that make feel! in the event you inspiration you needed to use a spreadsheet application to provide stories and varieties, wager what! entry can end up great-looking varieties and reviews that really express what is going on along with your information -- when you know the way to invite it properly.

Extra info for Teradata RDBMS SQL/Data Dictionary Quick Reference

Sample text

GT Tests for greater than. >= GE Tests for greater than or equal.

GE Tests for greater than or equal.

2–6 + Add - Subtract + Unary plus (positive value) - Unary minus (negative value) Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions ABS ABS arg ( ) KK01A010 ACOS ACOS arg ( ) KO01A020 ACOSH ACOSH ( arg ) KO01A021 ASIN ASIN ( arg ) KO01A022 Teradata RDBMS SQL/Data Dictionary Quick Reference 2–7 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions ASINH ASINH ( arg ) KO01A023 ATAN ATAN ( arg ) KO01A024 ATAN2 ATAN2 ( x, y ) KO01A025 2–8 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions ATANH ATANH ( arg ) KO01A026 CASE_N , A conditional_expression ( CASE_N A ) , NO CASE OR UNKNOWN , UNKNOWN UNKNOWN 1101A069 COS COS ( arg ) KO01A027 Teradata RDBMS SQL/Data Dictionary Quick Reference 2–9 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions COSH COSH ( arg ) KK01a001 EXP EXP ( arg ) KK01A002 LN LN ( arg ) KK01A003 LOG LOG ( arg ) KK01A004 2 – 10 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions NULLIFZERO NULLIFZERO ( arg ) 1101E225 RANDOM RANDOM ( lower_bound, upper_bound ) 1101B025 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 11 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions RANGE_N RANGE_N A ( test_expression start_expression * A BETWEEN AND end_expression AND * end_expression B EACH range_size * | range_list | B ) , NO RANGE OR UNKNOWN , UNKNOWN UNKNOWN range_list C start_expression AND end_expression AND end_expression EACH range_size * D C , start_expression AND D , start_expression AND end_expression EACH range_size EACH range_size end_expression * 1101A068 2 – 12 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions SIN SIN ( arg ) KK01A005 SINH SINH ( arg ) KK01A006 SQRT SQRT ( arg ) KK01A007 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 13 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions TAN TAN arg ( ) KK01A008 TANH TANH arg ( ) KK01A009 WIDTH_BUCKET WIDTH BUCKET ( value_expression, lower_bound, upper_bound, partition_count ) 1101A004 ZEROIFNULL ZEROIFNULL ( arg ) 1101E226 2 – 14 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Attribute Functions Attribute Functions BYTES BYTE byte_expression S FF07D174 CHARACTERS CHARACTERS ( string_expression ) CHARS CHAR FF07D165 CHARACTER_LENGTH CHARACTER_LENGTH CHAR_LENGTH (string_expression) FF07D088 FORMAT FORMAT ( column_name ) FF07D166 MCHARACTERS MCHARACTERS (string_expression ) FF07D217 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 15 Chapter 2: SQL Functions and Expressions Attribute Functions OCTET_LENGTH OCTET_LENGTH ( string_expression ) character_set_name FF07D218 TYPE TYPE ( expression ) FF07D169 2 – 16 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Built-In Functions Built-In Functions ACCOUNT ACCOUNT FF07R001 CURRENT_DATE CURRENT_DATE FF07D135 CURRENT_TIME CURRENT_TIME (fractional_precision ) FF07D136 CURRENT_TIMESTAMP CURRENT_TIMESTAMP (fractional_precision ) FF07D137 DATABASE DATABASE FF07R002 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 17 Chapter 2: SQL Functions and Expressions Built-In Functions DATE DATE FF07D134 PROFILE PROFILE KZ01A006 ROLE ROLE KZ01A007 SESSION SESSION FF07R003 TIME TIME FF07D271 USER USER FF07D272 2 – 18 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions CASE Expressions CASE Expressions Valued CASE Expression CASE A WHEN value_expression_1 value_expression_n A THEN scalar_expression_n B END B ELSE scalar_expression_m 1101A012 Searched CASE Expression CASE WHEN search_condition_n THEN scalar_expression_n A END A ELSE scalar_expression_m FF07D224 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 19 Chapter 2: SQL Functions and Expressions CASE Expressions COALESCE Expression , COALESCE ( 2 scalar_expression_n ) 1101E227 NULLIF Expression NULLIF ( scalar_expression1, scalar_expression2 ) HH01B094 2 – 20 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Comparison Operators Comparison Operators ANSI Operator Teradata Extensions = EQ Tests for equality.

Download PDF sample

Rated 4.06 of 5 – based on 13 votes