Oracle SQL Developer:如何从引用游标查看结果?
问题描述:
如果我有一个返回查询的参考光标的函数,如何在SQL Developer中查看其结果集? Toad有一个特殊的选项卡,用于查看参考光标的结果,这是我想找到的功能.
If I have a function which returns a reference cursor for a query, how can I view the result set of this in SQL Developer? Toad has a special tab for viewing the results of a reference cursor, this is the functionality I would like to find.
答
双击结果记录中的光标字段.右侧有一个"..."图标.点击此按钮,您将看到内容
Double click the cursor fields in your result record. On the right side there is a "..." icon. Click this and you'll see the contents