10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by
modifying the script and show me how to execute it.
I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
2. Shell Programming and Scripting
Below is my code to execute mysql statement , how to save the output to a file ?
#Script to run automated sql queries
#Declaring mysql DB connection
MASTER_DB_HOST='localhost'... (1 Reply)
Discussion started by: Pratik4891
3. Shell Programming and Scripting
I need to sort out table in a file to a format below:
this is a test
Cat Bee Dat
1 2 3
Bet Cla Blaa Dat
A 6 T
this is a test (10 Replies)
Discussion started by: aydj
4. Shell Programming and Scripting
#] && . ./.profile 2>/dev/null
if test -f '.profile'; then . ./.profile; fi;
pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7"
... (21 Replies)
Discussion started by: ankit.mca.aaidu
5. Shell Programming and Scripting
I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far.
1. Table.txt ==> database extract file
2. flat.txt ==> pipe delimited after some manipulation of the original db... (5 Replies)
Discussion started by: express14
6. UNIX for Dummies Questions & Answers
I want to extract a table from an HTML file. the table starts with
and ends with next closing table tag
how can I do this with awk/sed...
---------- Post updated at 04:34 PM ---------- Previous update was at 04:28 PM ----------
also I want to... (4 Replies)
Discussion started by: koutroul
7. Shell Programming and Scripting
I need to extract the data from oracle table and written the below code.
But it is not working.There is some problem with the query and output is shown is No rows selected" . If I run the same query from sql developer there is my required output.
And if I run the shell script with simple sql... (7 Replies)
Discussion started by: giridhar276
8. UNIX and Linux Applications
Pls check that '|' and '+' present in Step-1 are not copied to log file in Step-3.
Pls suggest how to get the exact output from Step-1 (i.e. with out losing '|' and '+') in to a log file
Step-1: Execute command
> mysql -utest -ptest -htesthost testdb -e "select * from... (3 Replies)
Discussion started by: newbielgn
9. Shell Programming and Scripting
i have a list of files that contains some PC hostname, then i need to enumerate every hostname and check if there's a table with same name of the hosts in MySQL database XYZ.
I need this because have to decide automatically if i have to make a create table or a insert into an existent... (2 Replies)
Discussion started by: maxlamax
10. UNIX for Dummies Questions & Answers
I need to extract the table name from an oracle control file which comes as the last word in the third line.
INTO TABLE SCOTT.EMP_SAL
FIELDS TERMINATED BY..........
what i want to to is write the table name SCOTT.EMP_SAL to a... (2 Replies)
Discussion started by: mwrg