Home » SQL & PL/SQL » SQL & PL/SQL » message displaying
message displaying [message #250949] Wed, 11 July 2007 23:44 Go to next message
Messages: 30
Registered: August 2006
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: 63956
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".

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

Current Time: Fri Oct 28 14:48:52 CDT 2016

Total time taken to generate the page: 0.21684 seconds