Shell Programming and Scripting

this is my script....


SQL> select * from dba_profiles
2 where resource_name in ('FAILED_LOGIN_ATTEMPTS','PASSWORD_LOCK_TIME')
3 order by profile;

and this is the output...


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

DEFAULT PASSWORD_LOCK_TIME PASSWORD
5

MGR_ACCOUNT FAILED_LOGIN_ATTEMPTS PASSWORD
DEFAULT


PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
MGR_ACCOUNT PASSWORD_LOCK_TIME PASSWORD
DEFAULT


MY QUESTION is HOW CAN I DO A script that would Check IF FAILED_LOGIN_ATTEMPTS is equal to 3... PLEASE HELP ME...

please talk me like im a moron.. i'm not familiar with this...
thnx in advance....

i think you should do the check inside your SQL statement instead..like where FAILED_LOGIN_ATTEMPTS = 3 or something...just a suggestion..

Can you just tell us what exactly you want to do.What i understood is you want to check for "profile" if "resource_name" is 'FAILED_LOGIN_ATTEMPTS'
and "limit" is 3.
like: is that what you want?

Code:

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

then

Code:

select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS' and limit='3'
order by profile