/* MySql Version, Variables, and where the data Files are ------ */ SHOW VARIABLES LIKE "%version%"; SHOW VARIABLES; SHOW VARIABLES where variable_name='datadir'; /* Oracle Version and Variables ----------------------------------- */ SELECT sys_context('userenv','instance_name') from dual; SELECT sys_context('userenv','db_name') from dual; SELECT sys_context('userenv','server_host') from dual; SELECT * FROM V$INSTANCE; SELECT instance_name, version, version_full FROM V$INSTANCE; SELECT * FROM V$DATABASE; SELECT name, platform_name FROM V$DATABASE; /* SQLite Version ------------------------------------------------- */ SELECT sqlite_version();