Article Figure 1 Figure 2 Figure 3 Listing 1
Listing 2 Listing 3 Table 1 Table 2 jul2005.tar

Listing 3 table_col.sql

REM
REM Author: Mihalis Tsoukalos
REM Date: Friday 04 March 2005
REM

set echo off
set heading off embedded off verify off
set feedback off
spool table_col.log

btitle off
ttitle off
set termout off

SELECT table_name, column_name
FROM user_tab_columns
ORDER BY table_name
/

PROMPT TABLESPACES

SELECT table_name, tablespace_name
FROM user_tables
/

spool off