OraFAQ Forum: General » GUI or SQLPlus

Home » Other » General » GUI or SQLPlus

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

GUI or SQLPlus [message #285747]

Wed, 05 December 2007 07:33

amitdumbre27
Messages: 4
Registered: October 2007
Location: mumbai

Junior Member

Hi

I have completed my course of Oracle 9i. Since my tutor induce us to use sqlplus rather than OEM console(GUI).
Could you pls tell y we should use sqlplus if GUI is well equipped and easy to use and understand.
what industry demands?

Amit

Report message to a moderator

Re: GUI or SQLPlus [message #285751 is a reply to message #285747]

Wed, 05 December 2007 07:51

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I believe your tutor didn't have any "industry" demands on mind. It is quite simple: if you learn how to use SQL*Plus and issue statements by yourself, you won't depend on GUI which - some day - might NOT be available. What will you do then?

Report message to a moderator

Re: GUI or SQLPlus [message #285752 is a reply to message #285747]

Wed, 05 December 2007 07:51

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use SQL*Plus, it is available everywhere, it does give only what you asked, you know what it does.
GUI is pretty but in the end you don't what it does and what data it gives you.
If you only know how to work with SQL*Plus, you will easely know how to do it with a GUI.
If you only know how to work with a GUI, you will not know how to do it with SQL*Plus.

Regards
Michel

Report message to a moderator

Re: GUI or SQLPlus [message #285864 is a reply to message #285747]

Wed, 05 December 2007 23:20

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

Plus ,

What GUI gives you over SQL*PLUS is some enhanced featured that makes the user comfortable . It just hides some comlex features of Sql*plus .

I personally feel GUI make the user lazy Smile

Rajuvan

Report message to a moderator

Re: GUI or SQLPlus [message #286181 is a reply to message #285747]

Thu, 06 December 2007 13:34

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

It's like learning math, you don't go into an arithmetic class for the first time with a calculator, you need to learn the basics first.
As you advance, the calculator becomes a tool to make things quicker, but if your calculator died, you would still be able to solve the problems.

A GUI is the same thing, a very valuable tool, but it should never be used to cover up lack of knowledge, but to help a developer be more productive.

I resisted GUI's for a long time, and succumbed about 3 years ago. I'm glad I did. I still go back to SQL*Plus on occasion just to keep my basic skills up to par.

[Updated on: Thu, 06 December 2007 14:14]

Report message to a moderator

Re: GUI or SQLPlus [message #286267 is a reply to message #286181]

Fri, 07 December 2007 01:23

Frank
Messages: 7901
Registered: March 2000

Senior Member

MarcL wrote on Thu, 06 December 2007 20:34

I still go back to SQL*Plus on occasion just to keep my basic skills up to par.

Or simply because starting the GUI is too much trouble Smile

Good post, MarcL!

Report message to a moderator

Previous Topic:	Explain Plan, Analyse
Next Topic:	oracle 9i features

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 20:18:24 CST 2024