I am using Oracle 7.3. In my current system, notes for an account are entered in a separate table over as many rows as required using a varchar2(60). Sometimes a user needs to find specific words within these rows and to that end we have a query built in that searches for the users word by using - like ‘%word%’ where word is the word they are searching for. We are discussing changing the varchar2(60) to a long and only using one row per entry. What are the advantages or disadvantages of doing this? Will I still be able to search easily for specific words?
Thanks for any advice
Thanks for any advice