CAAB - Codes for Australian Aquatic Biota

select sysdate from dual

select max(date_modified) as ld from taxon_details

select * from category  where category_name is not null order by category_name

Application Variables:
applicationname=ABCD
ISRAILO=true
ldap_password=Epic99Failure
ldap_username=sa-cmardatacentre
MNF_OPS_DB=Struct (4)
WOV_VOYAGE=

CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=
cert_secretkeysize=
cert_serialnumber=
cert_server_issuer=
cert_server_subject=
cert_subject=
cf_template_path=/srv/www/htdocs/data/caab/index.cfm
content_length=0
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=gzip
http_accept_language=
http_connection=Keep-Alive
http_cookie=
http_host=ogc-cdc.it.csiro.au
http_referer=
http_user_agent=CCBot/2.0 (https://commoncrawl.org/faq/)
https=on
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=127.0.0.2
local_host=ogc-cdc
path_info=
path_translated=/srv/www/htdocs/data/caab/index.cfm
query_string=
remote_addr=140.79.3.24
remote_host=140.79.3.24
remote_user=
request_method=GET
request_url=https://ogc-cdc.it.csiro.au/data/caab/index.cfm
script_name=/data/caab/index.cfm
server_name=ogc-cdc.it.csiro.au
server_port=443
server_port_secure=1
server_protocol=HTTP/1.1
server_software=
web_server_api=

Cookie Variables:
cfid=3d602121-e4fb-4d8a-93d4-86f12941306b
cftoken=0

Form Variables:
category_code=
cn_name=
highlight=N
q=
sci_name=
tn_name=

Request Variables:
admin_caab=false
admin_dap=false
admin_dc=false
admin_equipment=false
admin_gsm=false
admin_mnf=false
admin_tracking=false
admin_wov=false
airchem_processing=false
airchem_user=false
banner=https://research.csiro.au/software/wp-content/uploads/sites/6/2014/12/cropped-AR1380-crop.jpg
caab_db=caab
cmar_db=cmar
datacentre_developers=dave.watts@csiro.au,pamela.brodie@csiro.au,francis.chui@csiro.au,peter.shanks@csiro.au
datasource=warehouse
dbtype=oracle
earth_bright_base_layer=ea-be:World_Bright-Earth-e-Atlas-basemap_No-Labels
equipment_root=/data/files/equipment/
extra_breadcrumbs=&nbsp;<b>&raquo;</b>&nbsp; <a href="/data/caab/">CAAB - Codes for Australian Aquatic Biota</a>
file_root=/srv/www/htdocs/data/caab/
fishmap_layer=caab:CAAB_FISHMAP
fishmap_spcode=SPCODE
global_message=
group_name=Scientific Data Systems
home=data/ops
include_login_form=false
is_ship=false
jquery_root=/data/common/jquery/
marlin_db=marlin
marlin_version=2
media_root=/data/common/web_media/
mest_db=mest
mnf_db=mnf
mnf_only=false
module_root=/data/common/cfc/
obis_db=obis
openlayers_root=/data/common/openlayers/
oracle=true
security_filter= and security_code = 1
server=http://www.cmar.csiro.au
ship_db=warehouse
ship_test=false
team_name=O&A Information and Data Centre
temp_root=/data/temp
title=CAAB - Codes for Australian Aquatic Biota
underway_db=underway
url=Struct (20)
warehouse_db=warehouse
warehouse_dev=warehouse_dev
web_root=/data/caab
worms_endpoint=http://www.marinespecies.org/aphia.php?p=soap&wsdl=1
worms_lsid=urn:lsid:marinespecies.org:taxname:
worms_url=http://www.marinespecies.org/aphia.php?p=taxdetails&id=
wov_db=warehouse

Server Variables:
coldfusion=Struct (9)
java=Struct (8)
lucee=Struct (8)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)

Session Variables:
cfid=3d602121-e4fb-4d8a-93d4-86f12941306b
cftoken=0
lastvisit={ts '2018-09-22 17:59:13'}
sessionid=ABCD_3d602121-e4fb-4d8a-93d4-86f12941306b_0
timecreated={ts '2018-09-22 17:59:13'}
urltoken=CFID=3d602121-e4fb-4d8a-93d4-86f12941306b&CFTOKEN=0