Oracle "Is true" function???
I was wondering if there is a sql function that returns TRUE or FALSE for a sub-select statement. For example...
Select * from customer where customer_id = 4 AND IsTrue(Select registered from customer where customer = 'y')
I realize that is not the best example because there are a several other ways to figure out such a query without an "IsTrue" function, but it is just an example of what type of function that I'm looking for. Thanks.
Click Here to Expand Forum to Full Width