Show some constants
The following script shows the values of the three constants is_oracle_server
, is_oracle_client
and is_timesten
.
declare
function b2v(b boolean) return varchar2 is -- {
begin
if b then return 'true'; end if;
return 'false';
end b2v; -- }
begin
dbms_output.put_line('is_oracle_server: ' || b2v(utl_ident.is_oracle_server));
dbms_output.put_line('is_oracle_client: ' || b2v(utl_ident.is_oracle_client));
dbms_output.put_line('is_timesten: ' || b2v(utl_ident.is_timesten ));
end;
/
Typical usage
$if utl_ident.is_oracle_server $then
code supported for Oracle Database
$elsif utl_ident.is_timesten $then
code supported for TimesTen Database
$end