[Home] [Help]
259: l_char VARCHAR2(1);
260: --
261: CURSOR c_all_columns IS
262: select COLUMN_NAME
263: from user_tab_columns
264: where TABLE_NAME=Upper(p_view_name)
265: order by COLUMN_ID;
266: --
267: BEGIN
506: )
507: AND view_name IN (
508: SELECT
509: DISTINCT(table_name) view_name
510: FROM user_tab_columns
511: WHERE
512: column_name LIKE Upper(p_like_str) escape '\'
513: OR column_name LIKE Lower(p_like_str) escape '\'
514: )