advanced code snippet search

Posted By

geekzspot on 10/12/12


Tagged

Oracle


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

geekzspot


Search all Oracle columns

 / Published in: SQL
 

Search all the database Tables for column names that contain a string

Expand | Embed | Plain Text 
  1. SELECT owner, table_name, column_name FROM all_tab_columns WHERE column_name LIKE UPPER('%&string%') ORDER BY owner, table_name, column_name; -- Search all columns

Report this snippet  

You need to login to post a comment.