Data types in sql - interval, boolean, PL-SQL Programming

Data Types in SQL - Interval, Boolean

INTERVAL for values denoting, not intervals (!) but durations in time, such as 5 years, 3 days, 2 minutes, and so on.

BOOLEAN, consisting of the values TRUE and FALSE, with UNKNOWN being an alternative name to NULL for "the null value" of this particular type.

Posted Date: 1/18/2013 1:59:33 AM | Location : United States







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

Write discussion on Data types in sql - interval, boolean
Your posts are moderated
Related Questions
Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

Assigning and Comparing Collections One collection can be assigned to other by an SELECT, INSERT, UPDATE, or FETCH statement, an assignment statement, or by a subprogram call. A

Advantages of Packages The benefits of the Packages are as shown below: Modularity The Packages encapsulate logically associated items, types, and subprograms in the

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:

What are the rates for help in writing PL/SQL procedures and functions?

MILLER-UREY' S EXPERIMENTAL PROCEDURES - They recreated the probable conditions on the primitive earth in the laboratory. An atmosphere containing hydrogen, ammonia, me

Pl/SQL Expressions The Expressions are constructed by using the operands and operators. An operand is a constant, literal, variable, or function call which contributes a value

Datatypes Every constant and variable has a datatype that specifies the storage format, constraints, and the valid range of values. The PL/SQL gives a variety of predefined dat

Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi

Using %TYPE The %TYPE attribute gives the datatype of a variable or the database column. In the example below, the %TYPE gives the datatype of a variable: credit REAL(7,2); debi