01-07-2008
Using SQL in Unix
Please tell me how i can use SQL in my unix scripts.
Please give examples.
I just want to start writing some scripts for my use.
Looking for ur cooperation.
thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi gurus,
Being a newbie not sure whether iam asking the right question?
can we use oracle commands in unix for ex: to read a count on a table.
if so, what needs to be configured and etc..
any kind of help is appreciated.
Thanks
sish (6 Replies)
Discussion started by: sish78
6 Replies
2. Shell Programming and Scripting
when we are spooling query o/p to certain txt file,in that file how we can get headers in the query.(through unix shell scripting).
for exmple
q1="slect * from XXXXXX;";
sqlplus XXX/XXXX@XXXXX
spool XXXX.txt
$q1
spool off
in the text file i want the headers of the query.....
... (1 Reply)
Discussion started by: bhagya.puccha
1 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I would like to access SQL plus from my unix, and learn to run some SQL scripts in Unix.
How do i begin. Is there any known website that offers a quick tutorial or tips?
Thanks,
unxhopeful (4 Replies)
Discussion started by: unxhopeful
4 Replies
4. Shell Programming and Scripting
How do I dynamically assign the below output to unix shell variables
so I can build a menu in a shell script?
Example:
var1 = 1 var2= SYSTEM
var3 = 2 var4= UNDOTBS1
and so on, then in the shell script I can use the variables to build a menu.
set serveroutput on
declare... (2 Replies)
Discussion started by: djehres
2 Replies
5. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
6. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
7. Programming
If anyone is familiar with Oracle, there is a way to trace a file. Then there is is a script called tkprof that will generate a report that includes a rollup of some values. The problem with this script is that it only does the rollup properly if the query is finished. So I need something quick and... (2 Replies)
Discussion started by: guessingo
2 Replies
8. Shell Programming and Scripting
Hi All,
I am accessing Unix through putty (i.e. unix is installed on other server and i am accessing it remotely through putty). I am having SQL Server 2008 installed on my computer.
Now i want to access sql server via. unix.
Could some one please help me in this!!!
Thanks (2 Replies)
Discussion started by: preetpalkapoor
2 Replies
9. Shell Programming and Scripting
hi folks
am running the shell script below
#!/bin/bash
sqlplus 'scott@orcl/tiger'<<ENDSQL >> outputlogfile.csv
SET PAGES 0
SET HEAD ON
SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 100
SET PAGESIZE 100
SET SERVEROUTPUT ON
--# Fire the query on database
select *
from employee;
... (2 Replies)
Discussion started by: coolboy98699
2 Replies
10. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
LEARN ABOUT SUSE
startpar
STARTPAR(8) System Manager's Manual STARTPAR(8)
NAME
startpar - start runlevel scripts in parallel
SYNOPSIS
startpar [-p par] [-i iorate] [-t timeout] [-T global_timeout] [-a arg] prg1 prg2 ...
startpar [-p par] [-i iorate] [-t timeout] [-T global_timeout] -M [ boot|start|stop]
DESCRIPTION
startpar is used to run multiple run-level scripts in parallel. The degree of parallelism on one CPU can be set with the -p option, the
default is full parallelism. An argument to all of the scripts can be provided with the -a option. Processes block by pending I/O will
weighting by the factor 800. To change this factor the option -i can be used to specify an other value.
The output of each script is buffered and written when the script exits, so output lines of different scripts won't mix. You can modify
this behaviour by setting a timeout.
The timeout set with the -t option is used as buffer timeout. If the output buffer of a script is not empty and the last output was timeout
seconds ago, startpar will flush the buffer.
The -T option timeout works more globally. If no output is printed for more than global_timeout seconds, startpar will flush the buffer of
the script with the oldest output. Afterwards it will only print output of this script until it is finished.
The -M option switches startpar into a make(1) like behaviour. This option takes three different arguments: boot, start, and stop for
reading .depend.boot or .depend.start or .depend.stop respectively in the directory /etc/init.d/. By scanning the boot and runlevel direc-
tories in /etc/init.d/ it then executes the appropriate scripts in parallel.
FILES
/etc/init.d/.depend.boot
/etc/init.d/.depend.start
/etc/init.d/.depend.stop
SEE ALSO
init.d(7), insserv(8), startproc(8).
COPYRIGHT
2003,2004 SuSE Linux AG, Nuernberg, Germany.
2007 SuSE LINUX Products GmbH, Nuernberg, Germany.
AUTHOR
Michael Schroeder <mls@suse.de>
Takashi Iwai <tiwai@suse.de>
Werner Fink <werner@suse.de>
Jun 2003 STARTPAR(8)