Is oracle meant to be accessed from other available tools
programatically and SQL* Plus is for demonstration purpose only?
Why Oracle do not design a good tool to execute SQL queries.
I found the Oracle SQL*Plus to be very non-user friendly (This is my
opinion).
What to do with the query outputs that wraps on the screen?

"Sameer" <dolpheen@gmail.com> a écrit dans le message de news: 1140349971.953720.233740@g47g2000cwa.googlegroups. com...
| Is oracle meant to be accessed from other available tools
| programatically and SQL* Plus is for demonstration purpose only?
| Why Oracle do not design a good tool to execute SQL queries.
| I found the Oracle SQL*Plus to be very non-user friendly (This is my
| opinion).
| What to do with the query outputs that wraps on the screen?
|

Increase line size.

Regards
Michel Cadot

Comment embedded

On 19 Feb 2006 03:52:51 -0800, "Sameer" <dolpheen@gmail.com> wrote:

>Is oracle meant to be accessed from other available tools
>programatically and SQL* Plus is for demonstration purpose only?

Sql*plus is definitely not for demonstration purposes only, it is the
swiss knife in Oracle. For front-end purposes there are other tools
like Developer and JDeveloper. And JDeveloper is free.

>Why Oracle do not design a good tool to execute SQL queries
It did, it is called Sql*plus. If you can't live with Sql*plus having
been brainwashed by the Evil Empire of Bill Gates, download
Sqldeveloper at http://otn.oracle.com
>I found the Oracle SQL*Plus to be very non-user friendly (This is my
>opinion).
Actually sql*plus was preceded by a tool called UFI.
UFI was an acronym for User Friendly Interface.

Anything wrong with the commandline? Will we hear from you again, once
you developed a mouse arm, or other forms of Repetitive Strain Injury?

>What to do with the query outputs that wraps on the screen?
set linesize <n>
Please read the Sql*plus users manual, and notice you can output in
HTML format.

--
Sybrand Bakker, Senior Oracle DBA

On 19 Feb 2006, dolpheen@gmail.com wrote:
> Is oracle meant to be accessed from other available tools
> programatically and SQL* Plus is for demonstration purpose only?
> Why Oracle do not design a good tool to execute SQL queries.

SQLPlus is the single tried and true interface.

>
> I found the Oracle SQL*Plus to be very non-user friendly (This is my
> opinion).

SQLPlus, by itself is quite a bit frustrating, but I love the power of
its simplicity, so I combine it with an editing environment which is
powerful.

> What to do with the query outputs that wraps on the screen?

Increase the line width.
--
Galen Boyer

On Sun, 19 Feb 2006 03:52:51 -0800, Sameer wrote:

> Is oracle meant to be accessed from other available tools
> programatically and SQL* Plus is for demonstration purpose only?
> Why Oracle do not design a good tool to execute SQL queries.
> I found the Oracle SQL*Plus to be very non-user friendly (This is my
> opinion).
> What to do with the query outputs that wraps on the screen?

Use raptor. It's free and is much more suitable for people lost
without gooey interface.

--
http://www.mgogala.com

On Sun, 19 Feb 2006 18:07:01 +0000, Mladen Gogala wrote:

>
> Use raptor. It's free and is much more suitable for people lost
> without gooey interface.

I concur.

Just be aware that Project Raptor is being renamed to SQL Developer.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***