advanced code snippet search

Posted By

thecrumb on 01/23/08


Tagged

sql Oracle


Versions (?)


Advertising

Submit Site


Get a list of all the user tables (Oracle)

Published in: SQL 

Get a list of all the user tables.

Expand | Embed | Plain Text 
  1. SELECT table_name, comments
  2. FROM dictionary
  3. WHERE table_name LIKE 'user_%'
  4. ORDER BY table_name;

Report this snippet 

You need to login to post a comment.