sql2 0801

PROCEDURĘ jimminy IS

new_va1ue VARCHAR2(35)

BEGIN

new_val := old_val || '-new'; IF new_val LIKE 'open%'

Execution Secuon

THEN    .

END IF;

EXCEPTION

Exception Secuon

WHEN VALUE_ERROR    •

THEN

END;