SQLize Online / PHPize Online  /  SQLtest Online

DROP TABLE text_sample; CREATE TABLE text_sample ( id number(10) NOT NULL, sample varchar2(255) NOT NULL ); INSERT ALL INTO text_sample(id, sample ) VALUES (200,'Абонент' ) INTO text_sample(id, sample ) VALUES (300,'Завершена') INTO text_sample(id, sample ) VALUES (10001,'Ошибка') INTO text_sample(id, sample ) VALUES (10009,'Отправлена') SELECT * FROM dual; SELECT * FROM text_sample; CREATE OR REPLACE Function sample_to_comment ( name_in IN number ) RETURN varchar2 IS result varchar2; cursor c1 is SELECT sample FROM text_sample WHERE id = name_in; BEGIN open c1; fetch c1 into result; if c1%notfound then result := 'no'; end if; close c1; RETURN result; END; select sample_to_comment(35014) as a, sample_to_comment(0)