03-20-2018
Shell script appending output of sql query
I am writing the following script to create the file v_out.txt.
HTML Code:
sqlplus -s /nolog << EOF
CONNECT scott/tiger@orcl;
whenever sqlerror exit sql.sqlcode;
set newpage 0;
SET PAGESIZE 0;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET VERIFY OFF;
SET LINESIZE 100;
set tab off;
set trimspool off;
spool v_out.txt
SELECT '/****************************************************'
||CHR(10)
|| '************* Creating Table **************'
||CHR(10)
|| '*****************************************************/'
FROM dual;
I want to append this file v_out.txt with the output of another query based on the condition provided below.
HTML Code:
select status from t1 where id = 10;
if status = 'COMPLETE' THEN
SELECT COL1||' '||COL2 FROM T2;
else
'status not complete'
end if;
Any suggestions on how to do this will be appreciated.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: lijju.mathew
1 Replies
2. Shell Programming and Scripting
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)
Discussion started by: pharos467
8 Replies
3. Shell Programming and Scripting
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)
Discussion started by: kingpeejay
2 Replies
4. Shell Programming and Scripting
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)
Discussion started by: Agupte
3 Replies
5. Red Hat
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)
Discussion started by: ramsavi
5 Replies
6. Shell Programming and Scripting
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)
Discussion started by: juzz4fun
13 Replies
7. Shell Programming and Scripting
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)
Discussion started by: Rami Reddy
6 Replies
8. Shell Programming and Scripting
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)
Discussion started by: Kevin Tivoli
2 Replies
9. Shell Programming and Scripting
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)
Discussion started by: Jaganjag
8 Replies
10. UNIX for Beginners Questions & Answers
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 SUSE
htmlclean
HTMLCLEAN(1) User Contributed Perl Documentation HTMLCLEAN(1)
NAME
htmlclean - a small script to clean up existing HTML
SYNOPSIS
htmlclean [-v] [-V] file1 [file2 file3 ...]
DESCRIPTION
This program provides a command-line interface to the HTML::Clean module, which can help you to provide more compatible, smaller HTML files
at the expense of reducing the human readability of the HTML code. In some cases you may be able to reduce the size of your HTML by up to
50%!
The HTML::Clean library provides a number of features that improve your HTML for browsing and serving:
htmlclean passes each file given on the command line to the library and writes out the new HTML according to the specified options. The
default is to create a backup file and replace the file with cleaned HTML.
Removing whitespace, Comments and other useless or redundant constructs
Insuring that font tags work across multiple operating systems
For full details see the documentations for HTML::Clean itself.
OPTIONS
"-V"
Print the version of the program.
"-v"
Verbose mode. Print out the original and final file sizes, plus the compression percent. For example:
5261 4065 22% /tmp/development-es.html
5258 4061 22% /tmp/development-fr.html
4651 3683 20% /tmp/development.html
SEE ALSO
For the library, see HTML::Clean
AUTHOR
"htmlclean" is written by Paul Lindner, <paul.lindner@itu.int>
COPYRIGHT
Copyright (c> 1998 by ITU under the same terms as Perl.
perl v5.12.1 1999-01-17 HTMLCLEAN(1)