Name

SET LOBOFFSET

Synopsis

The LOBOFFSET setting represents an index into a LONG column. When SQL*Plus displays a LONG, it begins with the character pointed to by LOBOFFSET.

Syntax

SET LOBOF[FSET] offset

Parameters

SET LOBOF[FSET]

Is the command, which may be abbreviated SET LOBOF.

offset

Is the offset used when retrieving LONG values and represents the first character you want to display.

Using the LOBOFFSET setting in conjunction with the LONG setting allows you to print any arbitrary substring from a LONG column.

Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.