Hi , i have a small requirement, i am using .dot net frame work to show a pop up on desktop like reminder , can i do that using any oracle tools i am using oracle 10g along with forms 6i , i am using one query for this.
Well its not necesarry to be done in forms 6i , i am just pondering few options by
which we can achieve this objective , might be some easier way like i create views and based on schedule a pop displays on desktop.
For example there is one table for employee documents which maintains their passport information like when it is expiring.Befor one month of expiration date the pop up alerts the concerned user stating that some passports are due for renewal.
create table emp_docu ( emp_no varchar2(20),edoc varchar2(3),exp_dt date)
insert into emp_docu VALUES ('A','PP','30-NOV-2012')
insert into emp_docu VALUES ('B','PP','15-FEB-2013')
Since today is 12th november and since the first document falls under 30 days , altert or popup must appear on the screen stating that its due for renewal.
Edited by: Arif75 on Nov 11, 2012 11:36 PM