Hi,
Just wants to know, Is we have something similar in oracle also ?
We can create view in MS SQL Server with following options
SCHEMABINDING (It prevent object to be modified in a way that would affect the view definition)
ENCRYPTION (Encrypts the entries in sys.syscomments that contain the text of the CREATE VIEW statement.
Using WITH ENCRYPTION prevents the view from being published as part of SQL Server replication.)
What are it's equivalent options in Oracle...
Go to the complete details ...