I am having a problem creating a csv (Comma Separated Value) file with the headings I want. Basically, I am able to create the file but can not seem to change the headings. I am sure it is just matter of placing these in the proper order for the sql to read it, but I have not had any luck.
This works and delivers a comma delimited format:
Sample, (not my code but will give you an idea)SelectBK || ‘,’ ||BS || ‘,’ ||BTOT || ‘,’From inventoryWhereEtc….
But if I try to declare the headings I run into errors:
SelectBK “Bricks” || ‘,’ ||BS “Brick Size” || ‘,’ ||BTOT “All Bricks” || ‘,’From inventoryWhereEtc….BK “Bricks” || ‘,’ || *ERROR at line 2:ORA-00923: FROM keyword not found where expected
I have tried to place the heading declaration at the end, in the middle… nothing seems to work. Any Ideas?