Home » Other » Test » Searching a word in the directory (Windows XP)
icon8.gif  Searching a word in the directory [message #390309] Thu, 05 March 2009 18:29 Go to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
Laughing

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
Re: Searching a word in the directory [message #390451 is a reply to message #390309] Fri, 06 March 2009 06:24 Go to previous messageGo to next message
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
Re: Searching a word in the directory [message #390456 is a reply to message #390451] Fri, 06 March 2009 06:56 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
gentlebabu wrote on Fri, 06 March 2009 13:24
Please read the OraFAQ Forum Guide before posting.
http://www.orafaq.com/forum/t/88153/0/

Please stop this.
If people violate the rules, we have moderators to correct them.
Re: Searching a word in the directory [message #390502 is a reply to message #390456] Fri, 06 March 2009 12:05 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Sorry for that.

Sure; Here after I'll take care this..
Babu

[Updated on: Fri, 06 March 2009 12:10]

Report message to a moderator

Previous Topic: test 1
Next Topic: test post performance
Goto Forum:
  


Current Time: Thu Mar 28 15:23:03 CDT 2024