|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to print the output of a select query using shell script?
Post 302826103 by anbu23 on Wednesday 26th of June 2013 02:13:11 AM
06-26-2013
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have been asked to create a shell script that accepts a number of SQL select queries as input, runs them in sequence, spools the output to an EXCEL workbook, where, each worksheet is an output of a Select statement run above.
The workbook should be in a .XLS format. If a particular select... (2 Replies)
Discussion started by: ShellNovice1
2 Replies
2. Shell Programming and Scripting
Hi All,
I'm finding it difficult to format the query output that was returned in a shell script.
Actually i have one shell script which does some DB stuff and depending on the result it will do some more tasks. My question here is to format the query output returned by mysql.
Intitally my... (5 Replies)
Discussion started by: RSC1985
5 Replies
3. Shell Programming and Scripting
Hi,
I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification
in short
select var,data from usage;
o/p=... (1 Reply)
Discussion started by: rkrish
1 Replies
4. Shell Programming and Scripting
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies
5. 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
6. 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
7. Shell Programming and Scripting
echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on";
Select statement is mentioned below
echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and... (7 Replies)
Discussion started by: aroragaurav.84
7 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 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 ULTRIX
xrmgetstringdatabase
XrmMergeDatabases(3X11) MIT X11R4 XrmMergeDatabases(3X11) Name XrmMergeDatabases, XrmGetFileDatabase, XrmPutFileDatabase, XrmGetStringDatabase, XrmDestroyDatabase - manipulate resource databases Syntax void XrmMergeDatabases(source_db, target_db) XrmDatabase source_db, *target_db; XrmDatabase XrmGetFileDatabase(filename) char *filename; void XrmPutFileDatabase(database, stored_db) XrmDatabase database; char *stored_db; XrmDatabase XrmGetStringDatabase(data) char *data; void XrmDestroyDatabase(database) XrmDatabase database; Arguments data Specifies the database contents using a string. database Specifies the database that is to be used. filename Specifies the resource database file name. source_db Specifies the resource database that is to be merged into the target database. stored_db Specifies the file name for the stored database. target_db Specifies a pointer to the resource database into which the source database is to be merged. Description The function merges the contents of one database into another. It may overwrite entries in the destination database. This function is used to combine databases (for example, an application specific database of defaults and a database of user preferences). The merge is destructive; that is, the source database is destroyed. The function opens the specified file, creates a new resource database, and loads it with the specifications read in from the specified file. The specified file must contain lines in the format accepted by If it cannot open the specified file, returns NULL. The function stores a copy of the specified database in the specified file. The file is an ASCII text file that contains lines in the for- mat that is accepted by The function creates a new database and stores the resources specified in the specified null-terminated string. is similar to except that it reads the information out of a string instead of out of a file. Each line is separated by a new-line character in the format accepted by If database is NULL, returns immediately. See Also XrmGetResource(3X11), XrmInitialize(3X11), XrmPutResource(3X11), XrmUniqueQuark(3X11) X Window System: The Complete Reference, Second Edition, Robert W. Scheifler and James Gettys XrmMergeDatabases(3X11)