[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT t2.attribute_name, to_number(LTRIM(b.column_name, 'column'))
from jtf_act_types_tl t1, jtf_act_types_attrs_b b, jtf_act_types_attrs_tl t2
where t1.activity_name = activityname and t1.language=userenv('LANG')
and t1.activity_name_id = b.activity_name_id
and b.attribute_name_id = t2.attribute_name_id and t2.language=userenv('LANG');
SELECT b.table_name
from jtf_act_types_b b, jtf_act_types_tl tl
where b.activity_name_id = tl.activity_name_id
and tl.activity_name = activityname
and tl.language = userenv('LANG');
select activity_name_id into activitynameid from jtf_act_types_tl
where language = userenv('LANG') and activity_name = activityname;
DBMS_SQL.PARSE(cid, 'insert into '|| v_tablename || '(activity_name_id, application_id ,
jtf_act_activity_logs_user_id, created_by, creation_date, last_updated_by,
last_update_date, component, column1, column2, column3, column4,column5,
column6, column7,column8,column9, column10, column11, column12, column13,
column14,column15, column16, column17,column18,column19, column20, column21,
column22, column23, column24,column25, column26, column27,column28, column29,
column30, column31, column32, column33, column34, column35, column36, column37,
column38, column39, column40)
values (:activitynameid, :appid, :userid, :userid, sysdate, :userid, sysdate,
:component, :column1, :column2, :column3, :column4, :column5, :column6, :column7,
:column8, :column9, :column10, :column11, :column12, :column13, :column14, :column15,
:column16, :column17, :column18, :column19, :column20, :column21, :column22,
:column23, :column24, :column25, :column26, :column27, :column28, :column29,
:column30, :column31, :column32, :column33, :column34, :column35, :column36,
:column37, :column38, :column39, :column40 )', dbms_sql.v7);