UNIX and Linux Applications

select titolo,lingua from titolo where titolo ~*  'brivid';

 titolo  | lingua 
 ------- + ------  
 Brivido | 1

SQL> select titolo,genere,anno,lingua  from titolo where titolo like '%rivid%';

TITOLO --------------------------------------------------------------------------------     GENERE ANNO     LINGUA ---------- ---- ---------- 
Brivido      1 1986      1

SET COLSEP {_|text}
 
In iSQL*Plus, SET COLSEP determines the column separator character to be printed between column output 
that is rendered inside tags. HTML table output is the default. To generate preformatted output you must set 
PREFORMAT ON with the SET MARKUP HTML PREFORMAT ON command.
 
Sets the text to be printed between selected columns. If the COLSEP variable contains blanks or punctuation 
characters, you must enclose it with single quotes. The default value for text is a single space.
 
In multi-line rows, the column separator does not print between columns that begin on different lines. The 
column separator does not appear on blank lines produced by BREAK ... SKIP n and does not overwrite the 
record separator. See SET RECSEP in this chapter for more information.
Example
 
To set the column separator to "|" enter
 
SET COLSEP '|'
SELECT LAST_NAME, JOB_ID, DEPARTMENT_ID
FROM EMP_DETAILS_VIEW
WHERE DEPARTMENT_ID = 20;
 
LAST_NAME                |JOB_ID    |DEPARTMENT_ID
-------------------------|----------|-------------
Hartstein                |MK_MAN    |           20
Fay                      |MK_REP    |           20

SQL> set COLSEP "|" 
SQL> select titolo,anno from titolo where titolo = 'Brivido';

TITOLO
--------------------------------------------------------------------------------
ANNO
----
Brivido
1986

set linesize 9000 colsep |

column titolo format a30
column anno   format a20

select titolo,anno from titolo where titolo = 'Brivido';