开发者

how to retrieve the queries used in a store procedure through jdbc

I have been calling a stored procedure through jdbc and i have a requirement that the queries used in that stored procedure should be displayed on console.

can you suggest a code to retieve the 开发者_如何学JAVAqueries used in the stored procedure from the metadata.


In Oracle, you can see previously executed queries using the v$sql view...

select * from v$session join v$sql using (sql_id)

That's not a history of all statements, though...

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜