Introduction to Oracle 11g Tutorials
Tools & Configuration / Using SQL Developer
Subtitles of the Movie (Introduction to Oracle 11g / Tools & Configuration / Using SQL Developer)
So, in the last movie we downloaded and installed SQL Developer in a separate directory. Now on the Menu we still have Oracle and let's get rid of this window. Now on the Menu we still have the Oracle Client, in fact this is probably the wrong version because as you can see it's going to ask me for the Class Path again. So first of all, roll over that, just delete it. Where's the list? And I'm going to physically go to here, I'm going to get rid of this because it's useless. I'd have to set up the Class Path for it, we'll just, I don't want to go into setting up Java. As I said it's not part of the course. What I'm going to do here is I'm going to say Create a Shortcut and I'm going to roll this onto my desktop. Then go down to here and I like to put things on the Quick Launch Bar, because it's a lot quicker and a lot easier. This I'm going to come up here, Windows Zip Installation, we don't need that sitting there, thank you very much. This is essentially a shortcut to SQL Developer. Now I'm going to double-click this thing and it's going to run and it takes awhile for it come up because it is a Java Application. Get rid of this because we've already run this. We can minimize for this now and do be patient with this tool, it can take awhile to come up but it's pretty good, it's well worth it. It's well worth the wait, here it is. And it's asking me, just Cancel that, it's just rubbish, it's irritating, tip of the day. Okay first of all, this is my Firewall, I have to allow it through. I can't turn of my Firewall whilst recording because I am actually on the Internet. I don't want to show the tips on start up, I don't, not interested that, you don't need that. It has various pages, what I'm going to do is click the Plus sign, Create a Connection. I'm going to call it SI for my SI Database, I'm going to login into the system, to type in the password that I've allocated for it. I'm going to save the password, it's an Oracle Database, I'm going to use a TNS Connection. Remember the TNS File we looked at? It's going to go through that file and look for that. If I had multiple databases it would find multiple things, there are other ways to connect. This is the easiest, click the Test Button, guess what, the status down there, Success. If I change the password and put some gobbledy gook in there and I test it, it will say it failed because it doesn't like it. So I'll type the password in there properly again and I will test it again and I will Save the Connection and I will connect to it. I'm going to blow this up on my whole screen and eventually it comes up with a worksheet. Oracle 10g had a program called SQL Plus Worksheet which if, I go into my Oracle 10 installation, Client Installation, there's a thing there called SQL Plus Worksheet. This is the same thing inside SQL Developer basically and what I can do is, Select star from DBA Tables and Control Enter, it executes it and it basically gives me like a spreadsheet like, type structure if you like. It's a lot easier to use in terms of the formatting of data across the screen. I can up and down through all the data like a spreadsheet. That's pretty cool, I can go across and obviously he doesn't like covering the whole screen. So we'll do this and I can put multiple commands in and do Select star from DBA Views. I can do on this line, I'm on this line with the cursor here to control and enter, it runs just that line. Go down to the next line, run just that line. If I take these little guys out, I think it will freak out. Yes it tries to run both, see it's highlighted both? It gets confused and it gives you an error. Can't remember if I put that in again, down there, down there. Very quick way to access data. One of the issues with SQL Developer is outputting data, it's, it's different in SQL Plus, it's more difficult to output data and put it out to a file and format in specific ways. This is more like a spreadsheet access, do all sorts of things with Select Statements which we will go through in this course. But as you can see here, if you put the cursor there and you click that, that's the Play Button, it runs the statement and what's this one here? Run a Script, this is the thing called Autotrace, we'll get into that later on maybe. This is a thing called Explain Plan which tells you how Oracle is going to execute this query, very complicated, not really necessary at this stage. Tuning, Commit, Rollback, so on and so forth. The most important thing with this tool at this point in time for you to remember is just like Enterprise Oracle Manager is it exists, it's there, it's useful for reading data. It's not necessarily a good idea to use it for adding data or changing data. I generally don't do it for that, again adding and changing data is not covered in this course, it's covered in the next course. This course exclusively covers reading of data. That is SQL Developer, it is very useful but it does have one or two limitations which we will discover in a later course.
Tutorial Information
| Course: | Introduction to Oracle 11g |
| Author: | Gavin Powell |
| SKU: | 34312 |
| ISBN: | 978-1-61866-042-8 |
| Release Date: | 2012-04-28 |
| Duration: | 11.5 hrs / 139 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
