|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Run sql query in shell script and output data save as delimited text
Post 302994060 by Jaganjag on Saturday 18th of March 2017 10:06:25 AM
03-18-2017
Thank you
Thanks durden_tyler for your help . It is working 
---------- Post updated at 09:06 AM ---------- Previous update was at 08:56 AM ----------
I have a SQL script that is selecting rows from a table with more than 50,000 records but I only need one header line at the beginning.
Can any one please suggest the code.
SET HEADING ON
SET PAGESIZE 50000
If I set the 'SET PAGESIZE' to 50000. it repeats, the column headers Evert 50000 lines.
---------- Post updated at 09:06 AM ---------- Previous update was at 08:56 AM ----------
I have a SQL script that is selecting rows from a table with more than 50,000 records but I only need one header line at the beginning.
Can any one please suggest the code.
SET HEADING ON
SET PAGESIZE 50000
If I set the 'SET PAGESIZE' to 50000. it repeats, the column headers Evert 50000 lines.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
Discussion started by: kattics
1 Replies
2. Shell Programming and Scripting
Hi,
I have data in my text file something like this.
adams
robert
ahmed
gibbs
I want to use this data line by line as input to an sql query which i run by connecting to an oracle database from shell.
If you have code for similar scenario , please ehlp.
I want the output of the sql query... (7 Replies)
Discussion started by: rdhanek
7 Replies
3. Shell Programming and Scripting
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 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. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
6. Shell Programming and Scripting
Hi,
I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script.
The scenario is like....
Suppose I have a file abc.txt that has the card numbers..it could be in thousands..
then I need to fire a query like
... (12 Replies)
Discussion started by: vsachan
12 Replies
7. 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
8. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
9. Shell Programming and Scripting
I am writing the following script to create the file v_out.txt.
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... (7 Replies)
Discussion started by: itzkashi
7 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 PLAN9
bundle
BUNDLE(1) General Commands Manual BUNDLE(1) NAME
bundle - collect files for distribution SYNOPSIS
bundle file ... DESCRIPTION
Bundle writes on its standard output a shell script for rc(1) or a Bourne shell which, when executed, will recreate the original files. Its main use is for distributing small numbers of text files by mail(1). Although less refined than standard archives from ar(1) or tar(1), a bundle file is self-documenting and complete; little preparation is required on the receiving machine. EXAMPLES
bundle mkfile *.[ch] | mail kremvax!boris Send a makefile to Boris together with related and files. Upon receiving the mail, Boris may save the file sans postmark, say in gift/horse, then do cd gift; rc horse; mk SOURCE
/rc/bin/bundle SEE ALSO
ar(1), tar(1), mail(1) BUGS
Bundle will not create directories and is unsatisfactory for non-text files. Beware of gift horses. BUNDLE(1)