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
4 rows selected.
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_EXTENTMAX_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