how to view/modify all rows of a oracle table

[omshivaprasad2]

In Excel, all rows can be edited/modified at a place.
In oracle, only one or few rows can be seen by using some UI
or by using sql queries in backend

I would like to know
is it possible to open all the rows in a table of oracle database and change them at a time??
is there any navigator facility, if so plz explain how to open it
plz answer this question

[Zeb]

sounds like you need to check out a program called "Toad". It is a gui for Oracle, similar to SQL Servers Enterprise Manager, and it will let you do what I think you are asking. Do a google search for "Toad" and "Oracle". Don't know what it costs, or if there is a trial version or anything though.