954,597 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Edit records

I just loaded the 10g client EM on my Windows workstation to connect to our 10g database.
Everything works great except I dont see any place where I can edit records. I have to use SQL Plus to edit records but was hoping to use a GUI like I had with 9i client OEM.
Before we had 10g, I used to have the 9i OEM and it let me edit records in 9i OEM where I could add, delete and update records with a user friendly interface.

Please advise where or how I can edit records in 10g EM or Oracle client?

chicago1985
Light Poster
36 posts since Nov 2007
Reputation Points: 10
Solved Threads: 0
 

you can use GUI tools like TOAD or PL/SQL DEVELOPER.

if you want a free tool try SQL DEVELOPER from oracle corporation.

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

I have instate oracle 9i i want to work in GUI mode Any body can tell me how can I open the GUi mode of sql

bhaskar26
Newbie Poster
1 post since Feb 2010
Reputation Points: 10
Solved Threads: 0
 

Please read post #2.

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

or simply RTFM. Instead of the fat clients Oracle 10g uses a thin client web interface with pretty similar functionality to the 9i fat client.

SQL Plus is still available and the preferred way of accessing the database though. Maybe you should learn to use SQL?

jwenting
duckman
Team Colleague
8,392 posts since Nov 2004
Reputation Points: 1,662
Solved Threads: 337
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You