Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!


Forgot your password?

Oracle SQL Developer Released 47

Zeno Group for Oracle writes to tell us that Oracle just announced the availability of their new, free, database development tool, 'Oracle SQL Developer.' From the article: "Designed for Oracle Database developers, Oracle SQL Developer simplifies development cycles and reduces the need to buy third-party tools for developing and debugging SQL and PL/SQL code. [...] Oracle SQL Developer offers a robust set of features to assist database developers perform tasks such as object browsing and creation, running SQL statements and SQL scripts, editing and debugging PL/SQL code, and viewing and updating data. It provides an extensive set of pre-built reports and also allows developers to build custom reports related to their development projects."
This discussion has been archived. No new comments can be posted.

Oracle SQL Developer Released

Comments Filter:
  • by Suhas ( 232056 ) on Tuesday March 14, 2006 @02:59AM (#14913941)
    ...TOAD croak?
  • Toad Killer (Score:5, Insightful)

    by bungo ( 50628 ) on Tuesday March 14, 2006 @03:06AM (#14913965)
    I've used it a fair bit (it was called Raptor when it was in beta, and has been out for a while).

    The most interesting thing about it is that it's actually a TOAD killer. TOAD has been around for years, and still does slightly more than Oracle's product, but has about 95% of the market. This is sort of like a MS practise of cloning a better product, realasing it for free to kill off the competition.

    Anyway, I hope TOAD dies, and not just becuase I'm a DBA and hate stopping developers and non-developers causing problems in my databases, but the makers of TOAD hired the developer of TORA ( a open source TOAD clone) and killed it off - and noone else seemed to have the time/ability to carry on developing TOAD.

    • Re:Toad Killer (Score:2, Interesting)

      It's interesting to hear this thing is actually a TOAD killer. I wouldn't have imagined. I also can't imagine Oracle releasing a product that didn't have a uber-bloated $40,000 licensing price tag on it... so I guess this is a new shift. I wonder how long it will remain free.
      • Re:Toad Killer (Score:3, Interesting)

        by M1FCJ ( 586251 )
        Well, would't it benefit Oracle's sales figures if Oracle managed to shift a couple of more overpriced CPU licences out just because more programmers and DBAs work with Oracle in an easier way? I would have thought a couple of $millions earned from the licencing would cover the marketing costs.

        Oracle hands out lots of free utilities with their apps, they are just included with the package.

        What annoys me is the lack availability of a cross-platform, cross-database system. TORA has a SQLServer plugin. DbVisua

        • What annoys me is the lack availability of a cross-platform, cross-database system.

          Well, part of is it they (Oracle, MySQL, PostGres, DB2/Ingres, SQL Server, et al) are all different enough each in their own annoying little ways that it does not really seem possible to do. Add to this now that for some of them, you can write stored proc code in different languages besides the legacy language (i.e., Pl/SQL ->Java, T-SQL->C#/CLR langs), and it really does seem to be of Tower of Babel proportions.

          As muc
      • Re:Toad Killer (Score:3, Insightful)

        by Saanvik ( 155780 )
        Well, let's see, JDeveloper, which this is based on, has been free for what, 5 years?

        Look, the Oracle database can be very expensive. You want a high performance database with high quality support, you're going to pay for it. That said, automatically associating Oracle with high priced software is stupid.

        I'm not trying to say that Oracle is being altruistic. Free tools that only work with the Oracle database help keep the Oracle database the market leader, but assuming that Oracle hasn't learned fro

      • Re:Toad Killer (Score:5, Interesting)

        by killjoe ( 766577 ) on Tuesday March 14, 2006 @07:00AM (#14914576)
        Oracle price list from www.oracle.com.

        1) $0.00: Oracle 10g express edition. Limited to 4G databases, will only use 1G ram, only uses one processor.
        2) $5,000 pre processor: Oracle standard edition one. Up to two processors.
        3) $15,000 per processor: Oracle standard edition. Up to four processors.
        4) $40,000 per processor: Oracle enterprise edition. No limits.

        These prices are just below what MS charges for SQL server of similar capabilites except for enterprise edition which has features SQL server does not have.

        The prices are also a little less then what IBM is charging for DB/2.

        why would anybody pay these prices? Well if you have to ask....

        I know there is going to a ton of OMG oracle costs 40,000 posts here so I wanted to put the actual prices before the FUDsters got any further.

        When the open source databases get replication and clustering capabilities of oracle I expect the prices to drop even more. Right now there is no reliable, asyncronous, multi master, shared nothing, merge replication over unreliable links in the open source world. Maybe slony2 will pull it off.

        Has anybody messed with replication on ingres? How is that?
        • For pricing, Oracle considers dual Core CPUs as 2 processors - thus the typical Intel (compatible) server with one CPU that you can get nowadays will actually require TWO licenses for the Oracle database (just try getting a real server - thus not a white brand PC with an AthlonFX in it - with a single core CPU to see what i mean).

          This has caused problems with many hardware upgrade paths where getting a new machine for an existing system means doubling the licensing costs for Oracle.

          Plainly, your listed Orac
          • But I would counter with Oracle does not just run on x86. You can run Oracle on Solaris, AIX, HP-UX, and so on.
          • Most people who run Oracle run it on solaris or some other Nix. There is no reason to limit yourself to intel chips dual core or otherwise.

            Also the prices listed on their web site are list prices. Anybody who has bought oracle can tell you there is much room to negotiate in those prices.
          • Re:Toad Killer (Score:2, Informative)

            by Anonymous Coward
            This changed recently, there is now a "fudge factor" for multicore CPU:s. För Intel/AMD that factor is 0.5. One license per CPU in reality.
        • ... Oracle licenses by the seat as well. 20 seat license (unlimited SMP/cluster deployment) is the minimum, and that's only $18-22k depending on options.

          And for all intents and purposes, anyone can deploy Oracle anywhere, for free. So long as you're using it for personal or development use (and most Slashdotters would fit that category). There is no built in licensing or limits except for the Express edition. Not even a serial number to type in during the installer (like SQL Server).

          So, if you need Oracle.
        • >>4) $40,000 per processor: Oracle enterprise edition. No limits.
          This is MSRP. Who pays sticker price?
          A good negotiator can get Oracle Enterprise for about $10K per CPU.

          Big database shops don't run their Oracle on x86. Solaris on Sparc is very common, attached to SAN such as EMC Symmetrix. HP-UX is still a good Oracle host, though it has a foot in the grave in terms of new OS features.
    • Re:Toad Killer (Score:3, Informative)

      by Ed Avis ( 5917 )
      Bah. I use yasql [freshmeat.net] for everything. Who needs a GUI anyway?
    • Re:Toad Killer (Score:5, Informative)

      by dogsbestfriend ( 755362 ) on Tuesday March 14, 2006 @07:57AM (#14914728)
      > TORA Is alive and well - tora.sourceforge.net - its now completely gpl'ed and binary builds are available for windows and a number of linux distributions Disclaimer: I'm one of the 'new' maintainers of TORA:)
      • Re:Toad Killer (Score:3, Interesting)

        by fimbulvetr ( 598306 )
        I only have one thing to say to you, and that is Thanks. I've been using it. I love it.

        I just want you to know that I'd rather saw my hands off with a wooden comb and use the bloody stumps to control tora than ever consider using this shitpile of bloated, oracle developed Java. If any of you have ever used Oracle's Java apps, I'm sure you won't find this much different. I can use tora freely, no bullshit java breakage, no insanely slow X windows forwarding, no god awful shitbox ugly interface, and most impo
        • I've not used PL/SQL Developer on *nix, so I have no idea about the "insanely slow X windows forwarding", however it runs fine on windows, and your comments make it sound like you've not tried it yet; I have no interest in persuading you to do so, but I think you should at least consider that your position is slightly irrational.

          Personally I have to dissagree with your assessment of the interface; I find it quite clean and friendly; TOAD, for example, is extermely cluttered and the sea of options hinder r

  • by 2674 ( 661934 ) on Tuesday March 14, 2006 @03:07AM (#14913969)
    ...millions of toads suddenly croaked out in terror, and then, suddenly, silence.
  • Not really news ... (Score:3, Informative)

    by Sonic McTails ( 700139 ) on Tuesday March 14, 2006 @03:46AM (#14914083)
    Oracle had free developer versions for ages, it's just that they now have better developer tools, and that itself is old news. Oracle been doing this for the better part of a month. As for TOAD, it's price tag is so rediciously high for small-scale developers or those using the free edition of Oracle for deployment, so here's hoping the toad will just croak.
  • PL/SQL Developer (Score:4, Informative)

    by VitaminB52 ( 550802 ) on Tuesday March 14, 2006 @05:24AM (#14914331) Journal
    SQL Developer is nice and free (as in beer), yet not as nice as PL/SQL Developer (by Allround Automations [allroundautomations.com]), which is almost free.
    I've installed both tools; PL/SQL Developer has more features and is snappier than SQL Developer, at about 1/5th of the download and install size of SQL Developer.
    • Amen to that. I am a big fan of PL/SQL Developer, and recommended it over TOAD at our site a few years ago and we've never looked back. I'll still be looking at this Oracle product though to see how good it is, but its got a hard act to follow.
    • How is it almost free? Web site says it costs $180 after a 30 day trial. I am less concerned about download size. That said, I am yet to look at either. I did use their freeware QueryReporter earlier.
      • How is it almost free? Web site says it costs $180 ...

        $180 is peanuts for corporate users - for them $180 is 'almost free'. I've been at a Y2K project where we needed a Y2K scanning tool. I found a tool which had raving reviews, and our manager instantly bought 3 licenses at $20,000.- each.
        Hiring a good Oracle specialist starts at about $80 / hour, so a time saving tool like PL/SQL Developer for only $180 / license is negligible for corporations.

        • Ah! But you are assuming an audience. Now that Oracle XE is available, it is not just the high paying corporates that use Oracle. I just installed XE because of the free license and since 4GB is adequate for many of my apps. Since I am a student now and my projects are Academic, I would think twice about $180 and that's approximately what other DBA tools for other databases cost.

          http://www.sqlmanager.net/ [sqlmanager.net]
    • We've been using pl/sql developer for 5 years. I like it, but I could also live with oracle sql developer.

      A problem with pl/sql developer has been partitioned tables (hardly supported).

      I think for sql and ddl, the oracle tool is better.
      For pl/sql development and debugging, pl/sql deverloper seems better. However nowadays we hardly use pl/sql anymore, I think our group will move to sql deverloper and not renew our service contract for pl/sql developer.
      • Hmm, I have to reply to myself. After trying it out some more I did find some drawbacks and limitations. I think we'll stick to pl/sql deverloper after all.
  • http://www.oracle.com/corporate/press/2006_mar/031 306-sql-developer-finalsite.html [oracle.com] Linking to the the actual site of the company, imagine that!
  • And where was he/she being held? I hope it wasn't guantánamo.
  • I once used TOAD a lot, but I've been using TOra [sourceforge.net] for years. How does Oracle's tool compare?
  • It'a about time they let him go. I was beginning to wonder if they ever would.
  • Anyone else think that the article's title meant an Oracle SQL developer was released... from prison?
  • Most of the comments have concerned Toad and the effect that this release will have on it. Since I haven't gotten my grubby, little hands on Oracle's product yet, I had a question about how much of a Toad-killer this really is.

    It seems obvious that it will do the same thing as Toad's basic front-end does, but there's more to Toad. What about the procedure editor in Toad? Is there something like that in Oracle's? The other question is the SQLab tie-in from Quest. I use that as a one-step tuning de

"I will make no bargains with terrorist hardware." -- Peter da Silva