Oracle PL/SQL - Get PL/SQL source code

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Introduction
  4. Basics of PL/SQL Programs

Introduction

You can query the Oracle data dictionary view USER_SOURCE: 

SQL> select text 
2  from user_source 
3  where name = 'F_GETAREA_NR' 
4  order by line; 
TEXT 
------------------------------------ 
function f_getArea_Nr (i_rad_nr) 
 return NUMBER 
is 
  v_pi_nr NUMBER:=3.14; 
begin 
 return v_pi_nr * (i_rad_nr ** 2); 
end; 
7 rows selected.

You can copy the result into any text editor, modify it, and paste it back.

When you do a search in the Oracle data dictionary, all object names are in uppercase.

Related Topic