 |
|
Oracle Tips by Burleson |
Chapter 3 - Time-Based Job Scheduling
Complex Date Rules
for Job Execution
my_schedule_function.sql
--
*************************************************
-- Copyright © 2005 by Rampant TechPress
-- This script is free for non-commercial
purposes
-- with no warranties. Use at your own risk.
--
-- To license this script for a commercial
purpose,
-- contact info@rampant.cc
--
*************************************************
-- Requires the following grant:
-- grant select on v_$database to job_user;
--
**********************************************************
CREATE OR REPLACE FUNCTION my_schedule_function
(
p_timestamp IN TIMESTAMP)/
RETURN TIMESTAMP
AS
l_db_name v$database.name%TYPE;
l_timestamp TIMESTAMP;
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
