declare test1 varchar2(50);
begin
DECLARE
CURSOR c IS SELECT
*
FROM
user_tab_columns
WHERE
Table_Name = 'SHIP_PROP';
BEGIN
for v_temp in c loop
execute immediate 'select instr('''|| v_temp.column_name ||''', ''JOBNO'' ,1,1)-1 from dual' into test1;
dbms_output.put_line(test1||':' ||v_temp.column_name);
END loop;
END;
END;
begin
DECLARE
CURSOR c IS SELECT
*
FROM
user_tab_columns
WHERE
Table_Name = 'SHIP_PROP';
BEGIN
for v_temp in c loop
execute immediate 'select instr('''|| v_temp.column_name ||''', ''JOBNO'' ,1,1)-1 from dual' into test1;
dbms_output.put_line(test1||':' ||v_temp.column_name);
END loop;
END;
END;