Search Results

Thanks for your reply. But the thing is after fetching the data from Oracle into UNIX into a flatfile and applying the above mentioned commands are giving wrong results.

Hi,

I am having source (Oracle) as given below.
SourceOBJECT_NAMESUBOBJECT_NAMEOBJECT_IDDATA_OBJECT_IDOBJECT_TYPECREATEDLAST_DDL_TIMESTAMPSTATUSTGSTEST 336559336559TABLE4/15/2009...

Hi bartus11,

Can you please explain what the above 'awk' is doing?

Thanks to all who replied to my question :)

Thanks for the reply bartus11
Can we do the samething with SED or AWK command? If yes can you please give me the answer?

You can see that it's a comma delimiter. It means each and every record is identified by a comma.
But if you notice the last record, The 2nd column is separated by 2 commas, and also 3rd column is...

Hello,

I am having flat file (Comma Delimiter) and the data in the file is as given below.

EMPNO, ENAME, DESIGNATION, SALARY
10979, Arun Kumar, Cosultant, 35000
13555, Bidhu...

Excellent !!!

Thanks alot guys :)

Thanks for your replies.

Hi Usha,

Now i am facing another issue.
Source:
8-9KH-1733 07-NOV-08 8-1729UB 04-DEC-08 8-1729UB 1 8-9KH-1733 N Y N N N Y Y Y...

Hi,

Requirement: Exporting data from Oracle to UNIX into "Comma" delimiter.

Help Needed: I was able to connect to Oracle and import the data. But please let me know while importing the data I...

Hi Cero,

Thanks for your reply.
Yes I am using sqlplus to connect to oracle. I can able to store the file. But the issue is i want to store the file in Comma delimiter. Can you please...

Hello,

I am new to UNIX.

My Requirement: Need to connect to Oracle database from UNIX and execute an SELECT statement and store the records in a flatfile of Comma delimiter.
...