Ways to get sql query output inside UNIX Shell Script

Below are different ways to get SQL query output inside unix shell script.

Method 1:
{
/bin/echo "set pause off"
/bin/echo "set pagesize 0"
/bin/echo "set linesize 300"
/bin/echo "set feedback off"
/bin/echo "set echo off"
/bin/echo "set term off"
/bin/echo "SELECT location_id
FROM location
WHERE facility_id = 'W1';"
} | sqlplus -s dbuser/dbpwd


Method 2: 

Please note that ENDSQL is not a key word, you can use any word.

sqlplus -s dbuser/dbpwd << ENDSQL 

set pause off 

set pagesize 0 

set linesize 300 

set feedback off 

set echo off 

set term off 

select location_id from location where facility_id='W1' and rownum < 2; 

EXIT; 

ENDSQL 

Method 3: 

sqlplus -s dbuser/dbpwd << ENDSQL
set pause off
set pagesize 0
set linesize 300
set feedback off
set echo off
set term off
@filename.sql
EXIT;
ENDSQL