Shell Programming and Scripting

My problem is this....

Platform=Sun Solaris UNIX / Oracle 10g

1) I'm trying to SSH from my local system A to remote system B

2) Once connected, I need to sudo to ID that has the ability to connect to the Oracle database

3) Then run a script that connects via sqlplus and pulls data back to local machine, in directory of choice. Can this be done? Thanks in advance..

Here is the contents of my query/script i will be running..

select substr(decryptstr(cc_number,'&enc_key'),1,16), ';',
a.ACCOUNT_STATUS, ';',
substr(decryptstr(b.first_name,'&enc_key'),1,20), ';',
substr(decryptstr(b.last_name,'&enc_key'), 1,20), ';',
a.SYS_CREATION_DATE
from registration_info r, accounts a, addresses b
where r.cy_account_id=a.cy_account_id
and r.fi_id=a.fi_id
and r.CY_USER_ID = a.CY_USER_ID
and r.CY_USER_ID = b.CY_USER_ID
and r.FI_ID = b.FI_ID
and a.ADDRESS_ID = b.ADDRESS_ID
and r.fi_id = '12345.test';

Oracle doesn't require an su. You might need to add the oracle path to your $PATH, but you'd connect as scott/tiger@SID. Otherwise, what's the question?

---------- Post updated at 13:08 ---------- Previous update was at 13:02 ----------

Better stated: yes. Your SSH session can use a heredoc to stream your resultset onto a redirect of your choosing. The SQL call can be local to your SSH call, or be stored in your remote machine, and echo to screen. Only downside here is that you're heavy on the network this way. Better to spool output to a file on the remote machine, and then transfer that file back locally.

---------- Post updated at 13:08 ---------- Previous update was at 13:08 ----------

Better stated: yes. Your SSH session can use a heredoc to stream your resultset onto a redirect of your choosing. The SQL call can be local to your SSH call, or be stored in your remote machine, and echo to screen. Only downside here is that you're heavy on the network this way. Better to spool output to a file on the remote machine, and then transfer that file back locally.

yes the scenario stated is possible