1
Answer

Oracle Spatial and Locater

Arjun Panwar

Arjun Panwar

12y
2k
1
HI,


My question is about the in oracle what is Oracle Spatial and what is the difference between the Oracle Spatial and Locator?


Thanks
Answers (1)
1
Manas Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 9y
Hi Paras,
ASP.NET 
You need to implement upload image file and store files in directory. And also store expiry date in database.
 
Windows Service 
In second phase you need to create a service which will run daily to check expiry date. 
0
Paras Solanki

Paras Solanki

NA 6 706 9y
please provide solution in c# asp.net
0
Manas Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 9y
Hi Paras,
 
I am giving you couple of solutions:
 
Solution 1: 
When a user upload image to server -  store the expiry date(as per your policy 30,60,90 days) for that image in database.
 
Create a windows service which will run daily basis(once in a day) which will all the records to expiry from database.  It will check system today date with database expiry date for image. If it matches then delete the file or what ever you want. This logic you need to implement in windows service.
 
Just see the below link how to create a windows service: 
 
Solutions 2 :
 When a user upload image to server - store the expiry date(as per your policy 30,60,90 days) for that image in database.
 
Assume that images are user specific(it helps only image are user specific otherwise not a feasible solution).
 
Before displaying image to user you need to check the database expiry date - if it matches with server current date then you display alert message or image expired message.
Next Recommended Forum