Opposite Oracle command "ALTER SYSTEM SET"

Question

I am looking at some code and I see that someone is writing the following pl / sql.

alter system set smtp_out_server = '123.345.134.123';

Since this is a mutator (setter), what accessor (receiver) of this command?

CHOOSE what from this place can be viewed in the settings SMTP_OUT_SERVER?

Thank,

Mj

+5

mj_ Jan 27 '12 at 15:27

2 answers

select * from v$parameter

This should get the settings, add a where clause for the specific one you are after

+2

Andrew Jan 27 '12 at 15:32

John doyle · Accepted Answer · 2012-01-27T15:31:08+0000

Try:

select *
  from V$PARAMETER
 where NAME = 'smtp_out_server';

Or, in a session, sqlplusyou can enter:

show parameter smtp_out_server