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
Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Fetching Across Commits The FOR UPDATE clauses acquire exclusive all row locks. All rows are locked when you open the cursor, and when you commit your transaction they are unl

Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b

CHECK Constraints in SQL A CHECK constraint is a table constraint defined using the key word CHECK, as already illustrated in several examples in this chapter. In particular,

Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Project Description: We organize an online system called ACPAS we have created a project called EVO that can be use by our customers to integrate their web sites with the Acpas

SQL Is a Database Language: The commands given to a DBMS by an application are written in the database language of the DBMS. The term data sublanguage is sometimes used instea

which operation is used if we are interested in only certain columns of a table?

Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE