Re: function returning object type and print the attributes
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 18 Jul 2016 16:17:04 +0300
Message-ID: <CAOVevU5oOnP8TyyPwuHpqY1HVtRe-bJYEwXzjboGzSwWemN_sA_at_mail.gmail.com>
Date: Mon, 18 Jul 2016 16:17:04 +0300
Message-ID: <CAOVevU5oOnP8TyyPwuHpqY1HVtRe-bJYEwXzjboGzSwWemN_sA_at_mail.gmail.com>
Oops, I'm sorry, I've inserted predicate with rownum in the wrong place. Try like this:
select x.z.o1,x.z.o2 from (select get_ot z from dual where rownum>0)x;
--
Best regards,
Sayan Malakshinov
http://orasql.org
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 18 2016 - 15:17:04 CEST