Home » SQL & PL/SQL » SQL & PL/SQL » find
find [message #19506] Fri, 22 March 2002 05:06 Go to next message
Richard
Messages: 44
Registered: May 2000
Member
I'm trying to find a specific character number in a file: i.e. if a file has a total of 1,400,000 chars (including spaces and any other symbols), how can I quickly go to character number 142,633?

I do not mean that in the file is a reference of '142,633'

Are there any simple search strings I can use (unix or sql)?

Thanks
Richard Minns
Re: find [message #19509 is a reply to message #19506] Fri, 22 March 2002 07:18 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
I dont understand how this is related to Oracle.
As you know, the most common and known editor to the UNIX world 'vi' comes with lots of option and I am sure if its something to do with file search..vi def'tly should have a command to jump to particular line or char position

if it is in database as a column..
obvisouly you can do substr(<<columnname>>,<<characterposition>>,1 ) wud give u what u need

ex: select substr(history_desc,142633,1) from history;
Previous Topic: Equivalent to SQL profiler
Next Topic: process
Goto Forum:
  


Current Time: Fri Mar 29 04:02:38 CDT 2024