If I assign a NVL constraint to a nullable column will it display an error or it will retrieve the records?
So to answer your question.
"So will the command retrieve it normally or give an error?"
Yes it will work and won't return an error.

@update
You forgot your ; after the query.