Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Export worksheet query result header column problem

Luis CaprilesJan 25 2025

Hi!

When exporting -tested format CSV to clipboard- the query result, and one of the column header has a “/”, the header is wrong:

for this query

select EMPNO||'/'||DEPTNO "EmpNo/DepNo"
,ENAME "Name",JOB "Job",MGR "Mgr"
from EMP;

When I paste the clipboard, I get this output

"ENAME "Name"","Name","Job","Mgr"
"7839/10","KING","PRESIDENT",0
"7698/30","BLAKE","MANAGER",7839

Where the correct header would be "EmpNo/DepNo". If I change the offending “/” by space or “:”, the pasted output is correct:

"EmpNo:DepNo","Name","Job","Mgr"
"7839/10","KING","PRESIDENT",0
"7698/30","BLAKE","MANAGER",7839

Regards

Comments
Post Details
Added on Jan 25 2025
1 comment
72 views