Visit Our UNIX and Linux User Community


extract table name from a control file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers extract table name from a control file
# 1  
Old 10-31-2009
extract table name from a control file

Hi,

I need to extract the table name from an oracle control file which comes as the last word in the third line.

Ex:

LOAD DATA
INFILE '/home/user/files/scott.dat'
INTO TABLE SCOTT.EMP_SAL
FIELDS TERMINATED BY..........

what i want to to is write the table name SCOTT.EMP_SAL to a new file. Please help!

---------- Post updated at 03:27 PM ---------- Previous update was at 03:24 PM ----------

forgot to mention. It's a bash shell.
# 2  
Old 10-31-2009
Hi.

Code:
awk '/INTO TABLE/ {print $NF}' control_file > new_file

This User Gave Thanks to Scott For This Post:
# 3  
Old 11-01-2009
Smilie thanks scottn. It worked like a charm. Smilie
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #808
Difficulty: Easy
The CSS RGB Hex Code for Green is #008000.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parameterizing to dynamically generate the extract file from Oracle table using Shell Script

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. First Requirement: I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies

2. Shell Programming and Scripting

Extract table from file

I need to sort out table in a file to a format below: Input: this is a test example Cat Bee Dat 1 2 3 more Example date data Bet Cla Blaa Dat A 6 T data.. Output: this is a test (10 Replies)
Discussion started by: aydj
10 Replies

3. Shell Programming and Scripting

Script to create the SQLLDR control file from Oracle table.

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 table_nme column_nme DEPT ... (2 Replies)
Discussion started by: pimmit22043
2 Replies

4. Shell Programming and Scripting

Create a control file from Table definition

Hi Team, 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 Table structure: create multiset table tbl1, no fallback, no before journal, no after journal, checksum = default, default mergeblockratio... (7 Replies)
Discussion started by: unankix
7 Replies

5. Shell Programming and Scripting

Oracle table extract: all columns are not converting into pipe delimited in flat file

Hi All, 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
5 Replies

6. UNIX for Dummies Questions & Answers

Extract table from an HTML file

I want to extract a table from an HTML file. the table starts with <table class="tableinfo" and ends with next closing table tag </table> 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
4 Replies

7. Shell Programming and Scripting

Script to generate sheet with control-m table names

hi , 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
6 Replies

8. Shell Programming and Scripting

connecting to table to extract multiple rows into file from unix script

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
7 Replies

9. Shell Programming and Scripting

Extract Mysql table output to a log file

I need to compare the 2 mysql database tables. there are around 50 tables in each DB. my idea is in DB1 extract result select * from table1; to alog file1 in DB2 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
5 Replies

Featured Tech Videos