Using Oracle SQL Developer

  1. Check the Oracle SQL Developer Help Pages.

  2. Download and install the Oracle SQL Developer.

  3. Doubly click the icon of sqldeveloper in your installation such as “C:\Users\userid\Downloads\sqldeveloper-4.0.0.13.80-x64.zip\sqldeveloper\sqldeveloper” (the Application file).
    4.


  4. For the first-time use, create a new connection such as 513 by selecting the Connections button in the left pane of the above interface.
    5.  Each user has different field values assigned by the DBA:

    • Hostname: 65.52.222.73
    • Port: 1521
    • SID: cdb1



  5. Doubly click the icon 513, the connection name entered by you, in the left pane.
    6.


  6. Open an SQL worksheet by using the Main Toolbar (or Alt-F10), enter an SQL command, and execute the command by right clicking the mouse (or Ctrl-Enter).
    7.



  7. For the first-time use, change the password by using the following command:
    8.  
       SQL> alter user userid identified by pwpwpwpw;
    where pwpwpwpw is whatever new password you want. Note that, unlike Unix login names and passwords, Oracle account names and passwords are NOT case sensitive.



  8. Extend the SQL Developer Use Time.
    9.  After being idle for sometime, SQL Developer will sign you out. You may use the following method to extend the use time: 
      Reports ⇒ Data Dictionary Reports ⇒ All Objects 
       ⇒ Collection Types ⇒ Refresh ⇒ 120

  9. Commit the database if it is updated.
    10.