SQL Plus - Colsep (column separator character)

Card Puncher Data Processing

About

The COLSEP system variable determines the column separator character to be printed between column output. Sets the text to be printed between selected columns.

In ISQL Plus, column separator character that is rendered inside

tags
Articles Related
Syntax
COLSEP { | text}

default: |

Example
set COLSEP ;





Discover More
Card Puncher Data Processing
SQL Plus - Csv Export

How to export a CSV with SQL Plus. Export of the tables all_objects where:
Card Puncher Data Processing
System Variable

s Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus will fetch...



Share this page:
Follow us:
Task Runner