For large organizations or those requiring large data volume, high transaction volume or advanced database features, Maxim Consulting recommends Oracle for your relational database management system (RDBMS). Oracle offers a full-featured platform that is ideal for organizations with well trained IT personnel and a robust hardware and network infrastructure. We do not recommend Oracle for smaller organizations with more limited resources.
Over the years we have learned many useful tips for Oracle implementations. We will provide new tips monthly.
LENGTH(TRIM(TRANSLATE(TRIM(string1),' 0123456789','A ')))
string1 is the string value that you are testing.
This function will return a null value if string1 is numeric. It will return a value "greater than 0" if string1 contains any non-numeric characters (including spaces). You may also want to add ".", "-" and/or "+" to the list of numeric characters depending on your use.
Date columns in Oracle have a time component. So, if you are comparing two dates from two source and the times are different, you will never get a match. To remedy this we had been converting the dates into string using TO_CHAR in the 'YYYYMMDD' format. A better way to do this is the TRUNC function.
A common way we will use it is:
SELECT *
FROM ea.elections
WHERE Trunc(:din_election,'DD') = Trunc(a.election_date,'DD')
It is important to note that applying the function in this manner may bypass the use of an index on the date column and may negatively affect performance.
