Re: function returning object type and print the attributes

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 18 Jul 2016 17:05:40 +0300
Message-ID: <CAOVevU43JCvgS0MJL0UOJcDNvoPJ6kNgKMag7Uqqv=p-Ry7W5Q_at_mail.gmail.com>

Just ignore SQL*Plus behaviour with simple SQL, test such queries within p/sql blocks.
"select x.z.o1,x.z.o2 from (select get_ot z from dual *where rownum>0*)x" will work fine with Java and any other tools.

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 18 2016 - 16:05:40 CEST

This message: [ Message body ]
Next message: Ls Cheng: "Re: function returning object type and print the attributes"
Previous message: Sayan Malakshinov: "Re: function returning object type and print the attributes"
Maybe in reply to: Ls Cheng: "function returning object type and print the attributes"
Next in thread: Ls Cheng: "Re: function returning object type and print the attributes"
Reply: Ls Cheng: "Re: function returning object type and print the attributes"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message