Main

related bits

0

processing priority

4

site type

3 (personal blog or private political site, e.g. Blogspot, Substack, also small blogs on own domains)

review version

11

html import

20 (imported)

Events

first seen date

2024-11-07 13:32:51

expired found date

-

created at

2024-11-07 13:32:51

updated at

2025-10-24 21:44:08

Domain name statistics

length

24

crc

48109

tld

2211

nm parts

0

nm random digits

0

nm rare letters

0

Connections

is subdomain of id

13642151 (wordpress.com)

previous id

0

replaced with id

0

related id

-

dns primary id

0

dns alternative id

0

lifecycle status

0 (unclassified, or currently active)

Subdomains and pages

deleted subdomains

0

page imported products

0

page imported random

0

page imported parking

0

Error counters

count skipped due to recent timeouts on the same server IP

0

count content received but rejected due to 11-799

0

count dns errors

0

count cert errors

0

count timeouts

0

count http 429

0

count http 404

0

count http 403

0

count http 5xx

0

next operation date

-

Server

server bits

server ip

-

Mainpage statistics

mp import status

20

mp rejected date

-

mp saved date

-

mp size orig

316033

mp size raw text

88311

mp inner links count

20

mp inner links status

10 (links queued, awaiting import)

Open Graph

title

An Oracle Programmer

description

SQL and PL/SQL techniques and solutions

site name

An Oracle Programmer

author

updated

2026-03-05 04:57:51

raw text

An Oracle Programmer | SQL and PL/SQL techniques and solutions An Oracle Programmer SQL and PL/SQL techniques and solutions Menu Skip to content About me About this blog and test environment Copyright © 2014-2024 Stewart Ashton. All rights reserved. Post navigation ← Older posts SQL table macros 14: parameterized views Posted on 2024/04/24 by stewashton Developers like to reuse code. In SQL, views are reusable queries with lots of advantages, but one drawback: no parameters to limit the queries to only those rows we want. Sure, we can add a WHERE clause when selecting from a view, but the view might return lots of unnecessary data before the WHERE clause filters the rows. As Andrej Pashchenko recently wrote, SQL table macros can get the results we would want from parameterized views (if they existed), but they do not have all the advantages of real views: see https://blog.sqlora.com/en/parameterized-views-with-sql-macros-part-2/ He wants to...

Text analysis

redirect type

31 (document.location)

block type

0 (no issues)

detected language

1 (English)

category id

Moda (84)

index version

1

spam phrases

0

Text statistics

text nonlatin

0

text cyrillic

0

text characters

58589

text words

14510

text unique words

1244

text lines

2886

text sentences

202

text paragraphs

178

text words per sentence

71

text matched phrases

0

text matched dictionaries

0

RSS

rss status

32 (unknown)

rss found date

2024-11-07 13:32:52

rss size orig

11155

rss items

9

rss spam phrases

0

rss detected language

1 (English)

inbefore feed id

-

inbefore status

0 (new)

Sitemap

sitemap status

40 (completed successful import of reports.txt file to table in_pages)

sitemap review version

2

sitemap urls count

159

sitemap urls adult

0

sitemap filtered products

0

sitemap filtered videos

0

sitemap found date

2024-11-07 13:32:51

sitemap process date

2025-03-26 16:36:33

sitemap first import date

-

sitemap last import date

2025-10-24 21:44:08