Wednesday, November 11, 2009

Significance of key phrases

What do you need to do if you what some constraints applied at view level?

Im pretty sure you know column level constraints (SELECT clause J).

But when you give row level constraints in WHERE clause, do make sure you give the following key phrase:

“WITH CHECK OPTION”

Otherwise, your where clause will be ignored.

On the same note, while creating volatile tables, the key phrase for you to hold the data in until end of session is:

WITH DATA and ON COMMIT PRESERVE ROWS

Refraining from doing so, will make the data you just inserted disappear!!

No comments:

Post a Comment