Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Utilities For Viewing/Editing?

Re: Utilities For Viewing/Editing?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Apr 2006 08:57:39 -0700
Message-ID: <1144425454.869963@yasure.drizzle.com>


Joseph.Koziatek_at_dowjones.com wrote:
> Hi All,
>
>
> I am new to oracle and would like to know if oracle server 9 and 10
> come with any utilities to get a table view / form with cursor
> capablilties. A tool such as Informix's isql and dbaccess gives you a
> simple menu drivin program in an xterm window. You can generate table
> forms for querying, iterating over resultsets, and modifying data.
> Through the menus you can select different database instances to work
> with, alter tables, view table schemas, view indexes, type in queries,
> and so on.
>
> These tools are simple text based tools (no fancy GUI), that run in an
> xterm.
>
>
> Does oracle 9 and 10 come with anything similar?
>
> Joe

Given you are using Oracle 9 and 10 ... cursors are passe. What you should be learning is array processing (bulk collection, bulk binding). Take a look at the Array Processing demo in Morgan's Library at www.psoug.org.

If you are looking for a tool for building simple front-ends take a look at SQL*Developer (download for free from otn.oracle.com), Oracle Forms, and JDeveloper.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Apr 07 2006 - 10:57:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US