Life After Coffee

19 Responses to “Oracle SQL Developer – A New GUI For Database Development”

1. Life After Coffee » Banner/Oracle User Conference Says:
   May 12th, 2006 at 12:37 pm

   [...] Marc did a good demonstration of SQL Developer, but this product is hard to appreciate until you’ve used it. Thankfully it’s free, so there’s no good reason not to test drive it. [...]

2. Chris Reynolds Says:
   June 15th, 2006 at 9:36 am

   OK, I like SQL Developer, but the whole not viewing the time in the datetime fields is really start to get on my nerves. Why should I put the to_char function around it, it is a datetime field?! I hope they fix this bug soon.. Has anyone heard anything about it? Still no updates..

3. Jon Says:
   June 15th, 2006 at 9:43 am

   I agree Chris. While it’s probably defaulting to the time format parameter for the database, there should be a preference to override it and show hour/minute/second.

   My other beef with SQL Developer is having the extra step to show all results in the database tree when you are looking at more that a few users, tables, or whatever. Again, this should be a preference.

   But, they are still in version 1 and only a few months out of the gate on this one. Hopefully there will be some enhancements soon.

   Jon

4. J.P. Says:
   June 22nd, 2006 at 5:46 pm

   This is a workaround, and not a great one, but it might help someone out there.

   http://www.oracle.com/technology/products/database/sql_developer/howtos/howto_policy_date_formats.html

   and this is from the Readme file:

   4.3 Support for Locale-Sensitive Date and Number Formatting
   SQL Developer uses current database NLS session settings to format date/time and numeric datatypes. If the settings are changed with the ALTER SESSION command, SQL Developer reads the new values from the database and use them for subsequent formatting.

   Do not change the session time zone with ALTER SESSION. To switch the time zone used for formatting, change the client O/S time zone setting and restart SQL Developer.

   hope this helps.

5. Jon Says:
   June 22nd, 2006 at 9:03 pm

   Thanks JP! I’ll have to try that.

6. Mike Says:
   November 28th, 2006 at 4:27 pm

   Actually there are some unfortunate drawbacks to SQL*Developer: It will not talk to an 8i rdbms. (Toad can). There is also no easy way to run a command or a script or changing users without using the mouse to click on a a button (Toad also has some of these limits). For those of us that became touch-typists over the years or dealing with oracle (going back to v6 in my case) this is a severe slow down of work. Sure, SQL*Developer has a Tools->SQL*Plus option, but for those of us who jumped to Macs so we could get top of the line intel laptops that run on a *nix-ish underlayment, and therefore cannot instal SQL*Plus (Power PC chipset macs only, and since we have SQL*Developer oracle’s basic response is don’t hold your breath) waiting.

7. Michael J Says:
   December 11th, 2006 at 9:20 am

   I just downloaded 1.1 sqldev from oracle and was able to set up the date time format. But for some reason, I cannot get the NLS preferences to display the date in the correct timezone (CST). ANy help out there?

8. Paul Says:
   January 18th, 2007 at 3:56 pm

   Just worked out through help that:
   ALTER SESSION SET NLS_DATE_FORMAT = ‘YYYY-MM-DD HH:MI:SS’;
   run in an SQL session will set the date to show the time as well, for as long as the current session lasts. This may be obvious to some, but not to me!

9. Jon Emmons Says:
   January 18th, 2007 at 9:05 pm

   Paul,

   Thanks for sharing. I had figured that would work in SQL Developer like it does in SQL*Plus but I honestly hadn’t bothered to try it.

10. Freakinduck Says:
    February 28th, 2007 at 4:17 pm

    Unfortunate side effect of that is:

    Out core product was mishandling datetime issue from the start (still is).

    Since they format dates from strings, strings from dates, etc, they RELY on the NLS_DATE_FORMAT to be very specific.

    If I change that, their app get date parsing/format errors.

    Every effort to convince them that the CODE should format the date string and parse via same format, they resist due to the “complexity of date-time and timestamp issues”

    Yes. Up until recently, their dates were stored as Varchar2. Logic doesn’t seem to work.

11. Jason Says:
    June 14th, 2007 at 10:48 am

    RE: viewing timestamp: Instead of having different formats specified in NLS for Date and Date/time, put your preferred format for viewing dates in the “date default” NLS setting, then you won’t have to constantly do Alter Sessions.

12. Don Says:
    June 20th, 2007 at 3:23 pm

    On the NLS topic, we are working w/ French chars in the DB and when either of the following are entered – œ Œ and Ÿ – we see a ¿ char via Toad or Sql*Plus

    But when viewed via Oracle SQl Developer the chars display properly.

    No changes were made to local NLS parms or Oralce Session NLS parms – Any thoughts?

    Suspecting the JDBC drivers at this point but have no real evidence..

13. MANISH CHANDERA Says:
    December 26th, 2007 at 1:40 am

    I dont no about Oracle SQL Developer. So Please Tell me .
    How to create a database for Connect. And How to Create Password and User id .
    And After how new connection. and
    What write Hostname and SID Or Service Name

14. Kenneth Says:
    August 9th, 2008 at 9:07 pm

    I used MySQL and PostgreSQL before and now using Oracle 11g in my office.

    I recommend Navicat GUI.
    Recently, I visited their site and found that Navicat released a new Oracle GUI – Navicat Oracle Lite. It’s free version.

    Download URL : http://oracle.navicat.com
    News : http://blogs.navicat.com

    I think Navicat is quite intuitive and easy to use.

15. Kathy Says:
    October 3rd, 2008 at 1:31 pm

    Just switched fromm Toad to Developer and can’t find the equivalent of Shift F9 in Toad, which means execute the command where the cursor is.

    Only workaround I’ve found is to select the entire statement and then hit F5. It’s annoying, at best.

    Does anyone know if there’s an equivalent to Shift F9?

16. Don Kidd Says:
    November 10th, 2008 at 6:44 pm

    Kathy,
    You just need so set up an accelerator key for that. If you go to tools->preferences and then click on Accelerator, and then you can find the command that you want to run then you can set the Shift-F9 or whatever command you want for that command.
    Don

17. Dan Says:
    November 22nd, 2008 at 9:09 pm

    Quick note — if you have specific needs for date/timestamp formatting, you can set them once under preferences/database/NLS parameters.

18. Mike Says:
    January 16th, 2009 at 1:19 pm

    Kathy,

    I have found that if you terminate every statement with a semi-colon in Developer, then F9 will just execute the statement where the cursor is.

    Mike.

19. Nitin Says:
    October 24th, 2009 at 12:28 pm

    Thanks for the tip #8 Paul about -
    ALTER SESSION SET NLS_DATE_FORMAT = ‘YYYY-MM-DD HH:MI:SS’;

    SQL Developer did not display timestamp until I ran this command.

Leave a Reply