Have you ever worked on a project in PL/SQL where you wanted to create random dates? And even worse, what if the random dates need to be in a given date range? I am working on a such project now, and in this little tutorial I will show you one way this can be done. Read More »
Some times you come into a situation where you are given a date in the Unix Timestamp format, and you want to convert it to Oracle date format to store it in your Oracle table. A sample of this can be that you are loading data from CA Service Desk (which is SQL Server based – using dates stored as ... Read More »
If you are familiar with with PLSQL you probably have wanted to find out, and show, how long time it takes to process something. Like with me i.e., I am responsible for calculating the points for many of my employer’s distributor contests. It is scheduled to automatically run every night at a certain time during the contest. At the end ... Read More »
OracleTuts Oracle Training, Tutorials, and Videos from Beginner to Advanced
