<div>
As an addendum to the above...<br />
<br />
There's a whole bunch of stuff you can pull out of sys_context. <br />
<br />
See the documentation: <a href="http://docs.oracle.com/database/121/SQLRF/functions198.htm#SQLRF06117" rel="ugc">http://docs.oracle.com/database/121/SQLRF/functions198.htm#SQLRF06117</a>
</div>


As an addendum to the above...

There's a whole bunch of stuff you can pull out of sys_context.

See the documentation: http://docs.oracle.com/database/121/SQLRF/functions198.htm#SQLRF06117 [http://docs.oracle.com/database/121/SQLRF/functions198.htm#SQLRF06117]

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
How can I modify the following query to add INSTANCE_NAME and HOST_NAME from v$instance<br />
<br />
select<br />
INPUT_TYPE,<br />
STATUS,<br />
START_TIME, <br />
END_TIME<br />
from <br />
V$RMAN_BACKUP_JOB_DETAILS<br />
order by STATUS<br />
<br />
Thanks
</div>
</div>


Hello,

How can I modify the following query to add INSTANCE_NAME and HOST_NAME from v$instance

select
INPUT_TYPE,
STATUS,
START_TIME, 
END_TIME
from 
V$RMAN_BACKUP_JOB_DETAILS
order by STATUS

Thanks

modify query on V$RMAN_BACKUP_JOB_DETAILS

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.