Any idea about this procedure?
Hi people,
I have an undefined number of rows (with two columns: name and surname) in a table.
I want to do the following:
Get the first two strings of each name and create a text file with the contents of all the names that start with these two strings.
For instance, if I have:
NAME SURNAME
Joe Smith
Mike Johnson
John Street
Jonathan Roberts
It should create two text files, one called jo.txt with Joe,John and Jonathan inside, and another text file called mi.txt with Mike inside.
Any clue on how to do this? Any help would be really appreciated.
Thanks,
Borja
Subject
Views
Written By
Posted
Any idea about this procedure?
1622
July 02, 2007 03:00AM
1028
July 02, 2007 08:24AM
939
July 02, 2007 09:28AM
973
July 02, 2007 09:50AM
814
July 02, 2007 01:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.