I have a view that utilizes the native Oracle Add_Months function in the criteria portion of the select statement. This view works well in our 8i environment, however we are migrating to 10g. There, the view fails to return any data if the Add_Months function is not remarked out. If it is remarked out, then the view returns appropriate data. Does anyone have any idea why?
MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.