Skip to Main Content
Forums

APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Open outlook and attach blobs as file attachments?

Phil GJan 5 2017 — edited Jan 6 2017

Hello guys,

i have managed to open outlook on a link using javascript:window.location.href = 'mailto:test@test.com?subject=subject&body=bodytext';

I am wondering if there is a way to attach blobs from the db as files into this solution?

Any advice appreciated.

Comments

Frank Kulash
Answer

Hi, User_YBZOV
Here's one way:

SELECT	 COUNT (CASE WHEN gender = 'M' THEN 1 END)	AS male
,	 COUNT (CASE WHEN gender = 'F' THEN 1 END)	AS female
FROM	 employee
;

If you'd care to post CREATE TABLE and INSERT statements for the samp,e data, then I could test this.
SELECT ... PIVOT is another way.

Marked as Answer by User_YBZOV · Sep 21 2022
1 person found this helpful
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 3 2017
Added on Jan 5 2017
#apex-discussions
7 comments
2,303 views