Топ-100
 
CerebroSQL

Create "PFile" in the Oracle

PFile is the DBMS parameter file used when manually starting the database. SPFile is created based on PFile

PFile.jpg

-> Request to retrieve data <-

select type, name, value
  from V$SYSTEM_PARAMETER
where isdefault = 'FALSE'
  and value is not null
order by name;

select sys_context ('USERENV', 'DB_UNIQUE_NAME') "Name",
    sys_context ('USERENV', 'SERVER_HOST') "Host" from dual;

-----