<div>
I don't understand the question. &nbsp;If you have data in two tables, you MUST join them somehow.<br />
<br />
What do you mean &quot;simple format &quot;?
</div>


<div>
i showed it to my manager he said this is the different way of writing the oracle statement
</div>


pardeshirahul

<div>
but is there a way of writing in &nbsp;the old way
</div>


<div>
Sure but I'm not going to port it for you. &nbsp;There isn't a need. &nbsp;If your manager still lives that far in the past, it is time to bring them into the year 2000. &nbsp;There is nothing wrong with the ANSI syntax. &nbsp;If it works and gives the correct results, the manager shouldn't care.<br />
<br />
The old syntax has the join columns in the where clause and is along the lines of:<br />
select col1 from tablea, tableb where tablea.col1=tableb.col1 and tablea.col2=tableb.col2(+)<wbr />;<br />
<br />
The (+) is the old outer join syntax.<br />
<br />
Maybe another Expert will be along later to port it for you.
</div>


<div>
<div class="content wysiwyg-content">
I had this question after viewing <a href="https://www.experts-exchange.com/questions/29124417/get-the-correct-function-value.html" rel="ugc">get the correct function value</a>.
</div>
</div>


I had this question after viewing get the correct function value (https://www.experts-exchange.com/questions/29124417/get-the-correct-function-value.html).

how to display correct function value in simple sql statement not inner join etc

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.