Re: Re: #end in View definition

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_at_bluewin.ch <l.flatz_at_bluewin.ch> 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_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 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
>>
>>
>
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/

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