MinhTech.com

Yet another technology tutorial blog.

Archives for the ‘Oracle’ Category

Oracle 11g Database Link to Microsoft SQL Server

By • Feb 9th, 2015 • Category: Oracle

Here is how to create a database link from Oracle Database 11g to Microsoft SQL Server.



Oracle Database 11g XE Hostname Change

By • Jan 9th, 2013 • Category: Oracle

Apparently, Oracle Database does not like hostname changes.



Oracle APEX Prevent Cell Wrapping in Interactive Report

By • Apr 27th, 2012 • Category: Oracle

Here is how to prevent cells from wrapping in an interactive report in Oracle Application Express (APEX).



Oracle 11g Memory Max Target ORA-27103

By • Sep 19th, 2009 • Category: Oracle

Here is how to increase the Oracle 11g memory target parameters to more than 3 GB on 64-bit Linux.



Oracle Soundex Incorrect

By • Jul 5th, 2009 • Category: Oracle

Oracle’s implementation of Soundex is incorrect. Here is a correct one.



Oracle PL/SQL is_numeric Function

By • Apr 29th, 2009 • Category: Oracle

Here is an is_numeric function for Oracle PL/SQL.



Load EBCDIC in Oracle SQLLDR

By • Jan 15th, 2009 • Category: Featured Tutorial, Oracle

Here is a simple way to convert data from IBM Extended Binary Coded Decimal Interchange Code, EBCDIC, format and upload into Oracle.