Tool to manage tables/views/stored procedures

Posted on 2011-04-27
Medium Priority
Last Modified: 2012-05-11
I know this may seem like a dumb question, but I'll ask it anyway.

Recently one of the software packages we installed required Oracle to be installed.  Our company didn't do the installation, we were just left us with a working server.

Now we need to get on there and experiment with creating stored procedures/views, and need to find the most common graphical tool available to do this.

Can someone help me find what I should be using?
Question by:raterus
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 600 total points
ID: 35475773
you could do it with oracle's free "SQL Developer" which I use on my day-to-day job for those tasks:

there are other tools, some free, some $$$ ...
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 400 total points
ID: 35475775
Check out Oracle's SQL Developer tool.

The best news: It's free.

LVL 40

Accepted Solution

mrjoltcola earned 1000 total points
ID: 35476466
angelIII and slightwv mentioned SQL Developer (an older version is included in Oracle server already, check your installation).

Toad for Oracle is the most popular and probably the most powerful. There is a limited free version and a commercial version. I wouldn't waste my time with the free version, but the commercial version is powerful. http://www.quest.com/toad-for-oracle/

For PL/SQL specific development, look at All Round Automations PLSQL Developer, it is cheap and powerful, and for the money, a better value than Toad. http://www.allroundautomations.com/plsqldev.html
LVL 33

Author Closing Comment

ID: 35476816
Thanks for the help.  I'm playing with SQL Developer right now and for my needs probably won't need much more since we won't be doing heavy development.  It is nice to hear there are other options though.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question