Re: subset of tables

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 29 Mar 2005 09:34:27 -0800
Message-ID: <424991a3@news.victoria.tc.ca>

Randy Harris (randy_at_SpamFree.com) wrote:

: "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%';

Wow, I had no idea that those queries worked on RDB.

google: VMS RDB RDO
turns up lots of useful looking links.

such as
http://www3.sympatico.ca/n.rieck/docs/rms_rdb_notes.html http://www.oracle.com/technology/documentation/rdb.html

Did you try the HELP command?

--

This space not for rent.

Received on Tue Mar 29 2005 - 11:34:27 CST