Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 2 3 4 < 5 > 6 7 8 9 10 11 .. 241 >> Next


About This Chapter..............................................5-1

What Is Data Definition?........................................5-2

Data Type Attributes: ANSI Mode ................................5-4

Data Types......................................................5-6

GRAPHIC Conversion..............................................5-9

Numeric Data Types.............................................5-11

DATE Numeric Data Type.........................................5-13

Arithmetic on Date Values......................................5-17

DECIMAL and NUMERIC Numeric Data Types.........................5-18

BYTEINT Numeric Data Type......................................5-20

SMALLINT Numeric Data Type.....................................5-21

INTEGER Numeric Data Type......................................5-22

FLOAT, REAL, and DOUBLE PRECISION Numeric

Data Types...................................................5-23

Character Data Types...........................................5-25

CHAR, VARCHAR and LONGVARCHAR Character

Data Types...................................................5-27

Specifying Case for Character Data.............................5-29

Defining Case Sensitivity for Table Columns....................5-32

Case Sensitivity of Character String Literals..................5-33

Character String Definitions in the USING Phrase ..............5-34

Case Sensitivity in Comparisons................................5-35

Character Data for a Japanese Character Supported Site.........5-38

BYTE and VARBYTE Data Types ...................................5-41

Japanese Character Graphic Data Types..........................5-43

Column and Table Constraints...................................5-47

Constraints....................................................5-48

FORMAT Phrase..................................................5-49

Character Formats..............................................5-52

Graphic Formats................................................5-53

Numeric Formats................................................5-55

DATE Formats ..................................................5-61

Data Default Formats...........................................5-64

Naming Columns and Expressions ................................5-66

TITLE Phrase...................................................5-69

Default Control Phrase.........................................5-73

COMPRESS Phrase................................................5-77

Data Type Conversions .........................................5-80

Teradata RDBMS for UNIX SQL Reference xiii
Table of Contents

Implicit Type Conversion Rules...............................5-82

CAST in Data Type Conversion.................................5-84

Explicit Data Type Conversion with a Data Definition Phrase ....5-86

Numeric Conversion...........................................5-87

Numeric to Numeric ..........................................5-88

Numeric to Character.........................................5-89

Character Conversion ........................................5-91

Character to Numeric.........................................5-92

Character To Character.......................................5-94

Graphic Conversion ..........................................5-95

Byte Conversion..............................................5-96

DATE Conversion..............................................5-97

Signed Zone Decimal Conversion...............................5-99

Using CAST in Data Type Conversions.........................5-102

Attribute Functions.........................................5-104

Hash-Related Expressions....................................5-111

HASHROW Function............................................5-112

HASHBUCKET Function.........................................5-113

HASHAMP Function............................................5-114

HASHBAKAMP Function.........................................5-115

Chapter 6

SQL Expressions

About This Chapter.............................................6-1

Arithmetic Operators...........................................6-3

Arithmetic Functions...........................................6-7

Date and Time Expressions.....................................6-11

The EXTRACT Function..........................................6-13

ADD_MONTHS Function...........................................6-16

Aggregate Operators...........................................6-17

Character String Expressions..................................6-23

Character Strings: Concatenation Operator.....................6-24

Character String Expressions: String Functions................6-30

String Functions: SUBSTRING and SUBSTR........................6-31

Japanese Characters and Graphic Data..........................6-34

String Function: MSUBSTR......................................6-36
Previous << 1 .. 2 3 4 < 5 > 6 7 8 9 10 11 .. 241 >> Next