oracle 10g user interface
 

Hi,

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.

Thanks

Re: oracle 10g user interface
 

You can use the inbuild tool SQL*PLUS. if you want GUI then can download and use SQL DEVELOPER for free from oracle site.

Re: oracle 10g user interface
 

There are other better GUI tools like TOAD and PLSQL DEVELOPER but you need to purchase those.

Re: oracle 10g user interface
 

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.

Re: oracle 10g user interface
 

Thanks for info guys.

Re: oracle 10g user interface
 

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

Re: oracle 10g user interface
 

I'll develop more PL/SQL therefore, i need to use J Developer. I have just created my database with SQL Developer but, how do i backup it?

Re: oracle 10g user interface
 

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.

Re: oracle 10g user interface
 

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

Re: oracle 10g user interface
 

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.