Oracle view to Get one field value based on two field values
I need to create an Oracle view on table DocumentNo ( Fields DocumentNo, StateNo, FullPath)
The StateNo on the view should return with following logic
If FullPath like '%Secure%' return StateNo as 1000
elseif (StateNo = 10 or StateNo= 5) return StateNo as StateNo*10
else return stateNo
end if
The StateNo on the view should return with following logic
If FullPath like '%Secure%' return StateNo as 1000
elseif (StateNo = 10 or StateNo= 5) return StateNo as StateNo*10
else return stateNo
end if
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.