Home » SQL & PL/SQL » SQL & PL/SQL » message displaying
message displaying [message #250949] Wed, 11 July 2007 23:44 Go to next message
hamidmahmood
Messages: 30
Registered: August 2006
Member
Assalamu Alaikum,


i have a problem i need a message of reminder.when any one login

in such a case for example when any product(s) expire date come

it display message before a week that this product(s) will be

expire with in 7 days .it display message till when expire date

is equll to system date.
Re: message displaying [message #250965 is a reply to message #250949] Thu, 12 July 2007 01:31 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Display? How the server can display?
Display is just a client side thing.
For instance, your application can check a table MOT (Message Of Today) and displays it to the user.

In SQL*Plus, you can have a logon trigger that uses dbms_output but this assumes that each user executes "set serveroutput on".

Regards
Michel
Previous Topic: sum the next both tuples
Next Topic: Pivot
Goto Forum:
  


Current Time: Tue Dec 06 13:52:49 CST 2016

Total time taken to generate the page: 0.10746 seconds