Is your more than fair amount of time is consumed in silly date functions? Here are 5 useful SQL date queries that can be handy to you.… Read More 5 Useful SQL Date Queries
TRUNCATE and DELETE are two clauses of SQL that deletes the data. If DELETE clause is available then why Oracle has provided TRUNCATE clause? Find out which is more effective between TRUNCATE and DELETE.… Read More Which one is faster TRUNCATE or DELETE?
Would you like to use today’s date as default in date field of your Oracle Form? Here is the way to do it.… Read More How to set SYSDATE as default in Text Item in Oracle Forms
Would you like if I say you can perform date functions by writing short queries? Here is the tip to use short date functions using ANSI Date and ANSI Timestamp.… Read More ANSI Date and Timestamp function for those who like to type less