24: 0,decode(instr(l_sql_statement,'ORDER BY'),0,
25: length(l_sql_statement),
26: instr(l_sql_statement,'ORDER BY') - instr(l_sql_statement,'FROM')),
27: instr(l_sql_statement,'WHERE') - instr(l_sql_statement,'FROM')))
28: into l_from_clause from dual;
29: select decode(instr(l_sql_statement,'WHERE'),
30: 0,Null,
31: substr(l_sql_statement,instr(l_sql_statement,'WHERE'),
32: decode(instr(l_sql_statement,'ORDER BY'),
31: substr(l_sql_statement,instr(l_sql_statement,'WHERE'),
32: decode(instr(l_sql_statement,'ORDER BY'),
33: 0,length(l_sql_statement),
34: instr(l_sql_statement,'ORDER BY') - instr(l_sql_statement,'WHERE'))))
35: into l_where_clause from dual;
36: select decode(instr(l_sql_statement,'ORDER BY'),
37: 0,Null,
38: substr(l_sql_statement,instr(l_sql_statement,'ORDER BY'),
39: length(l_sql_statement)))
36: select decode(instr(l_sql_statement,'ORDER BY'),
37: 0,Null,
38: substr(l_sql_statement,instr(l_sql_statement,'ORDER BY'),
39: length(l_sql_statement)))
40: into l_order_by_clause from dual;
41: ------------------------------------------------------------
42: --dbms_output.put_line('SELECT :'||l_select_clause);
43: --dbms_output.put_line('FROM :'||l_from_clause);
44: --dbms_output.put_line('WHERE :'||l_where_clause);
306: Else
307: flex_query_t_rec.additional_where_clause:= REPLACE(upper(flex_query_t_rec.additional_where_clause),'WHERE',' ');
308: l_add_where_clause := null;
309: select l_where_clause||' '||decode(l_where_clause,null,' ',decode(instr(ltrim(flex_query_t_rec.additional_where_clause,' '),'ORDER BY'),1,' ',' AND '))||flex_query_t_rec.additional_where_clause
310: into l_add_where_clause from dual;
311: l_where_clause := l_add_where_clause;
312: End If;
313: l_query_string := rtrim(ltrim(l_select_clause,' '),' ')||' '||
314: rtrim(ltrim(l_from_clause,' '),' ')||' '||