I suggest create the sql file and .sh file seprated and call the sql file in .sh file and schedule in crontab for desired time , I'm using the same..
eg:-
user.sh:
Code:
ORACLE_HOME=/app/oracle/product/10.0.0.0
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH
CDATE=`date +%d%m%Y`
export CDATE
echo $CDATE
. /home/oracle/.bash_profile
sqlplus abc_USER/password@abcd.pfizer.com @/home/oracle/script/user.sql
user.sql:
clear breaks
clear columns
clear compute
set pagesize 50000
set NEWPAGE 1
set linesize 32767
set colsep ,
set headsep on
set serveroutput on size 1000000 format wrap
set feedback off
set underline off
SPOOL user.csv
select USERNAME, EMAIL, FULL_NAME, LAST_LOGIN, DATE,CREATED from sfuser where (trunc(sysdate) -trunc(Last_login))>120 and status = 'Active'
and username not in (select username from scm_authorized_keys)
and ID not in (SELECT distinct created_by_id FROM audit_entry WHERE (TRUNC(SYSDATE) -TRUNC(date_created)) < 120);
SPOOL OFF
Moderator's Comments:
Please use next time code tags for your code and data
Last edited by methyl; 03-26-2012 at 09:29 AM..
Reason: separate Shell script from Oracle sql
Hi Experts,
I am adding a column of numbers with awk , however not getting correct output:
# awk '{sum+=$1} END {print sum}' datafile
2.15291e+06
How can I getthe output like : 2152910
Thank you..
# awk '{sum+=$1} END {print sum}' datafile
2.15079e+06 (3 Replies)
Hi,
I am presently stuck in a csv file.
INPUT CSV
baseball,NULL,8798765,Most played
baseball,NULL,8928192,Most played
baseball,NULL,5678945,Most played
cricket,NOTNULL,125782,Usually played
cricket,NOTNULL,678921,Usually played
EXPECTED OUTPUT CSV
... (7 Replies)
Hi
I have written below script to get the data in table form.
#!/bin/sh
echo "File Name\tType"
for i in *;
do
echo "$i\t\c"
if ; then
echo "directory"
elif ; then
echo "symbolic link"
elif ; then
echo "file"
else
echo "unknown"
fi
donehowever i am getting output in different way... (3 Replies)
Hi awk experts,
I am getting a strange output , may be it is normal but I am unable to comprehend,
When Using == operator it is showing correct:
# ls -l | awk '{for (i=0;i<=NF;i++) if ( $i =="info" )print $1,$6,$7,$8,$9}'
drwx------ Jan 17 10:44 info
But When using ~ (equal )... (4 Replies)
I've been working on improving my awk, and the next thing I want to learn is to properly use functions (I understand functions in shell and python). I have the following code which includes how I did this without functions before, and two attempts I've made to do it with functions:
function... (3 Replies)
Good Moring,
I am currently reading about awk in a manual and following the examples using the oratab file.
My system is SOLARIS 10
I think I am getting strange behavior judging by what the book says to do and what I am getting with my little program.
Here is my program:
grep -v oratab |... (4 Replies)
Hello,
I am practising awk and decided to compare two columns and print the result of the comparison as third column
i/p data
c1,c2,c3
1,a,b
1,b,b
i am trying to compare the last two columns and if they match I am trying to print match else mismatch(Ideally i want that as a last column... (5 Replies)
Hi Gurus,
I run command grep ABC file1 > file2 against below file. I got all ABC_xxx in one line in file2. I expect to get multiple lines in file2. If I print result in screen, the result is expected.
thanks in advance
My os is SunOS 5.10 Generic_150400-64 sun4v sparc sun4v
ABC_123
XXXXX... (2 Replies)
Discussion started by: green_k
2 Replies
LEARN ABOUT DEBIAN
swac-get
SWAC-GET(1) General Commands Manual SWAC-GET(1)NAME
swac-get - audio collections of words (SWAC) manager
SYNOPSIS
swac-get [-t] [clear] [update] | [upgrade] | [select <url|packid>] | [deselect <url|packid>] | [list] | [list-sources] | [list-available] |
[sql <query>] | [--help] | [--version]
DESCRIPTION
Swac-get is a simple command line program which allows to download and install audio collections of words (SWAC) in a SQLite3 database.
Audio collections can be imported from the hard drive or directly from the Internet using the HTTP protocol. Swac-get is designed to be
used with swac-explore, a GTK+ interface which allows the browsing of the created SQLite3 database. An important set of free audio collec-
tions of words (SWAC) is available at: http://swac-collections.org/
For more information, please, visit the Shtooka Project homepage at: http://shtooka.net/ .
COMMANDS
clear clear database
deselect <url|packid>
delete records of the package <url|packid> from the database
list list installed packages
list-available
list available packages
list-sources
list source repositories
sql <query>
execute a sql query in the database
select <url|packid>
insert records of the package <url|packid> in the database
ex: swac-get select file:///home/<my directory>/
swac-get select http://packs.shtooka.net/<my package>/ogg/
swac-get select fra-balm-voc
select source-delete <url>
delete <url> from the repositories list
source-deselect <url>
deselect <url> from the repositories list
source-select <url>
add <url> to the repositories list
ex: swac-get source-select http://packs.shtooka.net/
swac-get source-select file:///home/<my directory>/
update update the list of available packages
upgrade
upgrade installed packages
OPTIONS -t, --target <path>
set the SQLite3 database path (default path is ~/.swac/swac.db)
-v, --version
print version information and exit
-h, --help
print this help and exit
EXAMPLES
swac-get source-select http://packs.shtooka.net/
swac-get update
swac-get select chi-balm-hsk1
swac-get select fra-balm-voc
BUGS
swac-get doesn't care about the version number for the upgrade command.
AUTHOR
swac-get and this manual page were written by Nicolas Vion <nico@picapo.net>.
mai 25, 2008 SWAC-GET(1)