Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 28019

Questions on how to import into, extract data from, or exchange data between databases in CSV format (plain text using commas to separate values).

1
vote
I have to import an external csv file into a table in database each day. ... Additionally, It is much appreciated if the importing could be done entirely without the need for GTTs …
answered Oct 31 '15 by Balazs Papp
1
vote
SQL*Plus starting with version 12.2 supports printing the output in CSV format. You can add the below in your script: set markup csv on Then execute your script called myscript.sql as: sqlplus … 'user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.network)(Port=1521))(CONNECT_DATA=(SID=remote_SID)))' @myscript.sql For example: [oracle@o71 ~]$ cat myscript.sql set markup csv on set …
answered Feb 19 '18 by Balazs Papp
0
votes
String are written between "" in the CSV. So your datatype is not string type, or the tool you use for viewing the CSV automatically converts and trims it. [oracle@o71 ~]$ sqlplus -S bp/bp set … markup csv on set echo off spool 1.csv select '04589' as phone from dual union all select '02586' from dual; "PHONE" "04589" "02586" exit [oracle@o71 ~]$ cat 1.csv "PHONE" "04589" "02586" [oracle@o71 ~]$ …
answered Jan 9 by Balazs Papp
1
vote
UTL_FILE.PUT_LINE_NCHAR Procedure This procedure writes the text string stored in the buffer parameter to the open file identified by the file handle. With this function, you can write a text …
answered May 25 '17 by Balazs Papp
5
votes
Just set the below in your session, as you would do in SQL*Plus: set null "null" Note: this will not affect how NULLs are displayed in the data grid (you can set that from the menu: Tools - Preferences - Database - Advanced - Display Null Value As), but it affects the exported CSV. …
answered Mar 14 '17 by Balazs Papp