Print Thread
bugs ,copy words
#59845 04/01/19 09:51 AM
Joined: Feb 2017
Posts: 31
C
Member
OP Offline
Member
C
Joined: Feb 2017
Posts: 31
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;
"
"
"
"

Last edited by childish; 04/01/19 10:01 AM.
Re: bugs,copy words
childish #59846 04/01/19 10:00 AM
Joined: Feb 2017
Posts: 31
C
Member
OP Offline
Member
C
Joined: Feb 2017
Posts: 31
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);


Re: bugs,copy words
childish #59847 04/01/19 01:54 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
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

Re: bugs,copy words
Claus Pedersen #59853 04/03/19 02:21 AM
Joined: Feb 2017
Posts: 31
C
Member
OP Offline
Member
C
Joined: Feb 2017
Posts: 31
yes,you are right.The last word is LF,when I copy the text column,LF changed to "


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.073s Queries: 14 (0.013s) Memory: 2.5144 MB (Peak: 3.0430 MB) Data Comp: Off Server Time: 2024-05-18 20:45:43 UTC
Valid HTML 5 and Valid CSS