Re: SQL for retrieving default value of a table

From: Hakan Eren <heren_at_home.com>
Date: 2000/02/15
Message-ID: <38A97DC8.A6E2F6DF_at_home.com>#1/1


Hi,

what dow you mean by default value?

I assume you mean default storage values. If this is the case it gets defaults from the tablespace defaults:

SQLWKS> select * from dba_tablespaces

     2> 
TABLESPACE_NAME                INITIAL_EX NEXT_EXTEN MIN_EXTENT
MAX_EXTENT PCT_INCREA STATUS CONTENTS
------------------------------ ---------- ---------- ----------
---------- ---------- --------- ---------
SYSTEM                              12288      12288          1       
249         50 ONLINE    PERMANENT
USER_DATA                           20480      20480          1       
249         50 ONLINE    PERMANENT
ROLLBACK_DATA                       20480      20480          1       
249         50 ONLINE    PERMANENT
TEMPORARY_DATA                      20480      20480          1       
249         50 ONLINE    PERMANENT

4 rows selected.

Hakan

Harmony Wong wrote:
>
> Hi,
>
> Does anyone know the sql of this?
>
> Regards,
> Harmony
Received on Tue Feb 15 2000 - 00:00:00 CET

Original text of this message