Prepare for your Next Interview
This is a discussion on Oracle Command Line question within the Oracle forums, part of the Databases category; 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 ...
|
|||
|
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 |
| Sponsored Links |
|
|||
|
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 |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Is there any Limit in command line arguments | norman | Oracle | 1 | 10-15-2007 06:41 AM |
| Running QTP from command line | sanitha | QTP | 1 | 06-05-2007 04:34 PM |
| base line document | yagnkan | Test Cases | 5 | 02-12-2007 02:50 PM |
| Oracle package question | always_rgsm | Oracle | 5 | 01-23-2007 08:35 AM |
| How to continue to next line | timmy | Unix/Linux | 1 | 08-20-2006 01:16 AM |