9 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
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
3. Shell Programming and Scripting
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
DEPT ... (2 Replies)
Discussion started by: pimmit22043
4. Shell Programming and Scripting
I need to create a control file with a pre-defined structure for a given table name. The table is in teradata.
Ex: Table Name: TBL1
create multiset table tbl1, no fallback,
no before journal,
no after journal,
checksum = default,
default mergeblockratio... (7 Replies)
Discussion started by: unankix
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 have control-m tool where i can schedule my unix script jobs to run automatically by created them in a table..
now i want a script to generate the sheet with table names that are created in cotrol-m tool...
i dont know whether it possible or not..
thanks in advance.
hemanth saikumar (6 Replies)
Discussion started by: hemanthsaikumar
8. 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
9. Shell Programming and Scripting
I need to compare the 2 mysql database tables. there are around 50 tables in each DB.
my idea is
extract result select * from table1; to alog file1
extract result select * from table1; to alog file2
now compare log file 1 file 2
pls help me out ...
thanks in advance (5 Replies)
Discussion started by: kalyankalyan