The hashtag, just like the dollar sign is treated as a regular character in
Oracle object names.
On Thu, Aug 30, 2018 at 2:03 PM, l.flatz@xxxxxxxxxx <l.flatz@xxxxxxxxxx>
wrote:
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@xxxxxxxxx
Datum : 30/08/2018 - 08:49 (GMT)
An : l.flatz@xxxxxxxxxx
Cc : oracle-l@xxxxxxxxxxxxx
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 Trivadis
Oracle ACE Director
http://www.kibeha.dk
kibeha@xxxxxxxxx
@kibeha <http://twitter.com/kibeha>
On Thu, Aug 30, 2018 at 8:43 AM l.flatz@xxxxxxxxxx <l.flatz@xxxxxxxxxx>
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