INFORMIX equivalent of DBSERVERNAME in ORACLE

Rajiv Jhaveri

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
rj******@optonline.net

Jul 19 '05 #1