Re: subset of tables

"ew1" <ewanski_at_email.arizona.edu> wrote:

>Thanks!
>I did a
>show tables like 'z%'
>but it gave me an error of
>SQL-I-DEPR-FEATURE, Deprecated Feature: Keyword LIKE used as an
>identifier.
>Thanks for the hint!

Maybe what you want is something like

select table_name from dba_tables where table_name like 'A%'

Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

if Oracle group then
db := Oracle 9.2.0.1.0 (Enterprise Ed.)
else
db := Interbase 6.0.2.0;
endif 

As a courtesy to those who spend 
time analyzing and attempting to
help, please do not top post.