Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> invoking login.sql from connect ?

invoking login.sql from connect ?

From: <learmog_at_my-dejanews.com>
Date: Tue, 29 Sep 1998 14:16:14 GMT
Message-ID: <6uqq3e$78i$1@nnrp1.dejanews.com>


Is it possible to automatically invoke a sql script e.g. login.sql when using the connect command within SQL*Plus ? I currently have a login.sql that sets my prompt based on the v$database.name. The only problem is once logged in if I re-connect to another DB, the prompt doesn't get changed accordingly. Any ideas ?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 29 1998 - 09:16:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US