Thursday, February 23, 2006
Ver Plataforma no SQL*Plus
Va versão 10g existe uma nova coluna na v$database: PLATFORM_NAME.
Mas na 9i - NÃO.
SQL> select platform_name from v$database;
PLATFORM_NAME
------------------------------------------------------------------------
Microsoft Windows IA (32-bit)
1 row selected.
SQL> select platform_name from v$database;
PLATFORM_NAME
-------------------------------------------------------
10 Linux IA (32-bit)
1 row selected.
Mas na 9i - NÃO.
SQL> select platform_name from v$database;
select platform_name from v$database
*
ERROR at line 1:
ORA-00904: "PLATFORM_NAME": invalid identifier
Para 9i e 8i usamos o
SQL> select dbms_utility.port_string from dual;
PORT_STRING
--------------------------------------------------------
Linuxi386/Linux-2.0.34-8.1.0
1 row selected.
