Shell Programming and Scripting

Hi all,
I want to list all the files in a directory but not present in the subdirectories.
I want the name of each file with its full pathname.

ls /opt/cems/log/cemsdbg/db/*
/opt/cems/log/cemsdbg/db/securitydb_backup_2009_01_12_06:00:54.log
/opt/cems/log/cemsdbg/db/standby_monitor.sql
/opt/cems/log/cemsdbg/db/standby_monitor.sql.log
/opt/cems/log/cemsdbg/db/standby_run_fal.sql
/opt/cems/log/cemsdbg/db/standby_run_fal.sql.log

/opt/cems/log/cemsdbg/db/oracletool:
analyze_CEMSDB_wcars1gx_2009_01_17.tar.gz
analyze_CEMSDB_wcars1gx_2009_01_18_00:00:05.log
analyze_CEMSDB_wcars1gx_2009_01_18_00:15:02.log


I dont want the files under /opt/cems/log/cemsdbg/db/oracletool to get listed.
Please suggest a command for the same
I just want the files and not directories or files under subdirectories.

Thanks,
Dipashre

I have found a command:-
find . -type f

but it still lists the files in subdirectories

Can some one please address this issue??

use the below command

Code:

find /opt/cems/log/cemsdbg/db -type f -print | egrep -v -e 'oracletool/'

try:

Code:

cd /opt/cems/log/cemsdbg/db/ 
find . ! -name "." -type d -prune -o -type f -print

This works but I dont get the full path name.

bsm79% find . ! -name "." -type d -prune -o -type f -print
./cemsdb_oracle_monitor_2008_12_13_06:00:10.log
./db_backup_bsm79_2008_12_13_18:00:05.log
./db_backup_bsm79_2008_12_14_06:00:06.log
./cemsdb_oracle_monitor_2008_12_14_06:00:13.log
./db_backup_bsm79_2008_12_14_18:00:08.log
./db_backup_bsm79_2008_12_15_06:00:07.log
./cemsdb_oracle_monitor_2008_12_15_06:00:13.log
./db_backup_bsm79_2008_12_15_18:00:06.log
./db_backup_bsm79_2008_12_16_06:00:06.log
./cemsdb_oracle_monitor_2008_12_16_06:00:14.log
./db_backup_bsm79_2008_12_16_18:00:06.log
./cemsdb_oracle_listener_2008_12_16_21:16:38.log

I need the full path too along with the filename only.

I got it thanks a lot!!!!!!!!!
find /opt/cems/log/cemsdbg/db/* ! -name "." -type d -prune -o -type f -print