DBA Data[Home] [Help]

APPS.CSF_SPATIAL_TTSP_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 106

    SELECT SYSDATE INTO l_date FROM dual;
Line: 108

    SELECT instance_name INTO l_instance_name from v$instance;
Line: 339

    SELECT SYSDATE INTO l_date FROM dual;
Line: 341

    SELECT instance_name INTO l_instance_name from v$instance;
Line: 398

      SELECT SUBSTR(l_data_file_dir, length(l_data_file_dir)) INTO l_temp  FROM dual;
Line: 410

        SELECT SUBSTR(l_data_file_str, 1, INSTR(l_data_file_str , ',')-1) INTO l_data_file FROM dual;
Line: 412

        SELECT SUBSTR(l_data_file_str, INSTR(l_data_file_str , ',')+1) INTO l_data_file_str FROM dual;