Oracle: Resolve “ORA-01704: string literal too long” and/or Non-ANSI Language Character Display Issues

You may experience issues when it comes to special characters. It could be DML (Insert/Update/Delete) where the data is not stored properly (or) display related (SELECT) where the characters do not display correctly as they are stored in the database. You could resolve both. Please continue reading on how to. Straight-forward case: The error "ORA-01704: … Continue reading Oracle: Resolve “ORA-01704: string literal too long” and/or Non-ANSI Language Character Display Issues

Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

I wanted to do a small post on using the DOS command line tool ADRCI to quickly locate problems from the alert log and acting on them to fix the issue(s) when using Oracle on Windows. It should not be much different on Linux. This is a 100 level post. The call: Timeouts Another normal day … Continue reading Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

Oracle – Easy Date Strings (and NOT)

Whenever I type in a date strings in Oracle, I convert the strings to Date data type in my code as well as my queries without relying on the session setting for date format. I will explain why. Session date format setting: Session date format settings govern how date strings should be converted into dates (the … Continue reading Oracle – Easy Date Strings (and NOT)

Oracle – Capture OS Command Output Using Oracle External Tables

Case for the OS side: Some things are best done on the OS side and there is no question about that. Case for the DB side: Some things are best done on the database side and there is no question about that either. What if? Some things need the output of one in the other … Continue reading Oracle – Capture OS Command Output Using Oracle External Tables

Oracle – Back To The Past – Using The Oracle Flashback Query Feature

Go back in time and look how something looked then - Isn’t this one of those things that is really cool? In Oracle, the set of features that enable this capability are clumped under “Oracle Flashback Features”. Technically, they can be bucketed as: Flashback query – as the name means, retrieve data as of a point … Continue reading Oracle – Back To The Past – Using The Oracle Flashback Query Feature