From com.banilejas@codetel.net.do Thu, 25 Oct 2001 12:16:10 -0700 From: "Ramon Estevez" Date: Thu, 25 Oct 2001 12:16:10 -0700 Subject: RE: Instance Name in Sql Prompt Message-ID: MIME-Version: 1.0 Content-Type: text/plain Thanks David, Jack it works !!       Ramon E. Estevez com.banilejas@codetel.net.do Dominican Republic 809-565-3121 -----Mensaje original-----De: root@fatcity.com [mailto:root@fatcity.com]En nombre de David WagonerEnviado el: Thursday, 25 October, 2001 10:22 AMPara: Multiple recipients of list ORACLE-LAsunto: RE: Instance Name in Sql Prompt Add the following to your login.sql or glogin.sql file:   set serveroutput on set termout off column instance new_value prompt_instance select substr(instance_name, 1, 10)instance from v$instance / set sqlprompt "&&prompt_instance> " set termout on     HTH,   david