Connecting to Oracle Database

Using SQL Developer

  1. Click on New Connection
  2. Enter Username (e.g., HR) and Password
  3. Set Hostname (e.g., localhost) and Port (usually 1521)
  4. Set SID or Service Name (e.g., ORCL)
  5. Click Test and then Connect

Using SQL*Plus

sqlplus hr/hr@//localhost:1521/orcl

SQL*Plus allows command-line access and scripting capability.