I connected to a local Oracle database, explored schemas and tables, inspected the HR.EMPLOYEES table (columns and indexes), examined a specific index in detail, ran a join query to produce distinct employee records with job/location context, and closed the connection. This is a practical pattern you can reuse when you’re auditing schema objects or preparing queries that join multiple reference tables.

Environment

• Oracle database (connected as mydb_local in SQLcl).
• Main schema explored: HR (common example HR sample schema).
• Client: SQL command-line (SQLcl) session.