EM13c: How to Customize the Output of the emcli execute_sql Command (Doc ID 3081726.1)

Last updated on APRIL 15, 2025

Applies to:

Goal

How can the output of the emcli execute_sql command be customized to display only the relevant SQL execution data, rather than the full output that typically includes metadata and execution summaries?

By default, the command returns output similar to the following:

Result is :
**************************************************************************
* Target: <Target_Name>:oracle_database
* Execution Status: Succeeded
**************************************************************************
PL/SQL procedure successfully completed.
NAME
----------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------------------
<Property_Name>
FALSE
**************************************************************************
* Execution Summary
* Targets Succeeded: 1
* <Target_Name>:oracle_database
* Targets Failed: 0
*************************************************************************
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.