Re: what is this? and where can I learn more about it?

bullseye wrote:

> SPOOL slave.sql
> SELECT 'SELECT' ||''''table_name''''||', COUNT(*) FROM '||table_name||';'
> FROM user_tables
> /
> SPOOL table.lst
> @slave
> SPOOL OFF
It is a select statement that builds select statements for every table in user_tables.

There isn't much to learn. The four tics produce a single tic in the output.

Daniel A. Morgan Received on Wed Aug 01 2001 - 13:30:25 CDT