Help Scripting?

[liezer]

I am writing my first script to execute a SQL/Oracle procedure through a
unix script. Could you tell me how do I display an ERROR MESSAGE when
FAILED_LOGIN_AT TEMPTS is greater than 3....

this is my unix script:


export ORACLE_SID=ohkr m92
export ORAENV_ASK=NO
. oraenv

echo "
select * from dba_profiles
where resource_name in ('PASSWORD_LIFE _TIME','PASSWOR D_GRACE_TIME')
order by profile;
" > t2.sql
echo "@t2.sql" | sqlplus -s username/password


THIS IS THE OUTPUT:

PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT FAILED_LOGIN_AT TEMPTS PASSWORD
3


: HOW CAN MAKE A SCRIPT THAT DISPLAY AN ERROR MESSAGE if
FAILED_LOGIN_AT TEMPTS is greater than 3.. Please talk to me like i'm a moron.. I'm a beginner...... Thanx....