View object source in DB

Oracle

select text from user_source

DB2

select text from syscat.tables

select text from syscat.procedures

where procschema= and procname=