4 Replies Latest reply on May 24, 2016 8:37 AM by 1810188

    Can anyone please help me with the significance of different options while calling sqlplus from Unix Shell.

    1810188

      Hi,

       

      I have a seen shell program where the piece of code was written like

       

      CONC_PROGRAM_ID=`$ORACLE_HOME/bin/../bin/../bin/../bin/../bin/sqlplus -s $FCP_LOGIN <<END

        SET PAGESIZE 0

        SET FEEDBACK OFF

        SET HEAD OFF

        SELECT ltrim(to_char(concurrent_program_id))

        FROM fnd_concurrent_requests fcr

        WHERE fcr.request_id = $REQUEST_ID

        ;

        exit

        END`

       

      Can anyone please tell me the significance of using multiple ../bin and using '-s' in this code,