I am in the phase of implementing the compliance for oracle database and need some help. I want to execute the SQL query on the remote database and store the output of the query in the extended objects. I tried to do it with NSH with single command
nexec -i HOST_NAME //PATH/sqlplus.exe username/password@SID
but it only allows me to login to databse and after this I want to execute the sql query in a single command and store the output in the Extended objects.
Could you please help me on this ?