Re: Edit records with an Oracle client
From: Ed Prochak <edprochak_at_gmail.com>
Date: Wed, 1 Apr 2009 06:38:30 -0700 (PDT)
Message-ID: <6ed0416e-3994-4779-9bb9-7dd4875fbd02_at_o6g2000yql.googlegroups.com>
On Mar 31, 6:55 pm, francan <franca..._at_yahoo.com> wrote:
> On Mar 31, 7:41 pm, Palooka <nob..._at_nowhere.com> wrote:
>
>
>
> > francan wrote:
> > > On Mar 30, 10:08 pm, Palooka <nob..._at_nowhere.com> wrote:
> > >> francan wrote:
> > >>> 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?
> > >> You want to edit in a spreadsheet like grid in 10g? You can use
> > >> iSQL*Plus, SQL Developer, or any number of tools.
>
> > >> Palooka
>
> > > Yes, I would like to edit like speadsheet. I did try the iSQL*Plus
> > > but didnt see anywhere to edit records because it just gave me
> > > workspace and history view:
> > > http://myMachineNameHere:5560/isqlplus/
>
> > > Please advise did I get the right isqlplus area?
>
> > Sorry, I may have made a mistake here. iSQL*Plus may not allow editing
> > in that fashion. It's been a while since I used it, and it is
> > discontinued now anyway, IIRC.
>
> > Use SQL Developer, or any number of other tools, if you must do this.
>
> > Palooka- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks,
>
> I assume I only need the 10g EM for my local database dba functions
> only and it is mostly suppose to be used for DBA work? SQL Developer
> is mostly geared toward editing records and not a DBA tool?
Date: Wed, 1 Apr 2009 06:38:30 -0700 (PDT)
Message-ID: <6ed0416e-3994-4779-9bb9-7dd4875fbd02_at_o6g2000yql.googlegroups.com>
On Mar 31, 6:55 pm, francan <franca..._at_yahoo.com> wrote:
> On Mar 31, 7:41 pm, Palooka <nob..._at_nowhere.com> wrote:
>
>
>
> > francan wrote:
> > > On Mar 30, 10:08 pm, Palooka <nob..._at_nowhere.com> wrote:
> > >> francan wrote:
> > >>> 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?
> > >> You want to edit in a spreadsheet like grid in 10g? You can use
> > >> iSQL*Plus, SQL Developer, or any number of tools.
>
> > >> Palooka
>
> > > Yes, I would like to edit like speadsheet. I did try the iSQL*Plus
> > > but didnt see anywhere to edit records because it just gave me
> > > workspace and history view:
> > > http://myMachineNameHere:5560/isqlplus/
>
> > > Please advise did I get the right isqlplus area?
>
> > Sorry, I may have made a mistake here. iSQL*Plus may not allow editing
> > in that fashion. It's been a while since I used it, and it is
> > discontinued now anyway, IIRC.
>
> > Use SQL Developer, or any number of other tools, if you must do this.
>
> > Palooka- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks,
>
> I assume I only need the 10g EM for my local database dba functions
> only and it is mostly suppose to be used for DBA work? SQL Developer
> is mostly geared toward editing records and not a DBA tool?
SQL Developer is mostly geared for developers, not for end users. Which are you? It appears you are likely an end user because of the terminology you use ("edit records"). Oracle is a relational database management system (RDBMS). It contains rows of data, not records. It is not a GUI application like MS Access or Excel. I sincerely hope you are not accessing a production database because you are likely to cause real problems without even knowing it. I suggest you get some real training on databases before going much further.
maybe you really want ORACLE Discoverer.
Ed Received on Wed Apr 01 2009 - 08:38:30 CDT