🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.bazy-danych
Article #195665

oracle 11 - wynik do pliku csv

#195665
From: goo-mlyny
Date: Thu, 28 Feb 2019 12:13
6 lines
1399 bytes
Czy jest jakiś sposób, żeby wynik zapytania zapisać do pliku CSV - ale w taki najprostszy sposób, bez żadnego formatowania, bez uzupełniania pól spacjami, bez wyszczególniania pól w select itp.?
Czyli np. taki SQL: "select * from tabela" da mi plik:

kolumna1,kolumna2,kolumna3
wartosc1,123,qwe
wart2,432,poi
Technical Details
Message-ID: <9ac4ef9e-c60a-4701-8f43-dfa2e923f2ea@googlegroups.com>
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!goblin1!goblin.stu.neva.ru!y42no160373ita.0!news-out.google.com!d79ni148itc.0!nntp.google.com!y22no161350ita.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Received: by 2002:a24:5dc9:: with SMTP id w192mr3082172ita.33.1551356037376;        Thu, 28 Feb 2019 04:13:57 -0800 (PST)
X-Received: by 2002:aca:ebcd:: with SMTP id j196mr2871169oih.18.1551356037107; Thu, 28 Feb 2019 04:13:57 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!goblin1!goblin.stu.neva.ru!y42no160373ita.0!news-out.google.com!d79ni148itc.0!nntp.google.com!y22no161350ita.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych
Date: Thu, 28 Feb 2019 04:13:56 -0800 (PST)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=82.160.35.66; posting-account=fWqZgQoAAADitsi6_KUSRGX4FN2qsdaB
NNTP-Posting-Host: 82.160.35.66
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <9ac4ef9e-c60a-4701-8f43-dfa2e923f2ea@googlegroups.com>
Subject: oracle 11 - wynik do pliku csv
From: goo-mlyny@ciach.net
Injection-Date: Thu, 28 Feb 2019 12:13:57 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit