![]() ![]() It is great for someone who loves the Copy+Paste feature instead of Exporting the grid, because any csv query you run after this steps, will be formatted as the last Export, till you make a new export. So the /*csv*/ keep the last Export Parameters… Am I right? The expected output should have been like in the number 3…ĥ. Get back to Query Result view, and export the grid (manually) with csv option and set Left&Right Enclosure as. Output: since id is INTEGER and code is VARCHAR2:ģ. Select /*csv*/ id, code from mytable - note: id is INTEGER, code is VARCHAR2 I hope you can comment me something related to this: Let me explain this to you with the following steps. However, in my case it is taking the LAST parameters after exportation from grid. ![]() I was studying all this features, and after making some tests i found that after using Export Tool from grid it seems that the /*csv*/ parameters are overwritten after the exportation.īut you wrote here when you are using /*csv*/ feature, it is always taking the DEFAULT options for CSV. So that was kind of a ‘trick’ – I’m not sure it’s a documented feature, although Kris did talk about it WAAAAAAAY back in 2007.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |