The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* Select and display data */
procedure verify_values ( run_mode IN varchar2,
duration IN varchar2,
p_num IN varchar2,
p_date IN varchar2,
p_varchar IN varchar2) is
l_nls_lang nls_session_parameters.value%TYPE;
Select Value Into l_nls_lang
From Nls_Session_Parameters
Where Upper(Parameter) = 'NLS_LANGUAGE';
Select Value Into l_nls_terr
From Nls_Session_Parameters
Where Upper(Parameter) = 'NLS_TERRITORY';
Select Value Into l_nls_num_char
From Nls_Session_Parameters
Where Upper(Parameter) = 'NLS_NUMERIC_CHARACTERS';
Select Value Into l_nls_date_fmt
From Nls_Session_Parameters
Where Upper(Parameter) = 'NLS_DATE_FORMAT';
Select Value Into l_nls_date_lang
From Nls_Session_Parameters
Where Upper(Parameter) = 'NLS_DATE_LANGUAGE';
Select Instance_Name Into l_db_inst
From V$Instance;
Select to_char(SYSDATE + (3/1440), 'DD-MON-YYYY HH24:MI:SS')
Into l_rpt_end_time
From Dual;