Re: Re: #end in View definition

Hi Kim,
yes, silly enough there is a view name like that. I always thought you need to put that kind of name into quotes. Regards and thanks
Lothar
----Ursprüngliche Nachricht----
Von : kibeha_at_gmail.com
Datum : 30/08/2018 - 08:49 (GMT)
An : l.flatz_at_bluewin.ch
Cc : oracle-l_at_freelists.org
Betreff : 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 TrivadisOracle ACE Director http://www.kibeha.dk
kibeha_at_kibeha.dk
_at_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