@sqldaily : You can insert rows into updatable views... ...but it's possible to add data contradicting the WHERE clause So the values seem to vanish! Stop this by adding CREATE VIEW ... AS SELECT ... WHERE ... WITH CHECK OPTION And you can only insert rows that satisfy the WHERE clause • TwiCopy

SQL Daily

@sqldaily

+ Follow

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily

@sqldaily

a month ago

You can insert rows into updatable views... ...but it's possible to add data contradicting the WHERE clause So the values seem to vanish! Stop this by adding CREATE VIEW ... AS SELECT ... WHERE ... WITH CHECK OPTION And you can only insert rows that satisfy the WHERE clause

thumb_up_off_alt41

chat_bubble_outline0

repeat10

shareShare