Finding rows that contain numeric or char data in Oracle

  

SQL> select DECODE( TRANSLATE('12345zzz_not_numberee',' 0123456789',' '), NULL, 'number','contains char')
 2 from dual
 3 /

SQL> select DECODE( TRANSLATE('12345',' 0123456789',' '), NULL, 'number','contains char')
 2 from dual
 3 /

"number"

 

https://stackoverflow.com/questions/12549029/sql-error-ora-01722-invalid-number

How to use multiple ODBC data sources with Oracle hsodbc / dg4odbc / generic connectivity

 

1.

Create multiple initSID.ora

inithsodbc.ora

HS_FDS_CONNECT_INFO = hsodbc
HS_FDS_TRACE_LEVEL = 0

initz.ora

HS_FDS_CONNECT_INFO = z
HS_FDS_TRACE_LEVEL = 0

 

2.

(SID_DESC =
      (SID_NAME = hsodbc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = hsodbc)

    )
    (SID_DESC =
      (SID_NAME = z)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = hsodbc)

    )

3.

HSODBC =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA = (SID = hsodbc))
      (HS = OK)
    )

z =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA = (SID = z))
      (HS = OK)
    )

4.

CREATE DATABASE LINK hsodbc USING 'hsodbc';

CREATE DATABASE LINK z USING 'z';

 

 

 

 

source  : https://knowledgebase.progress.com/articles/Article/6177