Finde värdi i tabel.
Skal finde en värdi i en tabel med ekstremt mange kolonner. Jeg ved ikke hvilken kolonne värdien findes. Fandt dette script på nettet men ved ikke hvordan det skal köres, eller hvis nogen har et i ren SQL:set feedback off
set pagesize 0
set verify off
accept table_name prompt 'Enter table name: '
accept value_str prompt 'Enter value to be searched: '
set termout off
spool fi.sql
select 'set feedback off' from dual;
select 'prompt' from dual;
select 'prompt ****************************************' from dual;
select 'prompt &value_str is found in the following rows' from dual;
select 'prompt ****************************************' from dual;
select 'select * from &table_name where ' from dual;
select 'upper(' || column_name || ') like upper(''%&value_str.%'') or '
from user_tab_columns
where
table_name=upper('&table_name') and
column_id < ( select max(column_id)
from user_tab_columns
where table_name = upper('&table_name'));
select 'upper(' || column_name || ') like upper(''%&value_str%''); '
from user_tab_columns
where table_name = upper('&table_name') and
column_id = (select max(column_id)
from user_tab_columns
where table_name = upper('&table_name'));
spool off
set termout on
@fi.sql