Data types in sql - timestamp, PL-SQL Programming

Data Types in SQL - Timestamp

TIMESTAMP for values representing points in time on a specified uniform scale. DATE is used for timestamps on a scale of one day, such as DATE '2012-09-25' (a literal denoting September 25th, 2012). TIME is used for values denoting time of day only, such as TIME '16:30:00' (a literal denoting half-past four in the afternoon).

Posted Date: 1/18/2013 1:58:37 AM | Location : United States







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

Write discussion on Data types in sql - timestamp
Your posts are moderated
Related Questions
Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

LOOP Statements The LOOP statements execute a series of statements at multiple times. The loops enclose the series of statements that is to be repeated. The PL/SQL provides typ

Bulk Binds advantages In the Embedded Oracle RDBMS, the PL/SQL engines accept any valid PL/SQL subprogram or block. As the figure shows, the PL/SQL engine executes all procedur

GOTO Statement The GOTO statement branches to a label unconditionally. The label must be exclusive within its scope and should precede an executable statement or a PL/SQL block.

How Bulk Binds Improve Performance The assigning of values to the PL/SQL variables in SQL statements is known as binding. The binding of the whole collection at once is know

Defining REF CURSOR Types To make cursor variables, you take 2 steps. At first, you define a REF CURSOR type, and then declare the cursor variables of that type. You can defin

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

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

Positional and Named Notation You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationsh