Results 1 to 2 of 2

Thread: Oracle Command Line question

  1. #1
    Expert Member
    Join Date
    Sep 2005

    Oracle Command Line question


    Could some one explain me in step by step how to start sql plus form command line and work with commands like sql plus editor ... I am working on a new project ..I only got shell access ...


  2. #2
    Contributing Member
    Join Date
    Jun 2006

    Re: Oracle Command Line question

    Once you have logged in, you can connect under a different username with the SQL*Plus CONNECT command. The username and password must be valid for the database. For example, to connect the username TODD to the default database using the password FOX, you could enter


    In the command-line interface, if you omit the username and password, SQL*Plus prompts you for them. You also have the option of typing only the username following CONNECT and omitting the password (SQL*Plus then prompts for the password). Because CONNECT first disconnects you from your current database, you will be left unconnected to any database if you use an invalid username and password in your CONNECT command.

    4 Starting SQL*Plus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.