Home » SQL & PL/SQL » SQL & PL/SQL » trigger
trigger [message #37736] Tue, 26 February 2002 02:19 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
I want to write a trigger which will show 'welcome user_name' when a particular user connects to the database from the sql plus window. How do i do it?

Report message to a moderator

Re: trigger [message #37745 is a reply to message #37736] Tue, 26 February 2002 06:37 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
open the oracle_home/dbs/login.sql

and add this statement

select 'welcome '||user from dual where user='PRATAP';

Report message to a moderator

Previous Topic: Compute Statistics & SQL Performance
Next Topic: Assigning the value of count(*) to a variable?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 10:17:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.