THIS MY SCRIPT:

export ORACLE_SID=ohkrm92
export ORAENV_ASK=NO
. oraenv

echo "
select * from dba_profiles
where resource_name in ('PASSWORD_LIFE_TIME','PASSWORD_GRACE_TIME')
order by profile;
" > t2.sql
echo "@t2.sql" | sqlplus -s erwin/nm21784


HERE IS THE OUTPUT:

PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD
3


:My boss told me that the script should DISPLAY ERROR if FAILED_LOGIN_ATTEMPTS is greater than 3... HOW should I do THis?
PLease talk to me like im moron, im just a beginner... or please give a
sample code to do this.. thanx a lot...

ps: this is a follow question: thanv to those who answer,
specially dhruva...

i no longer have an oracle box to test this with but you can try:

check which column is the "DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD"
example that column is 4th column hence....

export ORACLE_SID=ohkrm92
export ORAENV_ASK=NO
. oraenv

echo "
select * from dba_profiles
where resource_name in ('PASSWORD_LIFE_TIME','PASSWORD_GRACE_TIME')
order by profile;
" > t2.sql
echo "@t2.sql" | sqlplus -s erwin/nm21784 | awk ' { if ($4>3) print $0 }'  

thnx inquirer...


i have tried what you have though i get this error

syntax error The source line is 1.
The error context is
{ if >>> { <<<
awk: The statement cannot be correctly parsed.
The source line is 1.
awk: Quitting
The source line is 1.


IF you have still Suggestions that i should try pls inform me...

thanks a lot....

please note that the curly bracket {} is different with parenthesis ()

thanks

inquirer thnx for the help..

i have checked that, though this time
the script has no error, it also has no
output.. Their is no output on the screen...

What does this mean?
Is there any thing i can do?

thnx for the help, i really appreciate it...

make sure that the failed login attempts are in the 4th column otherwise change the value of the $4. if the values for the failed login attempts are located elsewhere change it.

also to make sure that the code is correct you can reverse the condition from $4>3 into $4<3 just to see if there are any values received.