Oracle query `select some_name(?) from dual`. What is `some_name` and how to view the source?

Question

I am looking at an already existing code base which connects to an Oracle database. It contains the query that looks like select some_name(?) from dual. What is some_name here? Is it a stored procedure? How can I view the source code for that function?

Answer 1

if you have SQLDeveloper, you can view the source code of SOME_NAME function in the function section, or TOAD, you can find it in the Schema Browser,

or you can query it using below select statement,

SELECT *
  FROM all_source
 WHERE name = 'SOME_NAME'
 ORDER BY line;