Hi All,
I'm using express version of oracle and lately I try to learn about useful tables and views in SYS schema that can be used to get information about schema objects and etc. In doing this I've come to known about v$parameter and want know what type of schema object it is and then found out its a synonym owned by PUBLIC schema. So then I've got underlying DDL of this synonym using DBMS_METADATA.GET_DDL and result is output as
CREATE OR REPLACE PUBLIC SYNONYM "V$PARAMETER" FOR "SYS"."V_$PARAMETER"
Eventually I was curious to find out what is the underlying DDL for SYS.V_$PARAMETER and got it as
CREATE OR REPLACE FORCE VIEW "SYS"."V_$PARAMETER" ("NUM", "NAME", "TYPE", "VALUE", "DISPLAY_VALUE", "ISDEFAULT", "ISSES_MODIFIABLE", "ISSYS_MODIFIABLE", "ISINSTANCE_MODIFIABLE", "ISMODIFIED", "ISADJUSTED", "ISDEPRECATED", "ISBASIC", "DESCRIPTION", "UPDATE_COMMENT", "HASH") AS
select "NUM","NAME","TYPE","VALUE","DISPLAY_VALUE","ISDEFAULT","ISSES_MODIFIABLE","ISSYS_MODIFIABLE","ISINSTANCE_MODIFIABLE","ISMODIFIED","ISADJUSTED","ISDEPRECATED","ISBASIC","DESCRIPTION","UPDATE_COMMENT","HASH" from v$parameter
So that's where I've got into a bit of confusion because synonym name and name of underlying source of this V_$PARAMETER both are same and when I've searched underlying source using DBA_OBJECTS or DBA_CATALOG then always only synonym has come up. So any help to clarify this confusion?
Regards.