I have just downloaded 10g express edition but there is no user interface like SQL Server has. Does anyone prefer any program because i am new for Oracle and have never used before.
Oracle 10 has a web based administration tool.
And there's sqlplus as well.
Or indeed get an external tool. PL/SQL Developer is very good and reasonably priced. Oracle has its own tool that's free of charge as well, available from OTN.
TOAD is overpriced IMO.
Oracle have J Developer and SQL Developer, both free from their web site.
If you develop more PL/SQL I'd go for J Developer as it's more aimed at a project style development, where as SQL Developer is more around working with SQL scripts.
Nige
no, JDeveloper is NOT the proper tool for developing pl/sql.
SQL Developer is the right tool, it's designed for working with SQL rather than Java.
Both are development tools, not administration tools.
So neither will let you schedule jobs, schedule backups, etc.
Use the web interface for that.
What you can do from pl/sql developer is save the scripts to recreate tables, packages, etc.
The Oracle XE information (accessible from the web interface) includes instructions on scheduling backups.
I was more referring to working with a project, which if your doing any reasonable level of PL/SQL then your more likely working with multiple files and some form of version control system for controlling source code versions.
SQL Developer has no links to projects or version controlling and therefore is fine if your working with a single PL/SQL package, but not much more.
As for JDeveloper designed to work for Java - how about XML, HTML, CSS.... It's an IDE which ( like Eclipse ) isn't aimed at one technology but aimed as being a platform which can be used to develop a full project rather than one component of it.
Nige
you don't need an IDE to work with version control systems...
And JDeveloper just isn't fit to work with pl/sql packages.
If you want both, get IntelliJ and install the Oracle SQL plugin.
Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.
This thread is more than three months old
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Offline 
Marked 
