Archive

Archive for January, 2015

Exporting a variable to shell from SQLPLUS

January 12, 2015 Leave a comment

## Use the following sample

ARCHIVE_MODE=$(sqlplus -s “/ as sysdba” << !
set heading off
set feedback off
select count(log_mode) from v\$database where log_mode = ‘ARCHIVELOG’;
!
)

Advertisements
Categories: Uncategorized