Oracle client is not required when using AnySQL, and you do not need to configure tnsnames when connecting to database, as following:
ASQL> conn system/oracle@localhost:1521:xe
Database connected.
I combine some useful SQLs in AnySQL as "ora key arg ..." command, it's very easy to use, such as get the space information of tablespaces:
ASQL> ora tsfree
TABLESPACE FILES SIZE_MB FREE_MB MAXFREE PCT_USED PCT_FREE
---------- ----- ------- ------- ------- -------- --------
SYSAUX 1 430 3 2.44 99.3 0.7
USERS 1 100 98.06 98.06 1.94 98.06
SYSTEM 1 340 6.75 5.94 98.01 1.99
UNDO 1 90 14.19 3 84.24 15.76
4 rows returned.
And in AnySQL you do not need to setting the column length when querying, it will automatically calculate the maximum length, so you can omit lots of "col ... format ..." commands, lets query the view v$datafile now:
ASQL> SELECT NAME,BYTES FROM V$DATAFILE;
NAME BYTES
--------------------------------- ---------
C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF 356515840
C:\ORACLEXE\ORADATA\XE\UNDO.DBF 94371840
C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF 450887680
C:\ORACLEXE\ORADATA\XE\USERS.DBF 104857600
And lots of other news, I will introduce them later.