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

pardeshirahul
pardeshirahul used Ask the Experts™
on
I had this question after viewing get the correct function value.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
I don't understand the question.  If you have data in two tables, you MUST join them somehow.

What do you mean "simple format "?

Author

Commented:
i showed it to my manager he said this is the different way of writing the oracle statement
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Different doesn't mean wrong.  Oracle has allowed the ANSI join syntax for quite a while and is only supporting the old Oracle syntax for backward compatibility.  Everything written these days should use ANSI syntax.

Someday Oracle will probably remove/desupport the old ways.

Author

Commented:
but is there a way of writing in  the old way
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Sure but I'm not going to port it for you.  There isn't a need.  If your manager still lives that far in the past, it is time to bring them into the year 2000.  There is nothing wrong with the ANSI syntax.  If it works and gives the correct results, the manager shouldn't care.

The old syntax has the join columns in the where clause and is along the lines of:
select col1 from tablea, tableb where tablea.col1=tableb.col1 and tablea.col2=tableb.col2(+);

The (+) is the old outer join syntax.

Maybe another Expert will be along later to port it for you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial