#end in View definition

[l***@bluewin.ch]

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

[Kim Berg Hansen]

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.dk
@kibeha <http://twitter.com/kibeha>

Post by l***@bluewin.ch
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

[l***@bluewin.ch]

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 : ***@gmail.com
Datum : 30/08/2018 - 08:49 (GMT)
An : ***@bluewin.ch
Cc : oracle-***@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.dk
@kibeha
On Thu, Aug 30, 2018 at 8:43 AM ***@bluewin.ch <***@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

[Stefan Knecht]

The hashtag, just like the dollar sign is treated as a regular character in
Oracle object names.

Post by l***@bluewin.ch
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----
Datum : 30/08/2018 - 08:49 (GMT)
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 <http://twitter.com/kibeha>

Post by l***@bluewin.ch
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