Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- DATE_MONTH||
- '|'||A||
- '|'||B||
- '|'||C||---decimal column
- '|'||D||---decimal column
- '|'||E||
- '|'||F||
- '|'||G||---decimal column
- '|'||H||---decimal column
- '|'||I||---decimal column
- '|'||J||
- '|'||K||
- '|'||H||
- '|'||'"'||REPLACE(L, '"', '"' )|| '"'||
- '|'||M||
- '|'||'"' || REPLACE(N, '"', '"' )|| '"'||
- '|' ||O||
- '|'||TO_DATE(sysdate, 'YYYY-MM-DD')||
- '|'||INFO_IS_DELETED||
- '|'||'"' || REPLACE(P, '"', '"' )|| '"'
- from xxxxxxx where ROWNUM<=1000;
Add Comment
Please, Sign In to add comment