[쉘스크립트] 오라클에서 data 가져오기 (select문)

2017. 4. 2. 17:25쉘스크립트

[root@oracle get_billing]# cat db_data3.pl

#!/bin/bash

su - oracle <<EOF

sqlplus -s test/test

set heading off

col feature_id format a35

col application_id format a35

set pages 8000

set lines 8000

set termout off

set echo off

set feed off

SET SQLBLANKLINES ON

select * from info where rownum<=10;

EOF