Flashcards

Variables

lud.ska PL/SQL Portuguese 5 cards

Cards in this deck (5)

1Number(precision, scale)Scalar Datatype
Commnonly Used
Portable in Oracle Applications
Range: 1 x 10E-130 through 9.99 x10E125, and 0
Fixed Point Number
Precision: 38
Scale: Min: - 84 Max: 127
2PLS_INTEGER / BINARY_INTEGERScalar Datatype Number
3BINARY_FLOAT / BINARY_DOUBLEScalar Datatype Number
High-precision values use less space when stored as BINARY_FLOAT and BINARY_DOUBLE than when stored as NUMBER. Arithmetic operations on floating-point numbers are usually faster for BINARY_FLOAT and BINARY_DOUBLE values than for NUMBER values.
4PrecisionNúmero de caracteres em um valor, incluindo os números antes e depois da vírgula.
Ex: 213,55 = Precision 5
5ScaleQuantidade de números na casa decimal.
Ex.: 10,234 --> Scale 3
Scale negativo é usado para arredondar o número antes da virgula.
Ex:
- Antes: 156,456
- Depois: 200 com scale -2

Description: PL/SQL Flashcards on Variables, created by lud.ska on 20/06/2014.
Created by: lud.ska
Views: 14
Rating