Re: Making database name part of SQL prompt in sqlplus [OpenVMS]

--0__=xysmAelcBhHWHZwgVYWypAbCrICLLGjXhBaAquwSBd2o2nEDljkX4Mef Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Sounds good...

How to setup this in openVMS for 6 people?

Franck

|--------+----------------------->


|        |          Deborah      |

|        |          Lorraine     |

|        |          <dlorraine_at_uc|

|        |          davis.edu>   |

|        |                       |

|        |          00-07-07     |

|        |          03:04        |

|        |          Please       |

|        |          respond to   |

|        |          ORACLE-L     |

|        |                       |

|--------+----------------------->
  >----------------------------------------------------------------------------|
  |                                                                            |
  |       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>  |
  |       cc:     (bcc: Franck Vasseur/im/esa/ingerrand)                       |
  |       Subject:     Re: Making database name part of SQL prompt in sqlplus  |
  >----------------------------------------------------------------------------|

Here's our glogin.sql which sets the prompt:

rem SQL*Plus global login startup file. rem
rem Set the SQL prompt to include the database name rem selected from v$parameter
rem
rem set feedb on echo on
set termout off
column value noprint new_value dbname
select value
from v$parameter
where name = 'db_name'
/
set sqlprompt "&dbname:SQL>"
column value print
rem
rem Issue a commit to clear transaction buffer in case rem the user wants to do a 'set transaction ...' rem
commit
/

def _editor=vi
set newpage 0
set pagesize 23
set numwidth 7
set pause on pause '[4mPress enter to continue or ^C to stop[5m...[m' rem
rem Invoke users '.sqlrc' file if it exists rem
@$HOME/.sqlrc
set termout on

At 12:26 PM 7/6/00 , you wrote:

>Anyone know how to do it?
>
>I've got a number of users doing SQL*Plus work and they keep making errors
>as to which instance they are in...
>
>Anyone?
>
>J
>
>--
>Author: Jay Weinshenker
>  INET: jweinshe_at_concentric.net
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California        -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

--0__=xysmAelcBhHWHZwgVYWypAbCrICLLGjXhBaAquwSBd2o2nEDljkX4Mef Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PGh0bWw+DQo8Zm9udCBmYWNlPSJDb3VyaWVyIE5ldywgQ291cmllciI+SGVyZSdzIG91ciBnbG9n aW4uc3FsIHdoaWNoIHNldHMgdGhlDQpwcm9tcHQ6ICA8YnI+DQo8YnI+DQpyZW0mbmJzcDsgU1FM KlBsdXMgZ2xvYmFsIGxvZ2luIHN0YXJ0dXAgZmlsZS48YnI+DQpyZW08YnI+DQpyZW0mbmJzcDsg U2V0IHRoZSBTUUwgcHJvbXB0IHRvIGluY2x1ZGUgdGhlIGRhdGFiYXNlIG5hbWUgPGJyPg0KcmVt Jm5ic3A7IHNlbGVjdGVkIGZyb20gdiRwYXJhbWV0ZXI8YnI+DQpyZW0gPGJyPg0KcmVtIHNldCBm ZWVkYiBvbiBlY2hvIG9uPGJyPg0Kc2V0IHRlcm1vdXQgb2ZmPGJyPg0KY29sdW1uIHZhbHVlIG5v cHJpbnQgbmV3X3ZhbHVlIGRibmFtZTxicj4NCnNlbGVjdCB2YWx1ZTxicj4NCmZyb20gdiRwYXJh bWV0ZXI8YnI+DQp3aGVyZSBuYW1lID0gJ2RiX25hbWUnPGJyPg0KLzxicj4NCnNldCBzcWxwcm9t cHQgJnF1b3Q7JmFtcDtkYm5hbWU6U1FMJmd0OyZxdW90Ozxicj4NCmNvbHVtbiB2YWx1ZSBwcmlu dDxicj4NCnJlbTxicj4NCnJlbSZuYnNwOyBJc3N1ZSBhIGNvbW1pdCB0byBjbGVhciB0cmFuc2Fj dGlvbiBidWZmZXIgaW4gY2FzZSA8YnI+DQpyZW0mbmJzcDsgdGhlIHVzZXIgd2FudHMgdG8gZG8g YSAnc2V0IHRyYW5zYWN0aW9uIC4uLic8YnI+DQpyZW08YnI+DQpjb21taXQ8YnI+DQovPGJyPg0K PGJyPg0KZGVmIF9lZGl0b3I9dmk8YnI+DQpzZXQgbmV3cGFnZSAwPGJyPg0Kc2V0IHBhZ2VzaXpl IDIzPGJyPg0Kc2V0IG51bXdpZHRoIDc8YnI+DQpzZXQgcGF1c2Ugb24gcGF1c2UgJ1s0bVByZXNz IGVudGVyIHRvIGNvbnRpbnVlIG9yIF5DIHRvDQpzdG9wWzVtLi4uW20nPGJyPg0KcmVtPGJyPg0K cmVtJm5ic3A7Jm5ic3A7IEludm9rZSB1c2VycyAnLnNxbHJjJyBmaWxlIGlmIGl0IGV4aXN0czxi cj4NCnJlbTxicj4NCkAkSE9NRS8uc3FscmM8YnI+DQpzZXQgdGVybW91dCBvbjxicj4NCjxicj4N Cjxicj4NCjxicj4NCjwvZm9udD5BdCAxMjoyNiBQTSA3LzYvMDAgLCB5b3Ugd3JvdGU6PGJyPg0K PGJsb2NrcXVvdGUgdHlwZT1jaXRlIGNpdGU+QW55b25lIGtub3cgaG93IHRvIGRvIGl0Pzxicj4N Cjxicj4NCkkndmUgZ290IGEgbnVtYmVyIG9mIHVzZXJzIGRvaW5nIFNRTCpQbHVzIHdvcmsgYW5k IHRoZXkga2VlcCBtYWtpbmcNCmVycm9ycyBhcyB0byB3aGljaCBpbnN0YW5jZSB0aGV5IGFyZSBp bi4uLjxicj4NCjxicj4NCkFueW9uZT88YnI+DQo8YnI+DQpKPGJyPg0KPGJyPg0KLS0gPGJyPg0K QXV0aG9yOiBKYXkgV2VpbnNoZW5rZXI8YnI+DQombmJzcDtJTkVUOiBqd2VpbnNoZUBjb25jZW50 cmljLm5ldDxicj4NCjxicj4NCkZhdCBDaXR5IE5ldHdvcmsgU2VydmljZXMmbmJzcDsmbmJzcDsm bmJzcDsgLS0gKDg1OCkgNTM4LTUwNTEmbmJzcDsgRkFYOg0KKDg1OCkgNTM4LTUwNTE8YnI+DQpT YW4gRGllZ28sIENhbGlmb3JuaWEmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsgLS0gUHVibGljDQpJbnRlcm5ldCBhY2Nlc3MgLyBNYWlsaW5nIExpc3RzPGJyPg0KLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS08YnI+DQpUbyBSRU1PVkUgeW91cnNlbGYgZnJvbSB0aGlzIG1haWxpbmcgbGlzdCwg c2VuZCBhbiBFLU1haWwgbWVzc2FnZTxicj4NCnRvOiBMaXN0R3VydUBmYXRjaXR5LmNvbSAobm90 ZSBFWEFDVCBzcGVsbGluZyBvZiAnTGlzdEd1cnUnKSBhbmQgaW48YnI+DQp0aGUgbWVzc2FnZSBC T0RZLCBpbmNsdWRlIGEgbGluZSBjb250YWluaW5nOiBVTlNVQiBPUkFDTEUtTDxicj4NCihvciB0 aGUgbmFtZSBvZiBtYWlsaW5nIGxpc3QgeW91IHdhbnQgdG8gYmUgcmVtb3ZlZCBmcm9tKS4mbmJz cDsgWW91DQptYXk8YnI+DQphbHNvIHNlbmQgdGhlIEhFTFAgY29tbWFuZCBmb3Igb3RoZXIgaW5m b3JtYXRpb24gKGxpa2UgDQpzdWJzY3JpYmluZykuPGJyPg0KPC9ibG9ja3F1b3RlPjwvaHRtbD4N Received on Fri Jul 07 2000 - 10:29:09 CDT