ċ
as_xlsx9.txtDownload
Copy of Anton Scheffer's as_xlsx package modified as follows:
Refactored to separate query2sheet into a "query2sheet" that does the parse and a "cursor2sheet" that does the main work
The "cursor2sheet" can then be called from "refcursor2sheet" which converts a refcursor to a DBMS_SQL cursor.
"refcursor2sheet" relies on 11g functionality
and uses conditional compilation so it is only enabled in that version but can be compiled in 10g.
75k
v. 1
Oct 26, 2011, 9:34 PM
Gary Myers
ċ
COMP_TABLES.SQLDownload
Code to compare the summaries of two data sets (eg tables)
7k
v. 1
Jun 29, 2011, 9:33 PM
Gary Myers
ċ
diff_apex.zipView Download
Use ApexExport to extract an application from two workspaces and perform a comparison.
Requires the apex.jar from the Apex Listener
1k
v. 1
Nov 12, 2011, 1:23 AM
Gary Myers
ċ
FAA_Data.7zDownload
Other Data files for FAA demo data (compressed with 7-zip)
See Blog- Apr 21 2008
4852k
v. 2
Apr 24, 2012, 6:08 PM
Gary Myers
ċ
FAA_MASTER.7zDownload
Master file for FAA demo data (compressed with 7-zip)
See Blog- Apr 21 2008
14373k
v. 2
Apr 24, 2012, 6:08 PM
Gary Myers
ċ
faa_sqls.zipView Download
SQLs for loading FAA Demo data. See Blog- Apr 21 2008
7k
v. 2
Apr 24, 2012, 6:07 PM
Gary Myers
ċ
local_geocode.sqlDownload
From my series: I can see my house from here
10k
v. 1
Jun 18, 2011, 10:40 PM
Gary Myers
ċ
SAXLoader.zipDownload
From my series: I can see my house from here
33k
v. 1
Jun 18, 2011, 10:41 PM
Gary Myers
ċ
TADPOLE_NEW.FMBDownload
Later version of TADPOLE. Probably requires Forms 6i
1244k
v. 1
Jun 18, 2011, 10:35 PM
Gary Myers
ċ
TADPOLE_orig.FMBDownload
Early version of TOAD. Possibly compatible with Forms 5.0
300k
v. 1
Jun 18, 2011, 10:34 PM
Gary Myers
ċ
track.sqlDownload
Table structure and procedures for logging
4k
v. 2
Mar 2, 2011, 6:06 PM
Gary Myers
ċ
util_geocode.pkbDownload
UTL_GEOCODE from my 'I can see my house from here' series
26k
v. 1
Jun 18, 2011, 10:38 PM
Gary Myers
ċ
util_geocode.pksDownload
UTL_GEOCODE from my 'I can see my house from here' series
6k
v. 1
Jun 18, 2011, 10:38 PM
Gary Myers
