Home » SQL & PL/SQL » Client Tools » Toad (How to avoid view definition whiel creating view in TOAD)
Toad [message #275629] Mon, 22 October 2007 02:26 Go to next message
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
Littlefoot
Messages: 20897
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.
Previous Topic: SQL*Plus help
Next Topic: Invalid Pointer Operation
Goto Forum:
  


Current Time: Wed Dec 07 05:12:47 CST 2016

Total time taken to generate the page: 0.19241 seconds