Getting sqlresult into bash variable without oracle header/footer

Question

#!/bin/bash -x

x=`sqlplus scott/tiger@xe<<endl
set heading off
select sysdate from dual;
exit
endl`

echo the answer is $x

is outputting

the answer is SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 27 09:01:25 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> SQL> 27-MAR-13 SQL> Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productiong

All I want is the result of the query sysdate. How do I get rid of all the oracle relase, copyright, ... info.

peter cooke · Accepted Answer · 2013-03-27 16:21:20Z

0

I found the answer

sqlplus -s

will then eliminate the headers

answered Mar 27, 2013 at 16:21

peter cooke

9993 gold badges11 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Refael Over a year ago

The parameter "-s" its only to connect to DB in silent mode.

Collectives™ on Stack Overflow

Getting sqlresult into bash variable without oracle header/footer

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related