<div>
a query like that won't be efficient but you can do it with simple concatenation of the columns and checking each character<br />
<br />
select * from table<br />
where col1||col2||col3||col4||co<wbr />l5 .... like '%,%'<br />
or &nbsp;col1||col2||col3||col4||co<wbr />l5 .... like '%?%'<br />
or &nbsp;col1||col2||col3||col4||co<wbr />l5 .... like '%#%'<br />
or &nbsp;col1||col2||col3||col4||co<wbr />l5 .... like '%!%'
</div>


<div>
Can the where statement be consolidated?<br />
For example, If I need to check 100 columns for 20 different like statements or want to add a field, its a lot to edit
</div>


<div>
<div class="content wysiwyg-content">
Is is possible to query against an entire table in Oracle and throw the results for only the fields/columns that contain the specified criteria? For example<br />
I want to <br />
select *<br />
from table<br />
where any field in any column contains a comma, question mark, hash tag, or exclamation point
</div>
</div>


Is is possible to query against an entire table in Oracle and throw the results for only the fields/columns that contain the specified criteria? For example
I want to 
select *
from table
where any field in any column contains a comma, question mark, hash tag, or exclamation point

a query like that won&#39;t be efficient but you can do it with simple concatenation of the columns and checking each character

select * from table
where col1||col2||col3||col4||col5 .... like &#39;%,%&#39;
or  col1||col2||col3||col4||col5 .... like &#39;%?%&#39;
or  col1||col2||col3||col4||col5 .... like &#39;%#%&#39;
or  col1||col2||col3||col4||col5 .... like &#39;%!%&#39;

Can the where statement be consolidated?
For example, If I need to check 100 columns for 20 different like statements or want to add a field, its a lot to edit

Query all columns in a table for specific characters

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.