开发者

oracle select from a in memory table in PLSQL

I have a PLsql table empnos Sys.odcinumberlist. This table has many entries in it. Now 开发者_如何学编程in the same program I want to select from this table using

select x from table(empnos) . Now what is the x in this case . I tried value , values among other things but to no avail.

thanks


It's COLUMN_VALUE. e.g.

declare
  x sys.odcinumberlist := sys.odcinumberlist(123);
  y number;
begin
  select column_value into y from table(x);
  dbms_output.put_line(y);
end;
0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜