Re: subset of tables

"ew1" <ewanski_at_email.arizona.edu> wrote in message news:1112045462.883971.252540_at_f14g2000cwb.googlegroups.com...
> 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!

As Matt indicated, you need to learn a bit about the data dictionary. At the risk of giving you just enough information to be dangerous, try:

select table_name from user_tables where table_name like 'Z%';

-- 
Randy Harris
(tech at promail dot com)