view with constraint
2 posters
Unix C++ :: UNIX CPP :: RDBMS & ORACLE
Page 1 of 1
view with constraint
by jeeva Wed Mar 24, 2010 1:53 pm
how to create a view with a READONLY constraint!!!
jeeva- Posts : 50
Points : 93
Join date : 2010-03-04
Re: view with constraint
by mightyganesh Wed Mar 24, 2010 2:21 pm
the syntax is
CREATE VIEW <viewname> AS <sub query> WITH READ ONLY ;
WITH READ ONLY clause at the end add the constraint!
CREATE VIEW <viewname> AS <sub query> WITH READ ONLY ;
WITH READ ONLY clause at the end add the constraint!
mightyganesh- Posts : 53
Points : 92
Join date : 2010-02-26
Age : 35 -
Unix C++ :: UNIX CPP :: RDBMS & ORACLE
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum|
|
|