Tag Info

New answers tagged

0

I was able to resolve this issue by copying the contents of the SQLPLUS folder into the Instant_Client_12_1 folder. Then SQLPlus was able to launch.


4

You simply don't use begin in sqlplus if you're just going to issue a series of SQL queries. You're in a transaction already. You can't really be outside of a transaction anyway. A few things to be careful with though: sqlplus does have an autocommit setting. It's off by default in modern versions, but just to make sure: SQL> show autocommit ...


0

col dt1 noprint new_value dt1 SELECT TO_CHAR (SYSDATE, 'yyyymmdd') || '.log' dt1 FROM DUAL; spool C:\log_file_&dt1 sql commands spool off


0

Your sqlplus line looks correct, verify the following: You can connect as sysdba on the database server itself. You can connect as the user you are trying to on the database server itself. You can ping the database server from the computer you are trying to connect from. You can tnsping the listener from the computer you are trying to connect from. If ...



Top 50 recent answers are included