UNIX for Beginners Questions & Answers

It gets printed to standard output, which by default is your terminal, but pipes | and redirects > send it somewhere else.

Code:

$ echo "something"

something

$

Pipes grab the output of the command before them and send them into the standard input of the command after them. Standard input, by default, is the terminal too.

"default" is just "a copy of whatever file descriptors your terminal happens to have open", incidentally.

So you're typing "exit" into sqlplus, then scanning whatever it prints back out for "Connected To:" to see if it worked.

Thank you so much. I wish there is an online tutorial for running SQL scripts from Bash. I found some but the explanation is not clear or detailed.

Let me know if you know any.

Regards,

All your questions are generic Bourne shell questions so far, the command reads text in and prints text out, no special SQL knowledge required. So you're just looking for the wrong kind of tutorial really.

The redirect to /dev/null for standard output is not needed if you use the -q flag on grep because that means no output anyway.

Have you considered a database that is up & running but locked up due to the redo area being full? You might not get control back?

Additionally, you will be able to see (albeit briefly) the credentials by running a simple ps command at the right time on another session. You might be better with:-

Code:

sqlplus $userid@$target_db <<-EOSQL
$password
EOSQL

Do you not have a tnsnames.ora file to describe how to get to your database instances? It can be put in a shared area and makes adjusting it for multiple users far easier. It might be worth a read.



Robin