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 – 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

Get Operating System Name (Linux / UNIX / Windows) Using PowerShell

As I manage Oracle and SQL Server databases on both Linux and Windows, I sometimes need to determine the OS type before I work with the host so that I can do things conditionally in PowerShell. I looked around the Web and could not find a good example of how to get this information except … Continue reading Get Operating System Name (Linux / UNIX / Windows) Using PowerShell