•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 374,198 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,563 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 1036 | Replies: 18 | Solved
 |
•
•
Join Date: Apr 2008
Posts: 96
Reputation: 
Rep Power: 1
Solved Threads: 0
Junior Poster in Training
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
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
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,175
Reputation:
Rep Power: 4
Solved Threads: 75
You can use the inbuild tool SQL*PLUS. if you want GUI then can download and use SQL DEVELOPER for free from oracle site.
Share your Knowledge.
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,175
Reputation:
Rep Power: 4
Solved Threads: 75
There are other better GUI tools like TOAD and PLSQL DEVELOPER but you need to purchase those.
Share your Knowledge.
•
•
Join Date: Nov 2004
Location: Netherlands
Posts: 5,588
Reputation:
Rep Power: 18
Solved Threads: 187
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.
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.
42 Private messages asking for help will be ignored
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
•
•
Join Date: Apr 2008
Posts: 96
Reputation:
Rep Power: 1
Solved Threads: 0
Junior Poster in Training
Thanks for info guys.
•
•
Join Date: Nov 2007
Posts: 51
Reputation:
Rep Power: 1
Solved Threads: 9
Junior Poster in Training
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
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
•
•
Join Date: Apr 2008
Posts: 96
Reputation:
Rep Power: 1
Solved Threads: 0
Junior Poster in Training
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?
•
•
Join Date: Nov 2004
Location: Netherlands
Posts: 5,588
Reputation:
Rep Power: 18
Solved Threads: 187
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.
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.
42 Private messages asking for help will be ignored
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
•
•
Join Date: Nov 2007
Posts: 51
Reputation:
Rep Power: 1
Solved Threads: 9
Junior Poster in Training
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
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
•
•
Join Date: Nov 2004
Location: Netherlands
Posts: 5,588
Reputation:
Rep Power: 18
Solved Threads: 187
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.
And JDeveloper just isn't fit to work with pl/sql packages.
If you want both, get IntelliJ and install the Oracle SQL plugin.
42 Private messages asking for help will be ignored
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
Similar Threads
- Connecting JSP, Tomcat, Oracle 10g (JSP)
- Database vs. Spreadsheet (Windows Software)
- Memory footprint - running multiple JVM's on a single box (long post) (Java)
Other Threads in the Oracle Forum
- Previous Thread: Auto increment
- Next Thread: how to get the function last_insert_id()(used widely in mysql) in oracle?
