oracle_for_dude wrote:Is it?
HI it is trunc(15/2) from dual;
Strange to comment that way to a guru, especially after giving a not so correct answer, yourself.
SQL>var v number SQL>exec :v:= trunc(15/2) PL/SQL procedure successfully completed. SQL>print v V ---------- 7 SQL>
dba_vijay wrote:You must have something special that I don't:
I just tried select div(13,2) from dual and it worked.
Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production.