Profile cover photo
Profile photo
Michael Dockery
14 followers
14 followers
About
Posts

Post has attachment
Oracle_Spatial
This little regex script which removes the Z and M elements from a WKT (Well known text) SELECT   -below contains X, Y, Z, M   sde.st_astext(shape)   --below contains just X and Y ,REGEXP_REPLACE(replace(replace(sde.st_astext(shape),'',''),'ZM ','') ,    ...
Oracle_Spatial
Oracle_Spatial
trek4tech.blogspot.com
Add a comment...

Post has attachment
Oracle_Auditing
create or replace PROCEDURE FGA_AUDIT_PRODECURE (object_schema VARCHAR2, object_name VARCHAR2, policy_name VARCHAR2 ) AS /********************************************************************     author: mdockery     purpose: accumulate count of audit even...
Oracle_Auditing
Oracle_Auditing
trek4tech.blogspot.com
Add a comment...

Post has attachment
SharedComputing
http://boinc.berkeley.edu/ Use the idle time on your computer (Windows, Mac, Linux, or Android) to cure diseases, study global warming, discover pulsars, and do many other types of scientific research. http://folding.stanford.edu/ Protein folding
SharedComputing
SharedComputing
trek4tech.blogspot.com
Add a comment...

Post has attachment
Painting
Paint sprayer (hplv) high pressure low volume Coat with WD40 when done (to protect nozzle) Use break cleaner to remove protective coat before use Make a sprayer stand Blue windshield washer fluid can be used as a thinner (better than water) sprayers have   ...
Painting
Painting
trek4tech.blogspot.com
Add a comment...

Post has attachment
Oracle_SQL_XML_Fun
xml sql fun SELECT xmlclobby  FROM (   select dbms_xmlgen.getxml(Q'[select HIGH_VALUE from SYS.ALL_TAB_PARTITIONS where PARTITION_NAME='PART_INTERVAL_MONTH1']') xmlClobby from dual) ; --this works! SELECT XMLTYPE(          dbms_xmlgen.getxml(Q'[select HIGH_...
Oracle_SQL_XML_Fun
Oracle_SQL_XML_Fun
trek4tech.blogspot.com
Add a comment...

Post has attachment
Tableau_in_the_Face
--<?xml version="1.0" encoding="UTF-8"?> --******************************************* --   Generate KML File (for use in Tableau) --******************************************* select to_clob('<kml>') from dual    union all select to_clob('<Placemark>'|...
Tableau_in_the_Face
Tableau_in_the_Face
trek4tech.blogspot.com
Add a comment...

Post has attachment
Solar
Ideas fun homemade water pump (for water feature) powered by the sun
Solar
Solar
trek4tech.blogspot.com
Add a comment...

Post has attachment
Go-Karting
Go Karting treadmill motor hdpe steering pittman arm Cheap metal rod for tie rods     Tap and die the ends      Pipe for steering column Pvc heated and molded steering wheel
Go-Karting
Go-Karting
trek4tech.blogspot.com
Add a comment...

Post has attachment
DISKPART_and_BOOT
which disk has the recovery dvd or usb? diskpart list disk select disk 0 list volume (make a note of the letter for your dvd or usb) G: (letter of your recovery DVD or usb) cd boot (get a dir listing if you like) bootsect /nt60 c: /mbr    (will restore the ...
DISKPART_and_BOOT
DISKPART_and_BOOT
trek4tech.blogspot.com
Add a comment...

Post has attachment
GIS_SISSIPPI
Oracle Map Viewer (and Spatial Queries and Javascript using 12c v2 API) Common Ref Systems GRS80 = Geodetic Reference System 80 WGS84 = World Geodetic System 1984 NAD27 = North American Datum of 1983 (SRID 26916) Location info using SRID=26916:  y      4,40...
GIS_SISSIPPI
GIS_SISSIPPI
trek4tech.blogspot.com
Add a comment...
Wait while more posts are being loaded