Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> INFORMIX equivalent of DBSERVERNAME in ORACLE

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@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 - 09:58:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US