UNIX for Beginners Questions & Answers

i want to extract all data with in parenthesis  from a file by passing a pattern from another file.i have some sql statements in my file and i want to extract those ddl by refering to a pattern which is in another file and before writting into file i need some transformation to do.Basically i want to do this in While/FOR loop

Pattern file:

ABC
XYZ

SRC FILE:

CREATE TABLE ABC
(
A,
B,
C
);

CREATE TABLE XYZ
(
X
);

SO NOW I WANT TO CHECK/PASS THE 1ST PATTERN AND IF MATCHES WHICH IS MATCHING IN SRC FILE THEN I WANT TO EXTRACT DATA WHICH ARE INSIDE PARENTHESIS.desired o/p below:
A,
B,
C

SAME WAY WHEN THE 2ND PATTERN WILL COME IT FOUND THE MATCHING IN SRC FILE AND OUTPUT WRITES IN TO OUTPUT FILE WHICH IS 

A

I WANT TO DO THIS IN LOOP(WHILE/FOR) IN ORDER TO MAKE SOME IN BETWEEN TRANSFORMATION BEFORE WRITING TO OUTPUT FILE.

HOPE THIS HELPS