Re: #end in View definition

Hi, Lothar

Normally that would just be part of the object name. I'll guess that there exists a table, view or alias named tablename#end. Perhaps try select from all_objects where object_name = 'TABLENAME#END' ?

Cheerio
/Kim

Regards

Kim Berg Hansen
Senior Consultant at Trivadis
Oracle ACE Director

http://www.kibeha.dk
kibeha_at_kibeha.dk
_at_kibeha <http://twitter.com/kibeha>

On Thu, Aug 30, 2018 at 8:43 AM l.flatz_at_bluewin.ch <l.flatz_at_bluewin.ch> wrote:

> Hi,
>
> I found this as subquery in a view defintion: "(select col1, col2 from
> tablename#end)".
> It create no syntax error and seems to be ignored.
> There not something like a #begin.
>
> Does anybody know what that means?
>
> Regards
>
> Lothar
>
>

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