Search Results

Great!!!

Could you please explain this part 'grep -He "^[AUIR]" "$@" and need of this _ {} +

I need to find in file where the record starts with "A,U,I,R" and their file name

Record will look like below

A|1|138||XXXX|XX|XX
U|2|XX|XX|XX|XX
R|3|EK|XX|XX|XX
D|4|TY|CC|CC|CC

find...

#!/bin/ksh
#*****************ORACLE CALL FUNCTION****************
function run_oracle {
sqlplus -s <<%%
${user}/${passwd}
set serveroutput off
set heading off
set feedback off
set verify off...

thank you for your comments. I have got what i expected.

Requirement 1) I need to execute 15 SQL queries in oracle through linux script. All these query results needs to be stored in array variables.

Requirement 2) And these 15 queries needs to be...

Could you please explain me how this command works??

Thanks is advance

Also all the queries are writted in Parameter file. I need to read the queries from parameter one by one and pass to the Oracle.

I have n number of SQL queries needs to executed in Shell. Result of this query need to assign in a variable. Once all the queries are executed script needs to exit.

Sample Query:

SQL 1:...