Question v can see the procedure that v created by select * from user_object where user_object ='procedure'.. but my question is how can v see the particular procedures code in from our orecal server..
plz reply me...
Answer Hi Sneha,
To check your procedure code, you can check the table user_source or all_source.
select line, text
from user_source
where name = 'XXXX'
order by line;
Here XXXX is the procedure name (in caps). You will get all your code line by line (the format is not proper).
