SQL Language (MOSC)

MOSC Banner

UTL File

edited Jun 26, 2015 10:05AM in SQL Language (MOSC) 5 commentsAnswered

HI

I'm trying to pull data from a table and place in a excel file but there is Description column in the table and some records  consisting of  large description like below which is next line

P-12017-002 -MAGGIE DALEY PARK RENOVATION PHASE 2

“FOR PAYMENT ONLY - DO NOT F 1859702.07

When these kind of description is in the table the next line is going to the next row which is causing the report to be not clear.

Below is what i'm using...is there any way to change as we cant change the data


BEGIN
-- file_name := 'C_FA_ADD'||to_char(i_check_date,'MMDD')||'.TXT';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center