The following lines contain the word 'select', 'insert', 'update' or 'delete':
:= 'SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = ';
PROCEDURE create_View_Select_Text_Table
( p_view_name IN BIS_VG_TYPES.View_name_Type := null
, x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
, x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
)
IS
--
l_eod BOOLEAN;
BIS_DEBUG_PUB.Add('> create_View_Select_Text_Table');
x_View_Select_Text_Table(x_View_Select_Text_Table.COUNT + 1):= l_string;
BIS_DEBUG_PUB.Add('< create_View_Select_Text_Table');
, p_error_proc_name => G_PKG_NAME||'.create_View_Select_Text_Table'
, p_error_table => x_error_tbl
, x_error_table => x_error_tbl
);
END create_View_Select_Text_Table;
, x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
, x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
)
IS
l_count NUMBER;
select COLUMN_NAME
from user_tab_columns
where TABLE_NAME=Upper(p_view_name)
order by COLUMN_ID;
create_View_Select_Text_Table ( p_View_name
, x_View_Select_Text_Table
--- , x_return_status
, x_error_Tbl
);
BIS_DEBUG_PUB.Add('text count = '||x_View_Select_Text_Table.COUNT);
SELECT application_id
FROM fnd_application
WHERE application_short_name = Lower(p_short_name);
select
view_name
, text_length
FROM user_views
WHERE
(
view_name LIKE '__BV\_%' escape '\'
OR view_name LIKE '__FV\_%' escape '\'
OR view_name LIKE '___BV\_%' escape '\'
OR view_name LIKE '___FV\_%' escape '\'
)
AND view_name IN (
SELECT
DISTINCT(table_name) view_name
FROM user_tab_columns
WHERE
column_name LIKE Upper(p_like_str) escape '\'
OR column_name LIKE Lower(p_like_str) escape '\'
)
;
select
view_name
, text_length
FROM user_views
WHERE view_name = Upper(p_view_name);
select
view_name
, text_length
FROM user_views
WHERE view_name LIKE Upper(p_app_abbrev)||'BV\_%' escape '\'
OR view_name LIKE Upper(p_app_abbrev)||'FV\_%' escape '\';
select
view_name
, text_length
FROM user_views
WHERE view_name LIKE 'HR'||'BV\_%' escape '\'
OR view_name LIKE 'HR'||'FV\_%' escape '\'
OR view_name LIKE 'IRC'||'BV\_%' escape '\'
OR view_name LIKE 'IRC'||'FV\_%' escape '\';
select
view_name
, text_length
FROM user_views
WHERE view_name LIKE '__BV\_%' escape '\'
OR view_name LIKE '__FV\_%' escape '\'
OR view_name LIKE '___BV\_%' escape '\'
OR view_name LIKE '___FV\_%' escape '\';