Get Division Dates

Posted on By David Kittell 
SELECT DIVISION_NBR
	,YMDEFF
	,YMDEND
	,YMDTRANS
FROM division_span
WHERE rownum < 10
	AND division_nbr = '<div_number_to_search>'
Originally Posted on June 24, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Amisys Code Oracle SQL

Related Posts

DirecTV – API JSON Service

Posted on

If you have your DirecTV Unit plugged into your network at home you could run a couple fun commands. #!/bin/sh # DirecTV.sh # # # Created by David Kittell on 1/3/18. # # Variables – Start unitIP="<IP ADDRESS>" # Variables – Stop # Get Unit Serial Number json=$(curl -s -X…

Read More

Find Table Differences And Sync Tables

Posted on

Have two databases with the same table schema and need to keep both up to date? First, let us look at the differences between the two databases. The query below will show the differences between the development database table tbl_zip_code and the production database table tbl_zip_code. Ideally the differences should…

Read More

Ektron Find Replace In Library

Posted on

This script will search and replace specific library links SET XACT_ABORT ON DECLARE @currurl NVARCHAR(500) DECLARE @newurl NVARCHAR(500) DECLARE @search NVARCHAR(500) DECLARE @replace VARCHAR(500) SET @search = ” –string to find SET @replace = ” –replacement string DECLARE @pos INT DECLARE @id BIGINT BEGIN TRAN DECLARE curs CURSOR LOCAL FAST_FORWARD…

Read More