Hi,

Note:
Server :
TimeZone: PST
Remote Client:
TimeZone: JST

Description:
There's a server (Oracle Database) in U.S., But most of the usage/activity is in Japan. So I have created a table holding the time difference value and a function to manipulate the time difference. This works fine. Now I want to make the time difference entry in the table automatically by DBMS_JOB package or Other means. I need some tips from you.

Thank you!