EVL – ETL Tool

Products, services and company names referenced in this document may be either trademarks or registered trademarks of their respective owners.

Copyright © 2017–2023 EVL Tool, s.r.o.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.

Table of Contents


(since EVL 2.0)

Run SQL from stdin or <f_in> and write result into stdout or <f_out>. It returns output from ’sqlplus’ as is, so for quering the table to get formatted EVL output use ‘Readora’ or ‘evl readora’.


is to be used in EVS job structure definition file. <f_out> is either output file or flow name.

evl runora

is intended for standalone usage, i.e. to be invoked from command line and writing records to standard output.

EVD and EVS are EVL definition files, for details see evl-evd(5) and evl-evs(5).


  <f_in> <f_out>
  [-u|--username=<user>] [-p|--password=<password>]

evl runora
  [-u|--username=<user>] [-p|--password=<password>]

evl runora
  ( --help | --usage | --version )


Standard options:


print this help and exit


print short usage information and exit


print version and exit

’sqlplus’ options:


sqlplus will be called in the form:


where <connect_identifier> can be in the form

[<net_service_name> | [//]Host[:Port]/<service_name>]

without this option environment variable ORACONN (if defined) is used as connection identifier for sqlplus

-p, --password=<password>

without this option environment variable ORAPASS is used as password for sqlplus

-u, --username=<user>

without this option environment variable ORAUSER is used as user for sqlplus