Saturday, October 29, 2011

Hello World Oracle SQL Developer

Well by Oracle SQL Developer, I mean a developer tool and not a programmer/developer. :)








Following are purely my own understanding as a beginner to work with Oracle SQL Developer.
  1. When you install a oracle server 2008, you will automatically obtain a Oracle SQL Developer client with it.
  2. You cannot create a new database with Oracle SQL Developer client. In order to do that you would require an Admin Client for the same.
  3. So in order to work with databases you have to create a connection to the oracle database residing in a server from the developer client.Following section illustrates the same
  4. A typical Oracle SQL Developer 1.5.5 looks like the following


5. Right Click on Connections and click New Connection

    6. This will result in the following window

      7. First choose the Network Alias. The list of Network Aliases that you see here comes from tnsnames.ora. This is one Important file that would be found in Network/Admin folder.Since this is very important I have documented my understanding on the same in a separately. So refer to the same after go through this one.

      8. The network alias that I have chosen here corresponds to a particular database that has been configured in tnsname.ora
      9. Now key in a connection name of your choice and provide a valid username and password. I know it sounds irritating. Yes you got to have them before trying this one. Speak to some one who can help you on this if you don’t know how to get it. Also as always you can google it.
      10. Now click on test. If the info "Status: Success" appears on the left side of the window then you are ready to go. If not, hmmm… I am not sure. God bless you. Seek help some where.
      11. Now click on Connect. This will result in a new connection as shown in the following image

        12. Now there are two ways by which I can open up the sql console for this connection. They are as follows
          i. First way –using the quick launch icon


          ii. Using the tools menu
          13. Thus you can arrive at the following sql console

            14. Here is my hello word to SQL

            No comments:

            Post a Comment