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
%ISOPEN The Oracle closes the SQL cursor automatically after executing its related SQL statement. As a result, the %ISOPEN forever yields FALSE.

Find the account numbers of all customers whose balance is more than 10,000 $

write the program for traffic control system with 10 second, 15 secod, and 20 second delay

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

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

Using Operator REF: You can retrieve refs by using the operator REF that, like VALUE, takes as its argument a correlation variable. In the illustration below, you retrieve one


Managing Cursors The PL/SQL uses 2 types of cursors: implicit and explicit. The PL/SQL declares a cursor implicitly for all the SQL data manipulation statements, including th

UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

Sequential Control Dissimilar to the IF and LOOP statements, the GOTO and NULL statements are not important to the PL/SQL programming. The configuration of PL/SQL is such that th