Where did AnySQL come from?

AnySQL originated from a free utility I wrote in 2003 and 2004 when I was involved in Java programing. I needed to write a tool that could extract rows from different types of RDBMS (Oracle, Sybase, DB2 etc), and I chose Java JDBC API. Finally I wrote a tool similar to Oracle's SQL*Plus, but it could connect to different types of databases, so I named it "AnySQL". Later in 2004 I registered this domain name. The original objective is to introduce the utility to more people.

I've been writing blog since March 2005, and I changed the site to be my personal page, not just for the AnySQL utility. Since then more free utilities were written. You could download them and give a try. Along with that, there's also some Oracle research. Anyway, welcome to visit my site. Hope you can find something useful.


Nick Names

  • d.c.b.a
  • anysql


Work Experience

  1. 98-99, MIS system development with PowerBuilder and Oracle Developer 2000
  2. 00-01, Trainer of SQL Server and Oracle
  3. 02-03, Building Data Warehouse for China Unicom as DBA
  4. 04-Now Working as a DBA for a global auction site


Trainer Experience

  1. One week of Oracle Developer 2000 training for Huafei Color Monitor Co, Ltd.
  2. 10 days of Oracle DBA training for a hospital
  3. 3 days of Oracle training for ICBC, Suzhou branch
  4. 3 days of Oracle developer training for a company in Shanghai
  5. Two weeks of Oracle performance tuning for a company
  6. 3 days of Oracle performance tuning training for ITPub.net in May 2005
  7. 3 days of Oracle fundamentals training for ITPub.net in January 2006


Free Utilities (except AUL)

  • AnySQL: Java based database interaction tool for Oracle, like SQL*Plus
  • AnySQL UnLoader (AUL): alternative to Oracle DUL (Not Free)
  • OCIDIFF: Compare schemas and sync them
  • OCIULDR: Unload rows from Oracle database to text file
  • OTop: Quickly and easily find out Oracle top sessions by consistent gets or physical reads etc
  • OPMon: Real-time statspack for Oracle tuning, temporary replacement of Oracle STATSPACK


Contact Me

  • MSN: loufangxin(.at.)msn.com
  • Skype: anysql
  • AIM: anysql
  • Mail: anysql(.at.)126.com