View data in table rows??

[Fresh]

Please for give my ignorance with Oracle, I'm new... I've worked with SQL Server in the past and have used SQL Enterprise Manager to view rows, columns and data in specific tables. Is there something like that in Oracle Enterprise Manager? Using SQL commands I can display this info using SQL Worksheet but was wondering if there was a graphical way to see this info and make edits to table data. I'm currently using Oracle 7.x

Thanks

 

[Advocate]

you might like to try my favourite which is sql navigator from

http://www.quest.com

Best of Irish Luck, David.
djwilkes@hotmail.com

 

[blom0344]

Hello Fresh,

Quest software have a whole range of tools for ORACLE and DB2. For ORACLE I would recommend TOAD VII for which you can buy additional modules for DBA , PL/SQL .....

However , the standard TOAD gives you already enormous functionality. Editing a table is just like changing the field-contents and clicking on the commit button.

TOAD is a bit of an swiss army knife, sql navigator is more of a specialized tool. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[benjamenus]

I also use Toad and even the free version is great. Another option if you want to make things really easy for yourself is to link to Oracle through Access (recommend 2k as 97 times out rather annoyingly).