Doing a TRUNC on a date might seem as a perfect solution if you want to query records having a column with both a date and a time. But, as you will see in this little Quick Tip, it is not always that smart.
If you have worked with SQL and PL/SQL for a while, you have probably been in a situation where you have a string that is delimited with a character, and you want the chunks of the string by themselves… In this tutorial we are going… Read more »
In Oracle 11g, the maximum size for a VARCHAR2 field in a table is 4,000 bytes. In PL/SQL your VARCHAR2 variables can be defined as up to 32,767 bytes. So, what if you i.e. have a log table where you would want to put all the… Read more »
Welcome to the oracletuts “PL/SQL Cursors” series. This is a perfect starting point for those of you that are just starting out with PL/SQL, and want to work with data retrieval. There are many ways to retrieve data using cursors in PL/SQL, and we are… Read more »
Have you ever been in a situation where you as a developer knows that your data is stored in your table rows, but your customer don’t care…wanting to present the data as columns? In this tutorial I will discuss three different variants on how to… Read more »
If you have worked with SQL for a while – you have most likely had a time where you wanted to show in a query the difference between two dates. It can be for example to calculate how long a person has been hired in… Read more »
{ Line # 1 Line # 2 Line # 3 Line # 4 } – Mar 06, 12:24 AM
{ Hello Singh - Thank you for your input. This is basically what is used in the three first examples. 
~ TJ } – Feb 15, 2:47 PM
{ Oracle support Mathematical Subtract '-' operator on Data datatype. You may directly put in select clause following statement: to_char (s.last_upd - s.created, '999999D99') {Links moderated... } – Feb 15, 2:17 PM { Thank you Furry for your comment. I agree with you reg. unixtimetool.com. I have actually now changed the link in my post. ~ TJ } – Jan 09, 10:57 AM
{ Very good article. However, I consider the following web site better for testing because it supports timezones: http://unixtimetool.com/ -- Furry } – Jan 09, 10:43 AM
