Re: Edit records with an Oracle client
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 01 Apr 2009 18:52:53 +0200
Message-ID: <49d39be6$0$185$e4fe514c_at_news.xs4all.nl>
Ed Prochak schreef:
> On Mar 31, 6:55 pm, francan <franca..._at_yahoo.com> wrote:
>
> 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
>
Date: Wed, 01 Apr 2009 18:52:53 +0200
Message-ID: <49d39be6$0$185$e4fe514c_at_news.xs4all.nl>
Ed Prochak schreef:
> 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
>
With Oracle Discoverer one can not edit records...
Shakespeare Received on Wed Apr 01 2009 - 11:52:53 CDT