How to View Oracle Stored Procedure using SQLPlus?

Question

How can I view the code of a stored procedure using sqlplus for Oracle 10g?

When I type in:

desc daily_update; 

it shows me the parameter, but when I try to do the following:

select * from all_source where name = 'daily_update';

I get

no rows selected

What am I doing wrong?

Answer 1

Implement upper case converter and search only for procedures.

Select * from ALL_SOURCE
where NAME = upper('daily_update')
and TYPE = 'PROCEDURE';

Answer 2

check your casing, the name is typically stored in upper case

SELECT * FROM all_source WHERE name = 'DAILY_UPDATE' ORDER BY TYPE, LINE;