This content has been marked as final. Show 4 replies
VO are generating Select from view , view is select * from table . Jdeveloper are adding UPPER to paramaters Like
I added CAST(NAME AS VARCHAR2(100)) AS NAME in Exxpresion field and all is ok .
Select UPPER(name) from X where UPPER(name); In Select UPPER from view jdev loss his cast varchar2 Why i dont know and didnt have time to search a reason
If this select was from table no view all was corect