Depending on how much users you have, then Shell_Life's solution will be better, but here is one:
The input file must be of form, otherwise you can change the code to suit your needs:
And must execute it as:
It is quite simple, but I hope it helps!
Hi
I am trying to run a SQL statement from a unix script determined at runtime.
It is throwing me an error. Please advise some solution to this.
echo "Enter username for the database"
read username
echo "Enter password for the database"
read password
echo "Enter SQL stmt"
read... (4 Replies)
Hi,
I know in oracle a .sql file is called by @ <path> /<filename>.
But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
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)
hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
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)
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)
I have a postgres sql statement that is the following:
select age from students;
which gives me the entries:
Age
---
10
15
13
12
9
14
10
which is about 7 rows of data.
Now what I would like to do with this is use a shell script to create an array age. As a results... (3 Replies)
Hi Experts,
Need your support.
Not able to use sql query alias in shell script.
Could you please help me in finding right way to use alias with sql query in shell script.
Below is the code i am using.
#!/bin/bash
sqlplus -s abc/abc@abc << EOF> bcd.csv
set trimspool on
select zone_id... (4 Replies)
Discussion started by: as7951
4 Replies
LEARN ABOUT DEBIAN
rdup-up
RDUP-UP(1) rdup RDUP-UP(1)NAME
rdup-up - update a directory tree with a rdup archive
SYNOPSIS
rdup-up [OPTION]... DIRECTORY
DESCRIPTION
With rdup-up you can update an (possibly) existing directory structure with a rdup archive.
The rdup archive has to be given to rdup-up's standard input.
Username and uids
rdup outputs both the username and uid, the receiving system (which may be a totally different system) checks if the username and uid
match. If the username and uid don't match the (numeric) uid is used on the file. The same holds true for the groupname and gid.
OPTIONS -n Do a dry-run and do not create anything on disk.
-t Create DIRECTORY (ala mkdir -p) if it does not exist.
-s N Strip N path components from a pathname. If the resulting pathname is empty after this operation it is skipped. Be careful however
with the following structure:
/foo
/foo/bar
/foo/bar/bla.txt
/foo/blork/bla.txt
With rdup-up -s2 this will leave:
<empty>
<empty>
/bla.txt
/bla.txt
And the last 'bla.txt' will overwrite the previous one, this will happen without warnings.
-r PATH
This option is related to the -s option, but works different. The string PATH is removed from (the beginning of) each pathname. With
-r /home/backup the pathname /home/backup/bin/mycmd becomes /bin/mycmd. The same could be done with -s 2, but then you need to count
the slashes. Note -s is always performed before -r.
-v Be more verbose and echo the processed files to standard output.
-vv Be even more verbose and echo processed file and the uid and gid information to standard output.
-T Show a table of contents of the rdup stream received (ala tar -tf -). With -T the directory argument is optional. -T unsets any
verbose (-v) options.
-h A short help message.
-V Show the version.
EXIT CODE
rdup-up return a zero exit code on success, otherwise 1 is returned.
AUTHOR
Written by Miek Gieben.
REPORTING BUGS
Report bugs to <miek@miek.nl>.
SEE ALSO
http:/www.miek.nl/projects/rdup/ is the main site of rdup. Also see rdup(1), rdup-tr(1) and rdup-backups(7).
COPYRIGHT
Copyright (C) 2005-2010 Miek Gieben. This is free software. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.
Licensed under the GPL version 3. See the file LICENSE in the source distribution of rdup.
1.1.11 13 Dec 2008 RDUP-UP(1)