DBA Tools

AnySQL for Micrsoft SQL Server and Sybase

    As an Oracle DBA, I feel no good command line tools when facing SQL Server or Sybase database, not comfirtable with osql or sqlcmd because too much differences with SQL*Plus. AnySQL is Java & JDBC based, it can...

Posted on January 18, 2008 11:16 AM

What AnySQL learned from MySQL?

    When I start to learn MySQL database, I feel Oracle SQL*Plus should learn from MySQL to display the result as form style. It's not implemented in Oracle 11g's SQL*Plus, but you are still lucky because I implement it...

Posted on December 20, 2007 10:00 PM

Connect to Oracle database without tnsnames.ora configuration?

    The following connection format method is supported by 8i/9i/10g: C:\>sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 5 17:40:22 2006 Copyright (c) 1982, 2005, Oracle.  All rights reserved. SQL> conn anysql/anysql@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=localhost)(Port=1521))(CONNECT_DATA=(SID=TEST))) Connected. SQL>     Yong Huang,...

Posted on October 10, 2007 5:07 PM

Oracle SQL*Plus need learn from MySQL also.

    Oracle 11g learn server result cache from MySQL's query cache, and extend it to client side result cache, this is really cool. But the SQL*Plus also need to run some thing from MySQL, I did learn from MySQL...

Posted on September 9, 2007 12:22 PM