Archive for December 17th, 2009

Some quick commands for oracle: 1. Some useful commands To start a session as sysdba: sqlplus sys@tnsname as sysdba; To start a sysdba session under Windows (9iAS): sqlplus “/as sysdba” To list all tables in current schema: SELECT table_name FROM user_tables; or, all tables current user has access to: SELECT table_name FROM all_tables; To list [...]