Forum Stats

  • 3,784,365 Users
  • 2,254,928 Discussions


Oracle returns the same data type for numeric expressions

User_OX9Q3 Member Posts: 25 Red Ribbon
edited Nov 5, 2021 1:49AM in General Database Discussions

I am working with an Enterprise 12cR2 version in conjunction with Delphi and I have noticed that when a field is obtained as a result of an expression of numerical operations it always returns a data type NUMBER (38,38) which is the generic one, do you know if Is there any way to restrict that this is the type of data that is returned? I require it because in my application I need to identify the type of data to use it in the memory table