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?