Results 1 to 2 of 2

Thread: Oracle Command Line question

  1. #1
    Expert Member
    Join Date
    Sep 2005
    Answers
    206

    Oracle Command Line question

    Hello,

    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 ...

    Thanks,
    Suji


  2. #2
    Contributing Member
    Join Date
    Jun 2006
    Answers
    95

    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

    CONNECT TODD/FOX

    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.
Interact