Home » SQL & PL/SQL » SQL & PL/SQL » get view name (this.name?)
get view name (this.name?) [message #219590] Thu, 15 February 2007 01:30 Go to next message
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 Go to previous message
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

Previous Topic: Migration from MSSQL SERVER 2000 to ORACLE 10G
Next Topic: find related table
Goto Forum:
  


Current Time: Mon Feb 10 11:44:18 CST 2025