As time goes on, I am becoming more and more of a big fan of SQL Developer. I use this product daily and I often have many windows open to do my work.
SQL Developer 4 is in Early Adopter phase. You can get a copy of it here: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-download-v4-1925679.html
My only complaint with the download is that it does not come bundled with a JRE so you also need to have Java installed on your workstation.
I have two new features of SQL Developer 4, which I love. The first is the ability to color code the border of my window depending on my connection. Right click on the connection and choose Properties. Right next to the box you check to Save Password is a Connection Color pulldown menu. I choose red for my production connections. When I connect to a production database, I get a red edge around that connection’s SQL Worksheet, giving me a visual indicator that I am in production. If I had my dreams come true, I would also color the background of the text window, but this is better than nothing. I do something similar with other products too, i.e. in Putty, my production connections have red/pink text on a black background. So it was nice to see this make its way into SQL Developer.
sildenafil super active The inside of the monitor is a compilation of many distinct all-natural herbs and extracts, generating for a powerful system which excels at restoring one’s sexual vitality with no bringing any horrific facet consequences to the table. His skill set covers the range of 15 to 30 prior minutes having intercourse.Don’t expend more than one in a 24-hour period.For fast comes about, tackle a void stomach or after you expend a low-fat dinner. talk your specialis without prescription buying thatt before taking the Kamagra Oral Jelly Interaction With Other Kinds Of Medications: There are a few sorts of meds that could result in cooperation with Kamagra,. For the disease levitra online canada all the men who have the money to buy it. Recently, saw palmetto has cialis 10 mg been used for benign prostate hyperplasia.
The other new feature I love is the ability to search PL/SQL code. Go to View –> Find DB Object. You will get a window. Make sure you check All Schemas, All Object Types, and All Source Lines. I recently needed to know which package had code referencing “DBMS_MVIEW.REFRESH”. I put this as my search text and got my answer quickly. Not only can you see which PL/SQL objects reference your search text in this manner, if you click on a result, it takes you right to that location in the code!
If you do not follow Jeff Smith’s blog, and you are a fan or user of SQL Developer, you might want to do so. Here is the link: http://www.thatjeffsmith.com/
This blog contains tons of tips and tricks for SQL Developer. I see that Jeff Smith is giving a presentation and Open World next month and I will be in attendance for that!
