RE: Searching a value into the DB

From: Juan Miranda <jmiranda_at_mundo-r.net>
Date: Fri, 2 Mar 2001 20:01:29 -0000
Message-ID: <97oqgr$4c11_at_cesio.mundo-r.com>

This script put all the data of the db in a file. Then look in these file.

---

PROMPT EXTRAE TODOS LOS DATOS DEL USUARIO set serveroutput on
set feed off
set linesize 200
set pagesize 2000
spool c:\DATOS.tmp

DECLARE BEGIN
dbms_output.enable(1000000);

for rec in
(
 select table_name from user_tables
)
loop
 dbms_output.put_line
(

  'PROMPT *********************'

 );
 dbms_output.put_line
(

  'PROMPT TABLA: '||rec.table_name||';'  );
 dbms_output.put_line
(

  'select * from '||rec.table_name||';'
 );
end loop;

END;
/

spool off

spool c:\DATOS_TXT.txt
_at_c:\DATOS.tmp
spool off

set feed on

---

Support <support_at_PLEASE_DO_NOT_SPAM_bilbao.com> escribió en el mensaje de noticias 3a9fbe5a.199375086_at_news.sarenet.es...

> I know it is a simple script, but ...
>
> How could I find a value among every tables?
>
> The value is 'XXXXXX', but I do not know the name of the field nor the
> name of the table...
>
> Any easy script?
>
> ==============
> MIRELLO

Received on Fri Mar 02 2001 - 21:01:29 CET