Toad [message #275629] |
Mon, 22 October 2007 02:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sundarfaq
Messages: 235 Registered: October 2007 Location: Chennai
|
Senior Member |
|
|
Hi all,
In toad,i create a view like
create or replace view sample_view
as
select employee_id,department_id,last_name
from employees;
view created:
after that i check in view tab in schema browser.I select the scripts and it shows with view definition
create or replace view sample_view
(select employee_id,department_id,last_name)
as
select employee_id,department_id,last_name
from employees;
How to avoid the view definition In toad
Thank u
|
|
|
Re: Toad [message #275648 is a reply to message #275629] |
Mon, 22 October 2007 03:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
As far as I can tell, you can't do that.
Why would you want to do it, anyway? The one who uses TOAD sees tables as well, so - what are you trying to hide?
What you might do is create a SYNONYM to a view which would conceal creation script. Of course, user who sees a synonym would have to be different from the one who created a view.
|
|
|