Re: SQL commands

Hi,

    Do you mean something like:

    SELECT table_name FROM all_tables WHERE table_name LIKE '%DBA%';     and

    SELECT view_name FROM all_views WHERE view_name LIKE '%DBA%';

You will need DBA privileges in order to access the DBA tables.

regards
Jerry Gitomer

Puneet Khanna wrote in message <7o9ktp$kdf$1_at_nntp3.uunet.ca>...
>I want to know the sql command by which i can select tables and
views from
>tab, which contain the word "dba". I know the command by which i
can get the
>rows in which the table/view name starts with "dba". The problem
is if the
>word is in between like ORA_DBA_ABC.
>
>Also, what is a decode function? where is it used?
>I do not find oracle doc. very helpful, pls. tell me a good book
for PL/SQL
>and SQL.
>
>
Received on Wed Aug 04 1999 - 12:39:38 CDT