Data types in sql - decimal, PL-SQL Programming

Data Types in SQL - Decimal

DECIMAL, NUMERIC, REAL, FLOAT and various other terms for various sets of rational numbers. When these key words are specified for the declared type of something, they are usually accompanied by precision and scale specifications. DECIMAL and NUMERIC are synonymous and are used for types with uniform scales, where the difference between any number and its immediate successor or predecessor is constant. For example, DECIMAL(5,2) consists of rational numbers with a precision of 5 (i.e., having at most 5 decimal digits) and a scale of one hundredth (i.e., 2 places of decimals), such as 372.57 and -1.00. (Note that SQL always uses the period "." as the decimal separator.)

Posted Date: 1/18/2013 1:56:19 AM | Location : United States







Related Discussions:- Data types in sql - decimal, Assignment Help, Ask Question on Data types in sql - decimal, Get Answer, Expert's Help, Data types in sql - decimal Discussions

Write discussion on Data types in sql - decimal
Your posts are moderated
Related Questions
Negation (NOT, ¬) - SQL There are three rows instead of just two. As you can see, ¬ p is defined as in two-valued logic (2VL) when p is either true or false, but ¬ (unknown) i

Lightweight system to provide and take info from workers in the field and office, have basic design outlined already just require build and implementation Desired Skills CSS,

%FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or

3CX PBX sync Windows Service Project Description: !! You require access to a commercial version of the 3CX PBX system in order to be able to program the API !! !! You requ

Data Types and Representations This explains the concept possible representation, abbreviated possrep, and explains how these can be used in conjunction with constraints to de

Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope

Query: SELECT * FROM EMPLOYEE1; Select 5 columns and all rows from one table Query: SELECT C_ID, COMPANY, BUILDING, DEPARTMENT, BRANCH FROM CONTRACT;

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Interesting properties of CROSS JOIN - SQL Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOI

Develop Data Business Intelligence Project Project Description: We are linking our Microsoft SQL Database to GoodData Business Intelligence. We are seeking somebody who has e