Database » Ask Tom MOST RECENT ARTICLES » Date Field as Primary Key ...

Feeds

15142 items (92 unread) in 26 feeds

Database (92 unread)

• DBA's notes (6 unread)
• $Pete Finnigan's Oracle security weblog (1 unread)
• Ask Tom MOST RECENT ARTICLES (38 unread)
• Databases News (3 unread)
• DBAzine.com - Oracle Articles Archive
• Eddie Awad's Blog (3 unread)
• FeuerThoughts (1 unread)
• Mark Rittman's Oracle Weblog
• MR. ED's blog
• MySQL Performance Blog (9 unread)
• Niall's Oracle Pages
• OraBlogs
• Oracle + Open Source
• Oracle HTML DB Studio Recent Additions
• Oracle Security Alerts
• Oracle Software Downloads
• Oracle Technology News
• Oracle's OTN TechCasts (2 unread)
• Orawin.Info
• OTN TechBlog
• OTN/DBA
• Published Security Alerts
• The Dizwell Blog
• The Tom Kyte Blog (3 unread)
• TheServerSide.com (26 unread)
• Upcoming Security Alerts

Ask Tom MOST RECENT ARTICLES

• October 01, 2008
• 

  Date Field as Primary Key ...

  Fetched: October 1st, 2008, 9:50pm PDT

  Tags:    [edit]

  <code>Sometimes a column with "date" Datatype needs to be part of Primary Key or Unique Key. While retrieveing result sets in a SQL Query, we have to use TRUNC(date column) for date comparision or ( Selecting rows greater or less than of database fie...