How can I issue a single command from the command line through sql plus?

by

I’m able to run an SQL query by piping it to SQL*Plus:

@echo select count(*) from table; | sqlplus username/password@database

Give

@echo execute some_procedure | sqlplus username/password@databasename

a try.

More Related Contents:

  1. Determining location of relevant tnsnames.ora file
  2. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  3. Oracle: Import CSV file
  4. When or Why to use a “SET DEFINE OFF” in Oracle Database
  5. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  6. Sql*plus always returns exit code 0?
  7. SQL*Plus how to accept text variable from prompt?
  8. Convert epoch to date in sqlplus / Oracle
  9. oracle SQL plus how to end command in SQL file?
  10. How to View Oracle Stored Procedure using SQLPlus?
  11. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  12. How do I escape a reserved word in Oracle?
  13. How to put more than 1000 values into an Oracle IN clause [duplicate]
  14. ORA-30926: unable to get a stable set of rows in the source tables
  15. Fetch Oracle table type from stored procedure using JDBC
  16. “Safe” TO_NUMBER()
  17. error: ORA-65096: invalid common user or role name in oracle
  18. How to display table data more clearly in oracle sqlplus
  19. Oracle insert if not exists statement
  20. Error : ORA-01704: string literal too long
  21. Oracle client ORA-12541: TNS:no listener [closed]
  22. sqlplus statement from command line
  23. Create an Excel Spreadsheet from a Oracle Database
  24. How do I turn off Oracle password expiration?
  25. ORACLE IIF Statement
  26. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  27. How to increase performance for bulk INSERTs to ODBC linked tables in Access?
  28. Oracle Age calculation from Date of birth and Today
  29. ORA-12705: Cannot access NLS data files or invalid environment
  30. How to see refcursor result/output in Oracle SQL Developer? [duplicate]

Leave a Comment