You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get file counts by MB size from fattach table?

Accepted answer
23
Views
1
Comments

Summary:


Content (please ensure you mask any confidential information):

First, I am converting a file size from bytes to MBs, but I am not sure that I am doing this conversion correctly. I am using a website converter so for instance if the size = 1000000 in bytes, the converter result is 1MB and get the count threshold.

Second, I am using and if statement in the fattach.sz field

Question: Is this accurate, most importantly, and is there a better way to accomplish the count per MB size?

Version (include the version you are using, if applicable):

23C Oracle Agent Desktop Service Cloud

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!