GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  General
Go To First  |  Previous Question  |  Next Question 
 General  |  Question 199 of 211    Print  
hi!!!
I want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string...what should i do with login.sql script.. i Put it in /Bin directory..but not working..

any Idea..?

thanx in Advance!!

  
Total Answers and Comments: 7 Last Update: December 27, 2008     Asked by: Nitina 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 23, 2006 05:52:36   #1  
akhileshkaddi        

RE: hi!!!I want to know that..is there any speci...

create a SQL PLUS shortcut select the short cut right click and select properties options.

u will see the TARGET option over there type in the user/password@schema at the end of the text

target :- C:oracleora92binsqlplusw.exe user/password@schema

type of the text which bold in this mail.

let me know if this work for u. or any doubts


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
June 28, 2006 06:29:46   #2  
vik        

RE: hi!!!I want to know that..is there any speci...

and also u can specify the short key also after target set the shortcut key

like ctrl+alt+(S- Sql) then from next time onwards just press ctrl+alt+s


 
Is this answer useful? Yes | No
August 31, 2006 03:19:43   #3  
priya        

RE: hi!!!I want to know that..is there any speci...

Hi
I tried to provide the username/password@schemaname in the target box at the end as you mentioned. But Make sure the path and file name is correct alert is coming.


 
Is this answer useful? Yes | No
September 25, 2006 05:11:48   #4  
lokesh        

RE: hi!!!I want to know that..is there any speci...

Hi Dear

it's working fine

Thanks

lokesh


 
Is this answer useful? Yes | No
October 11, 2006 11:14:11   #5  
dev        

RE: hi!!!I want to know that..is there any speci...

Hey

It's working nicely.

Thanks.


 
Is this answer useful? Yes | No
December 12, 2006 00:23:00   #6  
sravan1 Member Since: September 2006   Contribution: 10    

RE: hi!!!I want to know that..is there any speci...

Good tip. working great.. thanks


 
Is this answer useful? Yes | No
December 27, 2008 08:39:01   #7  
kumars77 Member Since: April 2008   Contribution: 4    

RE: hi!!!I want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string...what should i do with login.sql script.. i Put it in /Bin directory..but not working..any

Right click on SQLPLUS icon on desktop and place username/password in target box after existing path e.g
C:oracleora92binsqlplusw.exe username/password


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape