On Thu, 19 Jun 2003 05:04:26 GMT, "SPIDERMAN"
<consultant2b_at_hotmail.com> wrote:
>I don't know much about Oracle (except for the PL?SQL), so please bear with
>me. I was just wondering if there was a way to create an alert triggered by
>user signing on? I want to create an alert as a pop up dialog box (java
>function call?) that list the names of the people having birthdays (names
>and DOB's stored in a table) the following day. Can I make this as a trigger
>based on the fact that some table is automatically modified when user sign
>on? If so, what is the name of this table? What are the steps I need to
>accomplish this? Any inputs are greatly appreciated.
>
You can make a trigger do anything you want it to do, within the
capabilities of PL/SQL. As to what you can use to fire the trigger,
take a look at the SQL Reference. Hint: in the chapter on triggers,
there is a 'database event' called 'logon'
Received on Thu Jun 19 2003 - 08:08:07 CDT
