+ 2

why is replace used with veiws

replace in veiws

14th Jul 2016, 8:19 PM
manish rawat
manish rawat - avatar
3 Respuestas
+ 3
REPLACE is used to re-create the view if it already exists in your database schema. You can use this to modify the definition of the view existing with the same name without dropping, re-creating, and regranting object privileges previously granted on it.
16th Jul 2016, 7:40 PM
Devi Das
Devi Das - avatar
0
can you please explain the question
16th Jul 2016, 7:06 AM
Tijo Joseph
Tijo Joseph - avatar
0
replace is there as view cannot be alter like you can alter a table. And rest is explained by Devi das.
23rd Jul 2016, 4:48 PM
Saurabh Joshi
Saurabh Joshi - avatar