sqlplus statement from command line

by

Just be aware that on Unix/Linux your username/password can be seen by anyone that can run “ps -ef” command if you place it directly on the command line . Could be a big security issue (or turn into a big security issue).

I usually recommend creating a file or using here document so you can protect the username/password from being viewed with “ps -ef” command in Unix/Linux. If the username/password is contained in a script file or sql file you can protect using appropriate user/group read permissions. Then you can keep the user/pass inside the file like this in a shell script: 

sqlplus -s /nolog <<EOF
connect user/pass
select blah;
quit
EOF

More Related Contents:

  1. When do I need to use a semicolon vs a slash in Oracle SQL?
  2. How do I spool to a CSV formatted file using SQLPLUS?
  3. How do I ignore ampersands in a SQL script running from SQL Plus?
  4. Escaping ampersand character in SQL string
  5. How to get Oracle create table statement in SQL*Plus
  6. How to kill a running SELECT statement
  7. How to insert a string which contains an “&”
  8. SQL Query output in VBA is different than in SQL Oracle
  9. I want to find out how much zero come after 1 in SQL
  10. GROUP BY with MAX(DATE) [duplicate]
  11. How to use the ‘as’ keyword to alias a table in Oracle?
  12. Stored Procedure with optional “WHERE” parameters
  13. subquery in FROM must have an alias
  14. SQL multiple columns in IN clause
  15. How can I select from list of values in Oracle
  16. What is the equivalent PostgreSQL syntax to Oracle’s CONNECT BY … START WITH?
  17. Selecting the second row of a table using rownum
  18. Split String by delimiter position using oracle SQL
  19. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  20. ORA 00904 Error:Invalid Identifier
  21. Update with Join query in Oracle
  22. What does the colon sign “:” do in a SQL query?
  23. Autoincrement in oracle to already created table
  24. SQL not displaying null values on a not equals query?
  25. What can cause an Oracle ROWID to change?
  26. How to add ‘ON DELETE CASCADE’ in ALTER TABLE statement
  27. Oracle query to match all values in the list among all rows in table
  28. Inserting into Oracle and retrieving the generated sequence ID
  29. How can I solve ORA-00911: invalid character error?
  30. Exporting a CLOB to a text file using Oracle SQL Developer

Leave a Comment