Geeks Talk

Prepare for your Next Interview




Oracle Command Line question

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


Go Back   Geeks Talk > Databases > Oracle

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 01-02-2007
Expert Member
 
Join Date: Sep 2005
Posts: 110
Thanks: 8
Thanked 27 Times in 15 Posts
suji is on a distinguished road
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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 01-03-2007
Expert Member
 
Join Date: Jun 2006
Posts: 140
Thanks: 2
Thanked 12 Times in 9 Posts
Jim.Anderson is on a distinguished road
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
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle


Thread Tools
Display Modes


Similar Threads

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


All times are GMT -4. The time now is 01:48 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved