Buscar código en vistas de Oracle con PL/SQL
DECLARE lncount NUMBER; lvsearch VARCHAR2(100) := lower(’cadena_buscar’); CURSOR cur_views IS SELECT * FROM all_views t where view_name like ‘XX%’; lrow_views cur_views%ROWTYPE; v_line VARCHAR2(30000); BEGIN lncount := 0; OPEN cur_views; LOOP ...