“Coming together is a beginning. Keeping together is progress. Working together is success.” – Henry Ford
I recently read a good article on one of the blog posts that I follow by Jeff Smith, and he shared some of the resources that he uses to get information. He has great information on databases in general and SQL Developer. I’ve benefited from many of his articles. Check it out here : thatJeffSmith.
Also, if you are a beginner and you want to get some very good training on writing SQL queries, I would recommend a book titled ‘A Guide to SQL’ by Philip J Pratt. It has great practical exercises and you get a lot of hands on experience with writing queries. You create the tables that you will use for the exercises. And it does a very good job of explaining concepts. It’s a step by step process to learning SQL.
I would also recommend Oracle PL/SQL 101 by Christopher Allen. It doesn’t have as many exercises but it’s still a good guide for getting started.
And remember Google is your friend. When I was taking an introductory Oracle class last fall we had to create and populate a table that had about 10 to 15 records in it. The instructor had us insert the records one by one (I’m sure that was for a good reason). But after entering a couple of records I started to think that there was surly a way to enter more than one record at a time. My investigations brought up the insert all command. I came across the command on Tech-On-The-Net, another site that has been very helpful for me. To demonstrate,
I create the following table in SQL Developer:
After the table is created, I issue the following command:
You have to use the last part (select * from dual) because the command requires a select statement. The dual table is a dummy table that Oracle has implemented and you can use for just that purpose.
You can review your data by using the select * command. The * let’s SQL know that you want to see all the fields from all the records. Your query will produce the following results:
You still have to write everything out, but you can use copy paste (at least up to end of the ‘values’ part and then input the rest of your record. In the books mentioned above there are as many as 20 records to enter for some tables and I find that this method works faster.