SQL & PL/SQL

Hi,

In SQL*Plus script, I would like to keep conditional checking (IF statement) and proceed. For example, whatever is done in PL/SQL block below, want to do the same in SQL*Plus script, I know partly it can be done using VARIABLE keyword, conditional checking can be done using DECODE in SELECT statement, but I want to carry out a more complex requirement, hence I want to use IF statement somehow in SQL*Plus.

Another question, how to do spooling in PL/SQL script, it can be done using UTL_FILE, any other option is there to achieve this.

declare
v_ind_count int;
begin

select count(1) into v_ind_count from user_indexes where index_name = 'index_object_name';

IF v_ind_count > 0
THEN
dbms_output.put_line('index found');
ELSE
dbms_output.put_line('index does not exist');
END IF;
end;
/