By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab(col)
AS
SELECT 'Product|Cash|Loan|Customer' FROM dual
1 rows affected
SELECT col, LENGTH(col) - LENGTH(REPLACE(col, '|')) AS pipe_count
FROM tab
| COL | PIPE_COUNT |
|---|---|
| Product|Cash|Loan|Customer | 3 |