How do we get the oracle database query select values?

I would like to send the statistics output, the value evaluated in the alert, i would like to send that along into and email alert.

This value along with the second column in the query.

I am unable to determine the right way to get that value to display in the alert.

any input on how to do this, would be helpful.

thanks.

Find more posts tagged with

Accepted answers

All comments

orioncrack

Only 1 piece of statistical data is supported in the Oracle UE templates. My developers ask for the same and its not possible according to the documentation.

gholsopple

Thanks orioncrack..

What is that 1 piece of statistical data. ?

How is THAT value referenced in an email?

I was hopeful that at least a sql macro could be written to draw the values out.

orioncrack

Have you looked at the Oracle User Experience monitor documentation? All is in there. Google, is your frenemy.

orioncrack

Oracle Database (Updated)

gholsopple

I ended up using this post:

SQL variable definition to return multiple rows

to get the data i needed.

The documentation that i could find was not detailed enough, or there isn't a macro/variable that is referenceable during the email alert process.

Thanks.