Is it possible to search all domain names, but search on who owns them, or by address? I want .co.uk as well as .com
Cheers!
Cheers!
SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 27 15:01:35 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> @connect chajol@tax_test
Enter password:
Connected.
[email]chajol@tax.expe[/email]rior>select count(distinct name1)
2 from tax.accounts;
COUNT(DISTINCTNAME1)
--------------------
442547
Elapsed: 00:01:72.94
[email]chajol@tax.expe[/email]rior>select count(*)
2 from tax.accounts a,
3 tax.name_fragments_tax f
4* where a.acct_id = f.acct_id;
COUNT(*)
----------
54913098
Elapsed: 00:08:50.97
[email]chajol@tax.expe[/email]rior>select distinct a.name1
2 from tax.accounts a,
3 tax.name_fragments_tax f
4 where a.acct_id = f.acct_id
5* and f.name_frag like 'OLLEY RE%';
NAME1
--------------------------------------------------
COLLEY MILDRED C TRS
JOLLEY REBECCA NANCE & CHARLES
Elapsed: 00:00:00.37
[email]chajol@tax.expe[/email]rior>

Comment