adp-gmbh.ch

Website review adp-gmbh.ch

 Generated on February 12 2026 19:01 PM

Old data? UPDATE !

The score is 49/100

SEO Content

Title

René Nyffenegger on Oracle

Length : 26

Perfect, your title contains between 10 and 70 characters.

Description

Length : 0

Very bad. We haven't found meta description on your page. Use this free online meta tags generator to create description.

Keywords

Very bad. We haven't found meta keywords on your page. Use this free online meta tags generator to create keywords.

Og Meta Properties

This page does not take advantage of Og Properties. This tags allows social crawler's better structurize your page. Use this free og properties generator to create them.

Headings

H1 H2 H3 H4 H5 H6
1 6 3 0 0 0
  • [H1] René Nyffenegger on Oracle
  • [H2] November 14, 2009: On DAO, ODBC and Oracle
  • [H2] October 8, 2009: On XML Queries
  • [H2] September 29, 2009: On summing up values in nodes of a hierarchical query
  • [H2] March 15, 2008: On including files in SQL*Plus
  • [H2] Older on Oracle articles
  • [H2] Older news
  • [H3] Setting the required environment variables
  • [H3] Setting up the ODBC Datasource
  • [H3] Running the test

Images

We found 0 images on this web page.

Good, most or all of your images have alt attributes.

Text/HTML Ratio

Ratio : 68%

Ideal! This page's ratio of text to HTML code is between 25 and 70 percent.

Flash

Perfect, no Flash content has been detected on this page.

Iframe

Great, there are no Iframes detected on this page.

URL Rewrite

Good. Your links looks friendly!

Underscores in the URLs

We have detected underscores in your URLs. You should rather use hyphens to optimize your SEO.

In-page links

We found a total of 117 links including 2 link(s) to files

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

SEO Keywords

Keywords Cloud

level hierarchicalvalues dim set amt into long insert values end

Keywords Consistency

Keyword Content Title Keywords Description Headings
set 69
into 64
values 60
hierarchicalvalues 59
insert 58

Usability

Url

Domain : adp-gmbh.ch

Length : 11

Favicon

Very bad. We have not found shortcut icon. Icons are one of easy ways to attract regular visitors to your website more often.

Printability

We could not find a Print-Friendly CSS.

Language

You have not specified the language. Use this free meta tags generator to declare the intended language of your website.

Dublin Core

This page does not take advantage of Dublin Core.

Document

Doctype

HTML 4.01 Transitional

Encoding

Perfect. Your declared charset is UTF-8.

W3C Validity

Errors : 0

Warnings : 0

Email Privacy

Great no email address has been found in plain text!

Deprecated HTML

Great! We haven't found deprecated HTML tags in your HTML.

Speed Tips

Attention! Try to avoid nested tables in HTML.
Perfect. No inline css has been found in HTML tags!
Great, your website has few CSS files.
Perfect, your website has few JavaScript files.
Perfect, your website takes advantage of gzip.

Mobile

Mobile Optimization

Apple Icon
Meta Viewport Tag
Flash content

Optimization

XML Sitemap

Missing

Your website does not have an XML sitemap - this can be problematic.

A sitemap lists URLs that are available for crawling and can include additional information like your site's latest updates, frequency of changes and importance of the URLs. This allows search engines to crawl the site more intelligently.

Robots.txt

http://adp-gmbh.ch/robots.txt

Great, your website has a robots.txt file.

Analytics

Great, your website has an analytics tool.

   Google Analytics

PageSpeed Insights

Device
Categories

Website-SEO-Überprüfung

Website-SEO-Überprüfung is a free SEO tool which provides you content analysis of the website.