bugs ,copy words

[childish]

When I copy the result of select text from dba_source,The first paste word is ",but I dont see from the result

paste result is following:

"package STANDARD AUTHID CURRENT_USER is -- careful on this line; SED edit occurs!
"
"
"
" /********** Types and subtypes, do not reorder **********/
"
" type BOOLEAN is (FALSE, TRUE);
"
"
"
" type DATE is DATE_BASE;
"
"
"
" type NUMBER is NUMBER_BASE;
"
" subtype FLOAT is NUMBER; -- NUMBER(126)
"
" subtype REAL is FLOAT; -- FLOAT(63)
"
" subtype ""DOUBLE PRECISION"" is FLOAT;
"
" subtype INTEGER is NUMBER(38,0);
"
" subtype INT is INTEGER;
"
" subtype SMALLINT is NUMBER(38,0);
"
" subtype DECIMAL is NUMBER(38,0);
"
" subtype NUMERIC is DECIMAL;
"
" subtype DEC is DECIMAL;
"
"
"
"

 

[childish]

I think that this is right.

package STANDARD AUTHID CURRENT_USER is -- careful on this line; SED edit occurs!

/********** Types and subtypes, do not reorder **********/

type BOOLEAN is (FALSE, TRUE);

type DATE is DATE_BASE;

type NUMBER is NUMBER_BASE;

subtype FLOAT is NUMBER; -- NUMBER(126)

subtype REAL is FLOAT; -- FLOAT(63)

subtype ""DOUBLE PRECISION"" is FLOAT;

subtype INTEGER is NUMBER(38,0);

subtype INT is INTEGER;

subtype SMALLINT is NUMBER(38,0);

 

[Claus Pedersen]

I do not know how you copy the text and where you see the result with " in front of all the lines, but I believe that it maybe has something to do with the fact that Oracle will always end a line in dba_source with a line feed (ascii 10).

You can see it, if you perform the following select:
SELECT text, dump(text) FROM dba_source

All lines end with the line feed character.

To get the 'clean' code data (without the trailing line feed), use the select:
SELECT substr(text, 1, length(text)-1) FROM all_source

 

[childish]

yes,you are right.The last word is LF,when I copy the text column,LF changed to "