get view name (this.name?) [message #219590] |
Thu, 15 February 2007 01:30  |
bibber
Messages: 38 Registered: August 2006
|
Member |
|
|
Hi,
I have a view including select statement 1. I want to re-write it to avoid hard-coded elements. So, can I re-use the name of the view in my select statement, like statement 2.
1:
select name from table
where view_name = 'KST_V_C_BOVENKTALUD_RW'
2:
select name from table
where view_name = this.name
[Updated on: Thu, 15 February 2007 01:31] Report message to a moderator
|
|
|
Re: get view name (this.name?) [message #219591 is a reply to message #219590] |
Thu, 15 February 2007 01:33  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
No, unfortunately objects in Oracle have no knowledge of their own characteristics.
In your case however, it would not make that big a difference, since you have to hardcode the name of the view in the definition anyway.. (create view <viewname>...)
[Updated on: Thu, 15 February 2007 01:34] Report message to a moderator
|
|
|