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
Using COMMIT The COMMIT statements end the present transaction and make permanent any changes made during that transaction. Till you commit the changes, other users cannot acc

Renaming Columns - SQL SQL has no direct counterpart of RENAME. To derive the table on the right in Figure 4.4 from the table on the left, Tutorial D has IS_CALLED RENAME ( St

Change Sql file into CSV for product registration on Magento Project Description: I have a set of files that are in Sql format and could like for a developer to help me with

Grouping and Ungrouping in SQL Example specifying EXAM_MARK in place of COURSE in the main FROM clause. Example: Obtaining C_ER2 from EXAM_MARK SELECT CourseId, CAST

Relational Operators and Logical Operators It prepares the ground for subsequent sections in which each specific relational operator is paired with its logical counterpart, su

COSMOZOI C THEORY - Richter (1865) proposed the cosmozoic theory that says that life came by spores (cosmozoa) or other particles from other planets on the earth.

Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

I want to implement heap sort algorithm in pl sql please share the source code for guidance

Interesting properties of CROSS JOIN - SQL Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOI

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.