Suppose we are writing some new query/script/SP and we want to see the code of preexisting SP in query window itself without going Schema Browser or Directly going to that object
We can able to do this in both Oracle and Sql Server.
select * from USER_SOURCE where Name =’PRC_SEND_EMAIL’ — Provided you are given permission to access USER_SOURCE
there is also one more way
— DBA specific Schema specific need to have permission to see this.
select * from DBA_SOURCE where Name =’PRC_SEND_EMAIL’
— You can see signature of the procedure in Current Schema
In Sql server we can do the same with the help of