pardeshirahul
asked on
how to display correct function value in simple sql statement not inner join etc
I had this question after viewing get the correct function value.
ASKER
i showed it to my manager he said this is the different way of writing the oracle statement
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
but is there a way of writing in the old way
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.
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.
What do you mean "simple format "?