OraFAQ Forum: SQL & PL/SQL » Username as prompt

Home » SQL & PL/SQL » SQL & PL/SQL » Username as prompt

Wed, 25 February 2004 23:54

Rajeev Katyal
Messages: 55
Registered: April 2002

Member

I want to show username and database as prompt instead of usual sql> prompt.

How can we do so?

Thu, 26 February 2004 03:04

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

I use Tom Kyte's method, as explained and demonstrated in the link below:

Previous Topic:	Displaying Averages
Next Topic:	How to drop oracle table

Goto Forum:

]

Current Time: Fri Apr 26 06:11:51 CDT 2024