Useful SQL Queries – Customization exposed

(No Ratings Yet)

 Loading ...

We imparts you with great information. While surfing on web came across blog that had some articles on SQL and I think it is worth sharing with everybody. I orignal post was found on blog called nbrightside. Some useful queries that I found on that blog are:

Custom Indexs and Custom Columns:

This SQL query will give you the list all the custom indexes and column that have been created by you

select table_name, column_name
from all_tab_columns
where owner=’SIEBEL’
and table_name like ‘S\_%’ escape ‘\’
and column_name like ‘X\_%’ escape ‘\’;

Custom Columns:

select index_name, column_name, table_name
from all_ind_columns
where table_name like ‘S\_%’ escape ‘\’
and column_name like ‘X\_%’ escape ‘\’
and table_owner = ‘SIEBEL’;

Custom Tables:

select table_name
from all_tables where
owner=’SIEBEL’
and table_name like ‘CX\_%’ escape ‘\’;