How to return null if not exists
<p>I'm using oracle plsql and I have a question. I have table of Tests and Table of Schools. </p>

<p>How can I make a query that will put null or some other by my demands? </p>

<p>I mean, to put null or some numeric number in the execution.</p>