Type versus representation confusion in sql, PL-SQL Programming

Type versus Representation Confusion in SQL

This describes how a value might have two or more distinct representations. For example, user-defined type POINT might have a declared possrep based on Cartesian coordinates and another based on polar coordinates. SQL has a system-defined type, TIMESTAMP, for values representing points in time, a timestamp being represented by a date, a time of day, and-optionally-a time zone, expressed as a displacement from UTC. Clearly any timestamp can be expressed in several different ways, using different time zones.

Three o'clock in the afternoon of December 31st, 2011 in UK, for example, is the same time as two o'clock in the morning of January 1st, 2012 in New Zealand. SQL treats those two representations as distinct values that compare equal, in like fashion to its treatment of character strings with trailing blanks, with similar consequences. If instead it had treated them as distinct representations of the same value, then the issue of indeterminacy would not have arisen.

Posted Date: 1/18/2013 2:41:12 AM | Location : United States







Related Discussions:- Type versus representation confusion in sql, Assignment Help, Ask Question on Type versus representation confusion in sql, Get Answer, Expert's Help, Type versus representation confusion in sql Discussions

Write discussion on Type versus representation confusion in sql
Your posts are moderated
Related Questions
Name Resolution In potentially uncertain SQL statements, the names of the database columns take precedence over the names of the local variables and formal parameters. For e.g.

THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

ORIGIN OF EARTH - BIG-BAN G HYPOTHESIS - Origin of life is linked to origin of earth. Cosmos, the Universe originated 10-20 billion years ago by Big Bang (thermonu

ALTER TABLE bb_basketitem ADD CONSTRAINT bitems_qty_ck CHECK (quantity BEGIN INSERT INTO bb_basketitem VALUES (88,8,10.8,21,16,2,3); END; Brewbean’s wants to add a check

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con

I would like to have a custom MS Access database designed and coded that would help me schedule my customer's orders and that would help me track my employees production output and