Oracle›String Functions›SUBSTRB
←SUBSTR

SUBSTRBString Functions

LENGTH→

Extracts a substring by byte position.

Syntax

SUBSTRB(str, pos [, len])

Example

Enter values below to update the example in real time.

product_desc→
short_desc→
products→
SELECT SUBSTRB(product_desc, 1, 30) AS short_desc
FROM products;