When you do a search in the Oracle data dictionary, all object names are in uppercase : user_source « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL>
SQL>
SQL> create or replace function getArea (i_rad NUMBER)
  2  return NUMBER
  3  is
  4  begin
  5    return 3.14*(i_rad**2);
  6  end;
  7  /

Function created.

SQL>
SQL>
SQL>
SQL> select text
  2  from user_source
  3  where name = 'GETAREA'
  4  order by line;
 /

TEXT
-------------------------------
function getArea (i_rad NUMBER)
return NUMBER
is
begin
  return 3.14*(i_rad**2);
end;

6 rows selected.

SQL>
SQL>








30.97.user_source
30.97.1.Select the source code from USER_SOURCE
30.97.2.Get source code of procedure and function
30.97.3.Query the Oracle data dictionary view USER_SOURCE
30.97.4.When you do a search in the Oracle data dictionary, all object names are in uppercase
30.97.5.Query user_source for procedure declaration