You are currently browsing the articles from Techno Oracle written in the month of
A ROWID is a system-generated unique identifier that is created for every record in the database. This binary value is the address, or location of the data in the system.A ROWID can be physical, as is the case with records in a standard database table.ROWIDs can be logical as well, as is the case with [...]
Written by admin on October 21st, 2010 with no comments.
Read more articles on Oracle PL/SQL.
The primary key of a relational table Primarily identifies each record in the table. It can either be a normal attribute that is guaranteed to be Primary (such as Social Security Number) or it can be generated by the Database Primary keys may consist of a single attribute or multiple attributes in combination. A primary [...]
Written by admin on October 7th, 2010 with no comments.
Read more articles on SQL tutorials.
ADD_MONTHS adds n number of calendar months to date.The date argument can be a datetime value or any value that can be implicitly converted to DATE. The value of n must be an integer and can be negative.ADD_MONTHS return a value of DATE data type Syntax ——– ADD_MONTHS(date, n) Example 1: SELECT ADD_MONTHS (’11-JAN-10′,6) FROM [...]
Written by admin on October 5th, 2010 with no comments.
Read more articles on SQL tutorials.
MONTHS_BETWEEN finds the number of months between two dates, date1 and date2.MONTHS_BETWEEN, returns a numeric value.The result can be positive or negative. If date1 is later than date2, the result is positive; if date1 is earlier than date2, the result is negative. The non integer part of the result represents a portion of the month. [...]
Written by admin on October 4th, 2010 with no comments.
Read more articles on SQL tutorials.