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