Skip to Main Content
Forums

Oracle Database Discussions

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!

oracle sql output for outlook email body

4d475ca6-d057-4177-9e38-6e94e7006b06Feb 24 2017 — edited Feb 24 2017

HI to All,

I need to add output query into an email auto reporting body. Fut the sql script formatting output is misaligned.

on considering the below-set formatting:

set pages 5000

set feed off

spool on

set colsep "|"

set lines 256

set trimout on

set trimspool on

set feedback off;

set lines 256

COLUMN SET_NAME FORMAT A40

via sqlDeveloper runScript command I get the below output: (in the below output SE, REPORT_TIME columns was removed but the misalignment persist.)

xxx.png

but into email body report I get the below output:

yyy.png

Could you suggest a smart way for make compatible the Standard Oracle sql script output format with Microsoft Outlook body email format? ( on focus with MO 2016 version)

I'm available for dubs or questions,

thanks a lot,

Comments

onebeartoe-JavaNet

This is a really nice article with concrete examples of the new Java 8 features.

1 person found this helpful
Vinod Kumar Kashyap

Great. loving it

eudriscabrera-JavaNet

Just really great information !!.

@"Trisha Gee" I was trying to run the example, but i could not getting run in eclipse neither using gradle command line.

Helder Pires

Great article

FrankDupree

Interesting read..learnt some new tricks. keep it up

Parikshit Kumar Singh

It would be create if you could enrich it with code through github etc.

eudriscabrera-JavaNet

It would be create if you could enrich it with code through github etc.

The full application code Sense Repository - otn-article branch.

Also, take a look at this presentation https://trishagee.github.io/presentation/java8_in_anger/

Kashif Sohail

Great Article. JetBrains did a marvelous work for java.

It would be create if you could enrich it with code through github etc.

The full application code Sense Repository - otn-article branch.

Also, take a look at this presentation https://trishagee.github.io/presentation/java8_in_anger/

3400629

All important java 8 concepts in a single article. Awesome !!

RiyaSharma

Well written & Highly researched information you have shred. Thanks a lot...

Nice article! It's always nice finding aggregated and researched information. Thanks and keep it up!

nikki_carol

Great article! awesome!

Thanks for sharing.

ashley.hong

This is a really nice post with examples.

Great Job.

Take a look my site

https://www.bhrikutisoft.com/p/blog-page_95.html

4243789

Hi All,

I am new to these Java forums, but I have a very naive query about installing Java 8 on my Windows 10, which you may kindly answer.

aa.png

I installed Java 8 on my Windows 10 PC (JDK 14.0.1_64_bin.exe), and tried running a simple HelloWorld java program. It compiled but, in execution, is throwing a JNI error as shown. Kindly advise.

thanks, regards

Raghu

eudriscabrera-JavaNet

Hi All,

I am new to these Java forums, but I have a very naive query about installing Java 8 on my Windows 10, which you may kindly answer.

aa.png

I installed Java 8 on my Windows 10 PC (JDK 14.0.1_64_bin.exe), and tried running a simple HelloWorld java program. It compiled but, in execution, is throwing a JNI error as shown. Kindly advise.

thanks, regards

Raghu

The file was compiled at a higher version of Java (version 58.0 = Java 14) than the version with which we tried to run it (version 52 = Java 8).

Check the Java Version:

java -version

and the java compiler version

javac -version

Both commands must show the same version.

User_VVT3P

I just have startred learning the Java SE and I am very excited to do that. So, I would try to grab each concept and would participate in communi

1 - 18
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 24 2017
Added on Feb 24 2017
#email, #general-database-discussions, #sql-developer
4 comments
1,674 views