Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Complex Date Rules for Job Execution

            test_timestamp_string.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
-- *************************************************

set serveroutput on;
alter session set nls_timestamp_format = 'DD-MON-YYYY HH24:MI:SS';
 
CREATE OR REPLACE PROCEDURE test_timestamp_string(
  p_interval    IN  VARCHAR2,
  p_iterations  IN  NUMBER DEFAULT 5)
AS
  l_interval         VARCHAR2(1000) := p_interval;
  l_start_ts         TIMESTAMP := TO_TIMESTAMP('01-JAN-2004 03:04:32',
                                               'DD-MON-YYYY HH24:MI:SS');
 
  l_next_run_ts      TIMESTAMP;
  l_start_ts_str     VARCHAR2(100);

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA