1

Topic: To select words from a line, containing the certain character

2

Re: To select words from a line, containing the certain character

Division into words absolutely not very relational operation. It is impossible to multiply one record on an indefinite record count.
Possible decisions:
- The stored procedure using the temporary table;
- The user function plus the reference (synthetic) table of natural numbers;
- Performance of demanded operation on the client.

3

Re: To select words from a line, containing the certain character

Akina;
Thanks for the answer. Whether it means, what it is better to fulfill generally the given operations not by means of SQL?

4

Re: To select words from a line, containing the certain character

Whether

slawdows wrote:

it Means, what it is better to fulfill generally the given operations not by means of SQL?

Depends that it is required to make with data retrieveds. If to show on the screen - is faster yes. If to save in the new table - is not present more likely.

5

Re: To select words from a line, containing the certain character

Akina;
Yes, the data is necessary only for the report, no more.

6

Re: To select words from a line, containing the certain character

In that case means Java to a client part will be given by more convenient operators for performance of demanded function .