Hi ALL,
I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know.
select query returns multiple values( say select name from emp)
Thanks in advance
LM (1 Reply)
i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated.
my sql query provide output some thing like this -
col1 col2 count
---- ---- ------
A B 10
c D 6
e... (8 Replies)
query sql using shell script, is it possible?
my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script?
thanks in advance! (2 Replies)
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Hi,
I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen.
snapshot of my script:... (13 Replies)
Hi, We are having multiple .sql files generated programatically which is not containing..
create or replace -- at the start
and
/ -- at the end
We need to append those .sql files with the above 2 statements at their respective positions.
We will be really thankful to get responses... (6 Replies)
Hi All,
#!/bin/ksh
call_sql ()
{
sql=$1
sqlplus -s $sqlparam_sieb <<EOF
SET ECHO OFF;
SET NEWPAGE NONE;
SET SQLBL OFF;
SET VERIFY OFF;
SET LINESIZE 2000;
SET... (2 Replies)
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line.
Main Code shell script:
this is my code:
#!/bin/bash
file="db_detail.txt"
. $file
rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
LEARN ABOUT LINUX
receive
RECEIVE(1) General Commands Manual RECEIVE(1)NAME
receive - receive files from the sendfile spool
SYNOPSIS
receive [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] [ -ffrom ] file [...]
receive -n [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] file-number [...]
receive [ -s ] [ -l ] [ -L ] [ -R ] [ -ffrom ]
receive -b user[@host] [ -k ] [ -f"from" ] file [...]
receive -b user[@host] [ -k ] [ -f"from" ] -n file-number [...]
receive -b user[@host] [ -k ] -a
DESCRIPTION
receive files from the sendfile spool which has been sent to you.
If there is already a file with the same name you will be prompted for overwriting or renaming.
Allowed wildcards in file names are: * ? [abc] [^abc]
CAUTION: you have to put wildcards and other special characters in '' quotes to hide them for interpretation by your shell.
OPTIONS -n receive file number(s)
-d delete instead of receive
-a receive (or delete or bounce) all files
-r rename before receiving
-k keep files in spool after receiving
-P pipe files to stdout
-S receive only pgp-signed files
-s list files in short format
-l list files
-L list files and look inside archives, too
-R renumber files in spool
-b bounce (forward) files to another recipient
-q quiet mode: no questions asked
-fuser all actions refer only to files from this user
-Z spool
specify an alternate spool directory
EXAMPLES
receive -L
list all files in long format.
receive 'blubb*'
receive all files starting with string "blubb".
receive -daf microsoft.com
delete all files from microsoft.com sites.
receive -b framstag@bofh '*.jpg'
bounce all *.jpg-files to framstag@bofh.
FILES
/var/spool/sendfile The sendfile spool directory.
/var/spool/sendfile/$USER/log
A log of the last transfers.
/etc/sendfile.deny Users which are not allowed to receive files or messages (set by root).
SEE ALSO sendfile(1).
AUTHOR
Ulli Horlacher - framstag@rus.uni-stuttgart.de
3rd Berkeley DistributionRECEIVE(1)