function that verify each firstname, middlname, lastname, class field is blank!

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Function that verify each individual field is blank!

I am newbie in PL/SQL. I got a view that contain firstname, middlename, lastname, and class column fields having data on it. I need a PL/SQL function to check and verify the class column is blank or null values in this view. If so, just display the error: Class field is blank. Your time to code is much appreciated. Please help me with high priority. Thanks in advance.

I posted my questions for a while. Some folks have viewed it, but no solution yet? I got some ideas how to check for validate a column name is blank by counting how many null or blank values of class column fieldname in that view and using IF condition to verify whether or not the class column fieldname is blank or null?, but I am new to PL/SQL syntax? Please help with actual code. Thanks.

Yes, that seems reasonable. Just code it.
For correct syntax, check the documentation found eg. online on http://tahiti.oracle.com/. Have a look into PL/SQL User's Guide and Reference. There are many useful examples there.

Just for completeness, you did not post, what is the function supposed to return (datatype, value). Also requirement for displaying the error is not very common, it shall be the caller task (unless this is just a homework). You may use DBMS_OUTPUT, however be aware that the client (eg. JDBC) may not be able to display it. With this info, you will surely be able to complete the task.

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.