Home » Other » General » GUI or SQLPlus
GUI or SQLPlus [message #285747] Wed, 05 December 2007 07:33 Go to next message
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
Re: GUI or SQLPlus [message #285751 is a reply to message #285747] Wed, 05 December 2007 07:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: GUI or SQLPlus [message #285752 is a reply to message #285747] Wed, 05 December 2007 07:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: GUI or SQLPlus [message #285864 is a reply to message #285747] Wed, 05 December 2007 23:20 Go to previous messageGo to next message
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

Thumbs Up
Rajuvan
Re: GUI or SQLPlus [message #286181 is a reply to message #285747] Thu, 06 December 2007 13:34 Go to previous messageGo to next message
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 Go to previous message
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!
Previous Topic: Explain Plan, Analyse
Next Topic: oracle 9i features
Goto Forum:
  


Current Time: Thu Mar 28 18:19:09 CDT 2024