INFORMIX equivalent of DBSERVERNAME in ORACLE

From: Rajiv Jhaveri <rjhaveri_at_optonline.net>
Date: Thu, 22 Jul 2004 10:58:13 -0400
Message-ID: <cdok0k$q4u9_at_kcweb01.netnews.att.com>



Folks,

    In INFORMIX there is a default value called DBSERVERNAME that can be assigned to a column during the table definition as follows:

   create table t1 (c1 char(18) default DBSERVERNAME );

Is there an ORACLE 9i equivalent for DBSERVERNAME that can be used in the table.column definition?

PS : DBSERVERNAME in INFORMIX is the instance name

Thanks.

--
Rajiv Jhaveri
rjhaveri_at_optonline.net
Received on Thu Jul 22 2004 - 16:58:13 CEST

Original text of this message