SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need help To find Maximum precision and scale values for a column of table

880047Jan 31 2012 — edited Jan 31 2012

Hi All,

I am working oracle database 11gR2 and my manager asked me a query ( SQL or Pl/SQl) to find the maximum precision and scale values for a column of table in the existing data.

I have the columns in the table like this.
Column_name Data_type
ACCRUED_INTEREST NUMBER(15,2)
INTEREST_RATE NUMBER

Can you people help me on this and let me know for any other information.
Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2012

Added on Jan 31 2012

#11g

5 comments

12,850 views