Using Oracle SQL Developer

  1. Check the Oracle SQL Developer Help Pages.

  2. Download and install the Oracle SQL Developer.

  3. Double-click on the icon of sqld in your installation such as “C:\Users\userid\Downloads\sqldeveloper-4.0.0.13.80-x64.zip\sqld\ sqld” (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: 20.185.147.112
    • Port: 1521
    • SID: xe
    • Name: user_id (or any name you pick in case you have several connections)

  5. Double-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 C##user_id identified by pwpwpwpw;
    where pwpwpwpw is whatever new password you want. Note that, unlike Linux 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.