#!/usr/bin/sh

DATA=`date +'%d%m%Y'`
TABELA=TABELA_ABC
CAMPO=DATA_CRIACAO
TEMPO=30
DB_USER=db_user
DB_PASSWORD=db_user_password
DB_INSTANCE=connection_instance

sqlplus "$DB_USER/$DB_PASSWORD@$DB_INSTANCE" << SQL_EOF > SQL_OUT.text

	select * from $TABELA where $CAMPO >= TO_DATE('$DATA', 'DDMMYYYY')-$TEMPO;
	commit;

SQL_EOF