Skip to content

Instantly share code, notes, and snippets.

@kimwalisch

kimwalisch/oracle_sql_commands.sql

Last active August 29, 2015 14:00
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kimwalisch/11284073 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kimwalisch/11284073 to your computer and use it in GitHub Desktop.
Download ZIP
oracle_sql_commands
Raw
oracle_sql_commands.sql
-- Seach column name in database
select table_name from all_tab_columns where column_name like '%COLUMN_NAME%';
-- Seach table name in database
select table_name from all_tables where table_name like '%TABLE_NAME%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment