<div>
Select col1, case when col2 is not null then 1 else 0 end mycol from table;
</div>


Select col1, case when col2 is not null then 1 else 0 end mycol from table;

<div>
Select col1, decode(col2,null,0,1) mycol from table;
</div>


Select col1, decode(col2,null,0,1) mycol from table;

<div>
Decode is still valid but is being phased out.
</div>


Decode is still valid but is being phased out.

<div>
This is the solution I used...thanks
</div>


<div>
why the B? &nbsp;that's a penalty grade, &nbsp;what more did you want for an A?
</div>


why the B?  that's a penalty grade,  what more did you want for an A?

<div>
<div class="content wysiwyg-content">
I have a query in oracle..looking at returning a numeric value of 1 if a column is not NULL and 0. <br />
some folks said that it would be similar to SQL but my query doesn't work. <br />
<br />
So the value I want to change is Col2. &nbsp;Set to 1 if the there is anything in Col2, and 0 if it is NULL. <br />
<br />
Select <br />
Col1, <br />
If Col2 is NOT NULL THEN 1 <br />
Else 0 NewColName, <br />
Col3, <br />
From Database. <br />

</div>
</div>


I have a query in oracle..looking at returning a numeric value of 1 if a column is not NULL and 0. 
some folks said that it would be similar to SQL but my query doesn't work. 

So the value I want to change is Col2.  Set to 1 if the there is anything in Col2, and 0 if it is NULL. 

Select 
Col1, 
If Col2 is NOT NULL THEN 1 
Else 0 NewColName, 
Col3, 
From Database. 


Returning values depending on data in column

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.