I need for my job one shell script very concrete about connection to oracle databases and writing to text file.
Well I tell you:
1.- I must read a file as parameter from linux interface:
> example.sh fileToRead
2.-I must read line to line in "fileToRead" and take a specific value for each line:
0000000#12516654066#654654654564#xx/xx/xxxx#xx/xx/xxxx
0000000#12901548932#545464654656#//#xx/xx/xxxx
0000000#64654687434#564849849879#//#xx/xx/xxxx
3.- For each value I must call a fileA.sql make a query with this value:
I have a fileA.sql ==>
SELECT * FROM hello
WHERE hello.num = '¿¿???'
4.- And the last is to dump the results in a text file or a .dat
My shell script is this, so I know that it´s wrong and incomplete:
Thanks for all and greetings!!!
Moderator's Comments:
Please use next time code tags for your code and data
Last edited by vbe; 03-07-2013 at 11:55 AM..
Reason: code tags
Hi
Does any one have any idea on uploading the data using Unix Shell script from text file to Oracle database.
Requirement:-
1. Need to connect to Oracle database from Unix Shell script.
2. Need to pick Text file from some location on Unix Box.
3. Need to upload the data from text file to... (6 Replies)
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Hi All,
I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server.
Now how to import the dump to the... (3 Replies)
Hi All,
I am facing one problem related to importing Oracle Dump file.
We have two different version of AIX boxes with oracle (version 10.2.0.4.0) installed.
On one AIX box (version 6.1) we are creating oracle dump file (*.dmp) using oracle exp utility and importing it onto another AIX box... (1 Reply)
Hi,
Is it possible to pass oracle connection information from a configuration file and use that to connect to oracle database in my unix shell scripts. Following is the scenario:
(1) I would like to save oracle connection string details in a configuration file (ex., dbconfig.txt)
(2) from my... (6 Replies)
1. The problem statement, all variables and given/known data:
are the oracle dump files compatible to direct import into db2?
I already tried many times but it always truncated results.
anyone can help/ advice or suggest?
2. Relevant commands, code, scripts, algorithms:
exp... (3 Replies)
I am facing issue related to performance of one customized application running on RHEL 5.9. The application stalls for some unknown reason that I need to track. For that I require some tool or shell scripts that can monitor the CPU usage statistics (what we get in TOP or in more detail by other... (6 Replies)
Dear Team,
please help me to solve this problem using Linux command. I want to dump this data into an excel sheet,
Suppose I have a string like:
ABC
PQR
XYZ
ASD
then I expect output as a
ABC XYZ
PQR ASD (3 Replies)
Discussion started by: Shubham1182
3 Replies
LEARN ABOUT SUSE
echo
ECHO(1) User Commands ECHO(1)NAME
echo - display a line of text
SYNOPSIS
echo [SHORT-OPTION]... [STRING]...
echo LONG-OPTION
DESCRIPTION
Echo the STRING(s) to standard output.
-n do not output the trailing newline
-e enable interpretation of backslash escapes
-E disable interpretation of backslash escapes (default)
--help display this help and exit
--version
output version information and exit
If -e is in effect, the following sequences are recognized:
NNN the character whose ASCII code is NNN (octal)
\ backslash
a alert (BEL)
backspace
c produce no further output
f form feed
new line
carriage return
horizontal tab
v vertical tab
NOTE: your shell may have its own version of echo, which usually supersedes the version described here. Please refer to your shell's docu-
mentation for details about the options it supports.
AUTHOR
Written by Brian Fox and Chet Ramey.
REPORTING BUGS
Report echo bugs to bug-coreutils@gnu.org
GNU coreutils home page: <http://www.gnu.org/software/coreutils/>
General help using GNU software: <http://www.gnu.org/gethelp/>
COPYRIGHT
Copyright (C) 2009 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
The full documentation for echo is maintained as a Texinfo manual. If the info and echo programs are properly installed at your site, the
command
info coreutils 'echo invocation'
should give you access to the complete manual.
GNU coreutils 7.1 July 2010 ECHO(1)