MENU
last data update: 2011/10/20, 19:31
Website loading time
during the test: 0.55 s
cable connection (average): 0.76 s
DSL connection (average): 0.97 s
modem (average): 12.08 s
HTTP headers
HTTP/1.1 200 OK
Date: Fri, 21 Oct 2011 02:31:51 GMT
Server: Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4
Last-Modified: Fri, 28 May 2010 14:36:01 GMT
ETag: "6a50e72-142f7-487a86d121640"
Accept-Ranges: bytes
Content-Length: 82679
Connection: close
Content-Type: text/html
Information about DNS servers
adp-gmbh.ch | MX | 10 | mx01.tophost.ch | IN | 14047 |
adp-gmbh.ch | MX | 10 | mx02.tophost.ch | IN | 14047 |
adp-gmbh.ch | NS | ns98.tophost.ch | IN | 42847 | |
adp-gmbh.ch | NS | ns97.tophost.ch | IN | 42847 |
Received from the first DNS server
Request to the server "adp-gmbh.ch"
You used the following DNS server:
DNS Name: ns98.tophost.ch
DNS Server Address: 194.150.249.242#53
DNS server aliases:
HEADER opcode: REQUEST, status: NOERROR, id: 61957
flag: qr aa rd REQUEST: 1, ANSWER: 6, AUTHORITY: 0, ADDITIONAL: 0
REQUEST SECTION:
adp-gmbh.ch. IN ANY
ANSWER SECTION:
adp-gmbh.ch. 14400 IN MX 10 mx01.tophost.ch.
adp-gmbh.ch. 14400 IN MX 10 mx02.tophost.ch.
adp-gmbh.ch. 86400 IN SOA ns97.tophost.ch. admin.novatrend.ch. 2010052504 86400 7200 3600000 86400
adp-gmbh.ch. 86400 IN NS ns97.tophost.ch.
adp-gmbh.ch. 86400 IN NS ns98.tophost.ch.
adp-gmbh.ch. 14400 IN A 194.150.248.242
Received 185 bytes from address 194.150.249.242#53 in 89 ms
Received from the second DNS server
Request to the server "adp-gmbh.ch"
You used the following DNS server:
DNS Name: ns97.tophost.ch
DNS Server Address: 194.150.248.242#53
DNS server aliases:
HEADER opcode: REQUEST, status: NOERROR, id: 13586
flag: qr aa rd REQUEST: 1, ANSWER: 6, AUTHORITY: 0, ADDITIONAL: 0
REQUEST SECTION:
adp-gmbh.ch. IN ANY
ANSWER SECTION:
adp-gmbh.ch. 14400 IN MX 10 mx02.tophost.ch.
adp-gmbh.ch. 14400 IN MX 10 mx01.tophost.ch.
adp-gmbh.ch. 86400 IN SOA ns97.tophost.ch. admin.novatrend.ch. 2010052504 86400 7200 3600000 86400
adp-gmbh.ch. 86400 IN NS ns98.tophost.ch.
adp-gmbh.ch. 86400 IN NS ns97.tophost.ch.
adp-gmbh.ch. 14400 IN A 194.150.248.242
Received 185 bytes from address 194.150.248.242#53 in 92 ms
Subdomains (the first 50)
Typos (misspells)
zdp-gmbh.ch sdp-gmbh.ch wdp-gmbh.ch qdp-gmbh.ch asp-gmbh.ch axp-gmbh.ch acp-gmbh.ch afp-gmbh.ch arp-gmbh.ch aep-gmbh.ch ado-gmbh.ch adl-gmbh.ch ad--gmbh.ch ad0-gmbh.ch adp0gmbh.ch adppgmbh.ch adp-fmbh.ch adp-vmbh.ch adp-bmbh.ch adp-hmbh.ch | adp-ymbh.ch adp-tmbh.ch adp-gnbh.ch adp-gkbh.ch adp-gjbh.ch adp-gmvh.ch adp-gmnh.ch adp-gmhh.ch adp-gmgh.ch adp-gmbg.ch adp-gmbb.ch adp-gmbn.ch adp-gmbj.ch adp-gmbu.ch adp-gmby.ch dp-gmbh.ch ap-gmbh.ch ad-gmbh.ch adpgmbh.ch adp-mbh.ch | adp-gbh.ch adp-gmh.ch adp-gmb.ch dap-gmbh.ch apd-gmbh.ch ad-pgmbh.ch adpg-mbh.ch adp-mgbh.ch adp-gbmh.ch adp-gmhb.ch aadp-gmbh.ch addp-gmbh.ch adpp-gmbh.ch adp--gmbh.ch adp-ggmbh.ch adp-gmmbh.ch adp-gmbbh.ch adp-gmbhh.ch |
Location
IP: 194.150.248.242
continent: EU, country: Switzerland (CHE), city:
Website value
rank in the traffic statistics:
There is not enough data to estimate website value.
Basic information
website build using CSS
code weight: 80.74 KB
text per all code ratio: 66 %
title: René Nyffenegger on Oracle
description:
keywords:
encoding: utf-8
language: en
Website code analysis
one word phrases repeated minimum three times
two word phrases repeated minimum three times
three word phrases repeated minimum three times
B tags
dim
CreateObject
set obj_var = new obj_type
Oracle's Instant Client for Microsoft Windows (32-bit)
c:oracleinstantclient_11_1
odbc_install.exe
ora11
c:oracle nsnames.ora
newora11
RegCreateKey
RegSetValueEx
RegQueryValueEx
RegCloseKey
add_env_vars
c:Oracle
TNS_ADMIN
get current value for %PATH%
First, length of current %PATH%
PATH
then: actual value of PATH
chop trailing chr(0) from path
append path to oci.dll
Propagate changes in environment variables
create_odbc_datasource
DAOTest
SOFTWAREODBCODBC.INI
ODBCName
ServerName
Description
Driver
UserID
SOFTWAREODBCODBC.INIODBC Data Sources
odbccp32.cpl
Note the [] instead of the "" in order to prevent a 3450 incomplete query clause
theAutonumberField
not null
@id = 2
let $num
return $num
text()
for
in
" "
order by $num/text()
$num/text()
@id
order by $num/@id
number
where number($num/@id) > 5
id_p
id
amt
desc
last_level
level_
r.level_ < last_level
r.level_ = last_level
r.level_ > last_level
adlv.................... 14
cisw.................... 75
inc.sql
inc2.sql
inc3.sql
U tags
I tags
Visual Basic Script
runVBAFilesInExcel.vbs
.bas
System DSN
strange
an_xml_doc.xml
text()
for .. in
id
number
id of parent
adlv
cisw
ciswx
ciswy
CISWXZ1
CISWXZ2
CISWXZ3
CISWY1
rownum_ desc
... more records snipped ...
level_
level_ - 1
sum_on_level
total_sum_on_level
level_:
cumulated sum of amt:
nodes
info
amt
rownum_
reversed
node object type
node
hierarchical_values
node_t
do_sum
phw.sql
inc.sql
Hello world
print.sql
second line
magic
inc3.sql
buffer
c: empprint.spooled
images
headers
H1
René Nyffenegger on Oracle
H2
November 14, 2009: On DAO, ODBC and Oracle
October 8, 2009: On XML Queries
September 29, 2009: On summing up values in nodes of a hierarchical query
March 15, 2008: On including files in SQL*Plus
Older on Oracle articles
Older news
H3
November 14, 2009: On DAO, ODBC and Oracle
October 8, 2009: On XML Queries
September 29, 2009: On summing up values in nodes of a hierarchical query
March 15, 2008: On including files in SQL*Plus
Older on Oracle articles
Older news
H4
H5
H6
internal links
address | anchor text |
---|---|
http://www.adp-gmbh.ch/misc/most_wanted.html | Most wanted |
http://www.adp-gmbh.ch/feedback.html | Feedback |
http://www.adp-gmbh.ch/rss.xml | here |
http://www.adp-gmbh.ch/ora/admin/instance.html | Oracle Instance |
ora/network/net_service_name.html | net service name |
ora/network/tnsnames_ora.html | tnsnames.ora |
http://www.adp-gmbh.ch/ora/misc/env_vars.html#tns_admin | TNS_ADMIN |
http://www.adp-gmbh.ch/win/misc/environment_variables.html#path | PATH |
http://www.adp-gmbh.ch/blog/2009/11/14.php | http://www.adp-gmbh.ch/blog/2009/11/14.php |
http://www.adp-gmbh.ch/ora/sqlplus/set.html | set |
http://www.adp-gmbh.ch/ora/sqlplus/serveroutput.html | serveroutput |
http://www.adp-gmbh.ch/ora/plsql/block.html | declare |
http://www.adp-gmbh.ch/ora/plsql/dbms_xdb.html#createresource | dbms_xdb |
http://www.adp-gmbh.ch/ora/plsql/dbms_output.html#put_line | dbms_output |
http://www.adp-gmbh.ch/ora/sql/select.html | select |
http://www.adp-gmbh.ch/ora/sql/xml/xmlquery.html | XMLQuery |
http://www.adp-gmbh.ch/ora/misc/dual.html | dual |
http://www.adp-gmbh.ch/ora/sqlplus/index.html | SQL*Plus |
http://www.adp-gmbh.ch/ora/misc/datatypes/long.html | longs |
http://www.adp-gmbh.ch/ora/sqlplus/set.html | set |
http://www.adp-gmbh.ch/ora/sqlplus/long.html | long |
http://www.adp-gmbh.ch/blog/2009/10/08.php | http://www.adp-gmbh.ch/blog/2009/10/08.php |
http://www.adp-gmbh.ch/ora/sql/create_table.html | create table |
http://www.adp-gmbh.ch/ora/misc/datatypes/number.html | number |
http://www.adp-gmbh.ch/ora/misc/integrity_constraints.html#pk | primary key |
http://www.adp-gmbh.ch/ora/misc/datatypes/varchar2.html | varchar2 |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/sql/create_view.html | create view |
http://www.adp-gmbh.ch/ora/sql/rownum.html | rownum |
http://www.adp-gmbh.ch/ora/sql/level.html | level |
http://www.adp-gmbh.ch/ora/sql/substr.html | substr |
http://www.adp-gmbh.ch/ora/sql/lpad.html | lpad |
http://www.adp-gmbh.ch/ora/sql/connect_by.html | start with |
http://www.adp-gmbh.ch/ora/misc/null.html | null |
http://www.adp-gmbh.ch/ora/sql/connect_by.html | connect by |
http://www.adp-gmbh.ch/ora/sqlplus/pagesize.html | set pagesize |
http://www.adp-gmbh.ch/ora/sql/select.html | select |
http://www.adp-gmbh.ch/ora/sql/substr.html | substr |
http://www.adp-gmbh.ch/ora/sql/order_by.html | order by |
http://www.adp-gmbh.ch/ora/sqlplus/pagesize.html | set pagesize |
http://www.adp-gmbh.ch/ora/sql/select.html | select |
http://www.adp-gmbh.ch/ora/sql/substr.html | substr |
http://www.adp-gmbh.ch/ora/sql/order_by.html | order by |
http://www.adp-gmbh.ch/ora/plsql/coll/index.html | collection |
http://www.adp-gmbh.ch/ora/sql/create_type.html | create or replace type |
http://www.adp-gmbh.ch/ora/plsql/oo/constructors.html | constructor |
http://www.adp-gmbh.ch/ora/plsql/oo/member.html | member |
http://www.adp-gmbh.ch/ora/plsql/oo/constructors.html | constructor |
http://www.adp-gmbh.ch/ora/plsql/oo/member.html | member |
http://www.adp-gmbh.ch/ora/plsql/loops.html#cursor | for |
http://www.adp-gmbh.ch/ora/sqlplus/serveroutput.html | set serveroutput |
http://www.adp-gmbh.ch/ora/sql/table_cast.html | table |
http://www.adp-gmbh.ch/ora/plsql/dbms_output.html#put_line | dbms_output |
http://www.adp-gmbh.ch/blog/2009/09/29.php | http://www.adp-gmbh.ch/blog/2009/09/29.php |
http://www.adp-gmbh.ch/ora/sqlplus/index.html | SQL*Plus |
http://www.adp-gmbh.ch/ora/sqlplus/start.html | @ or @@ |
http://www.adp-gmbh.ch/ora/plsql/dbms_output.html#put_line | dbms_output.put_line |
http://www.adp-gmbh.ch/ora/plsql/block.html | begin |
http://www.adp-gmbh.ch/ora/plsql/block.html | end |
http://www.adp-gmbh.ch/ora/sqlplus/serveroutput.html | set serveroutput on |
http://www.adp-gmbh.ch/ora/sqlplus/verify.html | set verify off |
http://www.adp-gmbh.ch/ora/sqlplus/dot.html | . |
http://www.adp-gmbh.ch/ora/sqlplus/sqlterminator.html | set sqlterminator |
http://www.adp-gmbh.ch/ora/sqlplus/termout.html | set termout |
http://www.adp-gmbh.ch/ora/sqlplus/spool.html | spool |
http://www.adp-gmbh.ch/ora/sqlplus/prompt.html | prompt |
http://www.adp-gmbh.ch/ora/sqlplus/input.html | input |
http://www.adp-gmbh.ch/ora/sqlplus/dot.html | . (dot) |
http://www.adp-gmbh.ch/ora/sqlplus/sqlterminator.html | sqlterminator |
http://www.adp-gmbh.ch/ora/sqlplus/termout.html | termout |
http://www.adp-gmbh.ch/ora/sqlplus/spool.html | spooled file |
http://www.adp-gmbh.ch/ora/sqlplus/prompt.html | prompt |
http://www.adp-gmbh.ch/ora/sqlplus/input.html | input |
http://www.adp-gmbh.ch/blog/2008/03/15.php | http://www.adp-gmbh.ch/blog/2008/03/15.php |
http://www.adp-gmbh.ch/blog/2008/03/11.php | On setting commit_write |
http://www.adp-gmbh.ch/blog/2008/01/17.php | On forcing a nested loop join instead of a hash join |
http://www.adp-gmbh.ch/blog/2007/08/07.php | On select into and the too_many_rows and no_data_found exception |
http://www.adp-gmbh.ch/blog/2007/04/22.php | Emulating tables with PL/SQL |
http://www.adp-gmbh.ch/blog/2007/04/14.php | sprintf and printf in PL/SQL |
http://www.adp-gmbh.ch/blog/2007/02/01.php | On importing data from Oracle into Excel with CopyFromRecordset |
http://www.adp-gmbh.ch/blog/2007/01/24.php | On importing data from Oracle into Excel with a Visual Basic for Application macro |
http://www.adp-gmbh.ch/blog/2006/12/31.php | On finding changed values in a table with flashback |
http://www.adp-gmbh.ch/blog/2006/12/03.php | On parametrizing views with contexts |
http://www.adp-gmbh.ch/blog/2006/11/30.php | On creating an AJAX Application with Oracle |
http://www.adp-gmbh.ch/blog/2006/08/20.php | On splitting a string into words with regular expressions |
http://www.adp-gmbh.ch/blog/2006/08/19.php | On generating HTML output with SQL*Plus |
http://www.adp-gmbh.ch/blog/2006/08/13.php | On out parameters |
http://www.adp-gmbh.ch/blog/2006/06/04.php | Comments, finally! |
http://www.adp-gmbh.ch/blog/2006/05/16.php | On travelling back in time with Oracle's Workspace Manager |
http://www.adp-gmbh.ch/blog/2006/05/09.php | On solving workspace conflicts |
http://www.adp-gmbh.ch/blog/2006/05/07.php | On creating workspaces and merging/refreshing data with Oracle's Workspace Manager |
http://www.adp-gmbh.ch/blog/2006/03/24.php | On emulating tables with PL/SQL (Part II) |
http://www.adp-gmbh.ch/blog/2006/02/05.php | On reading trace files with PL/SQL |
http://www.adp-gmbh.ch/blog/2006/01/24.php | On a breakable Oracle |
http://www.adp-gmbh.ch/blog/2006/01/08.html | On emulating tables with nested tables |
http://www.adp-gmbh.ch/blog/2005/december/28.html | On the lazy evaluation of decode and the eager evaluation of nvl |
http://www.adp-gmbh.ch/blog/2005/december/26.html | On comparing mulitple SQL statements' statistics |
http://www.adp-gmbh.ch/blog/2005/december/22.html | On making Oracle's regular expressions a bit easier to use |
http://www.adp-gmbh.ch/blog/2005/december/19.html | On triggers, sequences, autonumbers and failing inserts |
http://www.adp-gmbh.ch/blog/2005/december/11.html | On a table's first five rows |
http://www.adp-gmbh.ch/blog/2005/november/28.html | On identifiying |
http://www.adp-gmbh.ch/blog/2005/november/22.html | On creating bitmaps with pure PL/SQL only |
http://www.adp-gmbh.ch/blog/2005/november/20.html | On reading blobs from and writing blobs to a file |
http://www.adp-gmbh.ch/blog/2005/november/16.html | On mixing outer joins with inner joins |
http://www.adp-gmbh.ch/blog/2005/september/25.html#improved | On improving a better describe |
http://www.adp-gmbh.ch/blog/2005/november/4.html | On eliminating outliers in avg() queries |
http://www.adp-gmbh.ch/blog/2005/october/27.html | On using triggers to keep summary data in the nodes of hierarchical data in sync |
http://www.adp-gmbh.ch/blog/2005/october/18.html | On storing hierarchical data |
http://www.adp-gmbh.ch/blog/2005/october/3.html | On generating ERDs with desc_table and neato |
http://www.adp-gmbh.ch/blog/2005/september/25.html | On a better describe |
http://www.adp-gmbh.ch/blog/2005/september/22.html | On the missing product() aggregate function |
http://www.adp-gmbh.ch/blog/2005/september/19.html | On using dbms_utility.name_resolve |
http://www.adp-gmbh.ch/blog/2005/september/6.html | On solving a sudoku with Oracle |
http://www.adp-gmbh.ch/blog/2005/august/30.html | On a member function calling a member procedure |
http://www.adp-gmbh.ch/blog/2005/august/27.html | On an integer not always being an integer |
http://www.adp-gmbh.ch/blog/2005/august/22.html | On max and group by |
http://www.adp-gmbh.ch/blog/2005/august/19.html | On emulating callback functions through deriving an object from another in PL/SQL |
http://www.adp-gmbh.ch/blog/2005/august/16.html | On storing objects in a table |
http://www.adp-gmbh.ch/blog/2005/august/8.html | On tracking data changes in a table |
http://www.adp-gmbh.ch/blog/2005/august/6.html | On identifiying parent and child tables |
http://www.adp-gmbh.ch/blog/2005/july/26.html | On verifying if an index is used |
http://www.adp-gmbh.ch/blog/2005/july/24.html | On to_char, dates and weekdays |
http://www.adp-gmbh.ch/blog/2005/july/20.html | On shrinking table sizes |
http://www.adp-gmbh.ch/blog/2005/july/18.html | On the missing super keyword in PL/SQL |
http://www.adp-gmbh.ch/blog/2005/june/29.html | On lifting the 255 character output limit of dbms_output |
http://www.adp-gmbh.ch/blog/2005/june/24.html | On case insensitive queries in 10g |
http://www.adp-gmbh.ch/blog/2005/may/27.html | On making Oracle start a batch file (.bat) on Windows |
http://www.adp-gmbh.ch/blog/2005/may/11.html | On using regexp_replace to format data |
http://www.adp-gmbh.ch/blog/2005/may/5.html | On EVAL'ing an expression |
http://www.adp-gmbh.ch/blog/2005/may/2.html | On creating a similar user |
http://www.adp-gmbh.ch/blog/2005/april/21.html | On table sizes |
http://www.adp-gmbh.ch/blog/2005/april/17.html | On profiles |
olds.html | older news |
external links
address | anchor text |
---|---|
http://www.oracle.com/technology/tech/oci/instantclient/index.html | Oracle Technology Network Instant Client page |
http://download.oracle.com/otn/nt/instantclient/111070/instantclient-basic-win32-11.1.0.7.0.zip | instantclient-basic-win32-11.1.0.7.0.zip |
http://download.oracle.com/otn/nt/instantclient/111070/instantclient-odbc-win32-11.1.0.7.0.zip | instantclient-odbc-win32-11.1.0.7.0.zip |
http://support.microsoft.com/kb/q184608/ | http://support.microsoft.com/kb/q184608/ |
http://support.microsoft.com/kb/104011 | http://support.microsoft.com/kb/104011 |
http://support.microsoft.com/kb/q184608/ | http://support.microsoft.com/kb/q184608/ |
http://www.renenyffenegger.ch | bla bla |