Home » SQL & PL/SQL » SQL & PL/SQL » oracle help (oracle10g, solaris10)
oracle help [message #276234] Wed, 24 October 2007 08:22 Go to next message
andreiaoana
Messages: 10
Registered: October 2007
Junior Member
Hello,

I recently installed Oracle10g and now I want to activate/enable/install help for Oracle.

After I connect with my user I want to have access to help commands and auto-completion. How do I do that? Do I need to install something ?

Thank you!

Re: oracle help [message #276235 is a reply to message #276234] Wed, 24 October 2007 08:24 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
What tool do you use?
Re: oracle help [message #276237 is a reply to message #276234] Wed, 24 October 2007 08:27 Go to previous messageGo to next message
andreiaoana
Messages: 10
Registered: October 2007
Junior Member
I connect to my server with ssh, and there I write $ORACLE_HOME/bin/sqlplus.
Thank you!

Re: oracle help [message #276238 is a reply to message #276237] Wed, 24 October 2007 08:30 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
sqlplus has no autocomplete nor (very much) help.
For help, read the docs at http://tahiti.oracle.com
Re: oracle help [message #276239 is a reply to message #276234] Wed, 24 October 2007 08:36 Go to previous messageGo to next message
andreiaoana
Messages: 10
Registered: October 2007
Junior Member
That's not a wonderful news. Is there another application / another way to connect, different than using sqlplus?
I'll document myself, but in the meantime is not a crime to put a question.

Thank you!
Re: oracle help [message #276247 is a reply to message #276234] Wed, 24 October 2007 08:51 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
There are many 3rd party tools to use for development.

TOAD and PL/SQL Developer are two of the more popular ones
Re: oracle help [message #276252 is a reply to message #276239] Wed, 24 October 2007 09:19 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
SQL Developer by Oracle is free for download from http://technet.oracle.com

Sure, it's not a crime to put a question, but as in your license-question: The intended way is the other way around: first read the docs and try to find out things yourself, and when you are stuck, then ask others to help you.

People tend to be more helpful when they get the impression you put some effort in yourself..
Re: oracle help [message #276388 is a reply to message #276252] Thu, 25 October 2007 01:27 Go to previous messageGo to next message
andreiaoana
Messages: 10
Registered: October 2007
Junior Member
I'll take that as an advice Wink.
Re: oracle help [message #276421 is a reply to message #276388] Thu, 25 October 2007 02:17 Go to previous message
andreiaoana
Messages: 10
Registered: October 2007
Junior Member
Btw,

If anybody users sqlplus and wants a little help, he can use:

oracle_server $ $ORACLE_HOME/bin/sqlplus /nolog
SQL> conn xyzt as sysdba
Enter password:
Connected.
SQL> @hlpbld.sql ora_sqlplus:helpus.sql

now you have a lot of command help:

SQL> help index /displays a list of commands
and then to lear how to use a command:
SQL> help <command>

Have a lot of fun!
Previous Topic: DELETION OF DUPLICATE RECORDS
Next Topic: ORA-00001: unique constraint Violation
Goto Forum:
  


Current Time: Fri Feb 07 14:27:59 CST 2025