OraFAQ Forum: Test » Searching a word in the directory

Home » Other » Test » Searching a word in the directory (Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Searching a word in the directory [message #390309]

Thu, 05 March 2009 18:29

srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam

Junior Member

Requirement:
Searching a word in the directory.
I want the stored procedure in Oracle such that directory and word are passed as input parameters.

Assume:

.txt and .xml files are available in the folder.

Expected output in text file:

1. which filename that word exits.
2. if the word is repeating so many times, want that line numbers also.

Required output format:

file2.txt 12
file2.txt 16
file5.xml 8

Report message to a moderator

Re: Searching a word in the directory [message #390451 is a reply to message #390309]

Fri, 06 March 2009 06:24

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Please read the OraFAQ Forum Guide before posting.
http://www.orafaq.com/forum/t/88153/0/

>>2. if the word is repeating so many times, want that line numbers also.

You may need to write function

Report message to a moderator