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

Information about DNS servers

adp-gmbh.chMX10mx01.tophost.chIN14047
adp-gmbh.chMX10mx02.tophost.chIN14047
adp-gmbh.chNSns98.tophost.chIN42847
adp-gmbh.chNSns97.tophost.chIN42847

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

addressanchor text
Most wanted
Feedback
here
Oracle Instance
net service name
tnsnames.ora
TNS_ADMIN
PATH
http://www.adp-gmbh.ch/blog/2009/11/14.php
set
serveroutput
declare
dbms_xdb
dbms_output
select
XMLQuery
dual
SQL*Plus
longs
set
long
http://www.adp-gmbh.ch/blog/2009/10/08.php
create table
number
primary key
varchar2
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
create view
rownum
level
substr
lpad
start with
null
connect by
set pagesize
select
substr
order by
set pagesize
select
substr
order by
collection
create or replace type
constructor
member
constructor
member
for
set serveroutput
table
dbms_output
http://www.adp-gmbh.ch/blog/2009/09/29.php
SQL*Plus
@ or @@
dbms_output.put_line
begin
end
set serveroutput on
set verify off
.
set sqlterminator
set termout
spool
prompt
input
. (dot)
sqlterminator
termout
spooled file
prompt
input
http://www.adp-gmbh.ch/blog/2008/03/15.php
On setting commit_write
On forcing a nested loop join instead of a hash join
On select into and the too_many_rows and no_data_found exception
Emulating tables with PL/SQL
sprintf and printf in PL/SQL
On importing data from Oracle into Excel with CopyFromRecordset
On importing data from Oracle into Excel with a Visual Basic for Application macro
On finding changed values in a table with flashback
On parametrizing views with contexts
On creating an AJAX Application with Oracle
On splitting a string into words with regular expressions
On generating HTML output with SQL*Plus
On out parameters
Comments, finally!
On travelling back in time with Oracle's Workspace Manager
On solving workspace conflicts
On creating workspaces and merging/refreshing data with Oracle's Workspace Manager
On emulating tables with PL/SQL (Part II)
On reading trace files with PL/SQL
On a breakable Oracle
On emulating tables with nested tables
On the lazy evaluation of decode and the eager evaluation of nvl
On comparing mulitple SQL statements' statistics
On making Oracle's regular expressions a bit easier to use
On triggers, sequences, autonumbers and failing inserts
On a table's first five rows
On identifiying
On creating bitmaps with pure PL/SQL only
On reading blobs from and writing blobs to a file
On mixing outer joins with inner joins
On improving a better describe
On eliminating outliers in avg() queries
On using triggers to keep summary data in the nodes of hierarchical data in sync
On storing hierarchical data
On generating ERDs with desc_table and neato
On a better describe
On the missing product() aggregate function
On using dbms_utility.name_resolve
On solving a sudoku with Oracle
On a member function calling a member procedure
On an integer not always being an integer
On max and group by
On emulating callback functions through deriving an object from another in PL/SQL
On storing objects in a table
On tracking data changes in a table
On identifiying parent and child tables
On verifying if an index is used
On to_char, dates and weekdays
On shrinking table sizes
On the missing super keyword in PL/SQL
On lifting the 255 character output limit of dbms_output
On case insensitive queries in 10g
On making Oracle start a batch file (.bat) on Windows
On using regexp_replace to format data
On EVAL'ing an expression
On creating a similar user
On table sizes
On profiles
older news

external links

addressanchor text
Oracle Technology Network Instant Client page
instantclient-basic-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/104011
http://support.microsoft.com/kb/q184608/
bla bla