Oracle Multiple Select Statements execution using Table/File into a Standard Output format

[Anonymous]

Hi All,

Requirement:

 I have Oracle configured Table with "Select Statements" as data.

First "select statement" to be executed and produce a result into an Oracle Table/File and then 

Second "select statement" to be executed and produce a result and then third ..... until end of all "Select Statements" execution is completed.

Note: 

1. All Select Statements having same output format to be loaded into a Oracle Table/File

2. Database schema is same for Oracle Configured Tables and Execution of Select Statements

Please provide detailed explanation along with examples

Thanks & Regards

Sreeramkumar

[Anonymous]

Hi @nthampi 

I'm able to see output using "tJava" with 'System.out.println((String)globalMap.get("RULE_QR"));' 

Also Now I'm able to see Output in FlatFile Output.

Ref: screenshots attached 

Thanks & Regards

Sreeram

Multiple_Dynamic_Select_Staements_execution.jpg
tJava_Success_29May2019.jpg