Shell script on which I am working is having one SQL query whichfetches multiple column and multiple rows from DB:get_names() {    $ORACLE_HOME/bin/sqlplus -s usr/pwd <<EOF        SELECT id,name,age FROM table;        Exit;EOF}Then, to read this result we are piping the function's output:get_names | while read sid p_name p_age ; do ... done.Now, because of |, a subshell is getting created, which I need to avoid.Is there any alternative present for this issue?We want to break that pipe statement to avoid child process of it.
Alternative to process pipeline
pipe;subshell