sqlplus

How can I write the result of executing an SQL script to the log?

I use it to run on a remote machine .bat, which calls SQL * Plus and executes the script. In the log, only the result of the ... em.log I want to see not only the execution notification, but also the result of executing the request select * from table;.

Import a file to a table using SQL * Plus

There is a file of the form: наименование_1 наименование_2 наименование_3 наименование_4 ... There is a table with one field NAME VARCHAR2. You need to use sqlplus to load this file into the table. How do I do this?

How to pass a password containing a dollar sign to sqlldr or sqlplus $

For example, we call sqlldr: sqlldr SYSTEM/PA$$WORD control=loader.ctl > output.txt And we get in the response: SQL*Load ... ou just call sqlldr control=loader.ctl and then enter username and password from the keyboard, then everything is successful.

ORA-12560: TNS: protocol adapter error when connecting to the database. How to fix it?

There is an Oracle DATABASE on a virtual machine. Access from the machine itself via sqlplus works. I can't connect to the ne ... s.domain_name runs without errors. I connect to other databases on other machines on the network. Where to see how to fix it?

How to create directories and add them to a file when output to spool?

I'm writing a script for sqlplus. I'm trying to output the results to a file. I do it like this: spool D:\folder\scripts.lo ... D:\folder\scripts.log append Question 2: You can somehow create a file, and if it is already created, then add more to it?