46 questions
In the Oracle database, the results will be returned in a few seconds, but if you contact the exact same SQL immediately afterwards, the results will not be returned immediately.I'm sorry that I can't...
In the Oracle database, the results will be returned in a few seconds, but if you contact the exact same SQL immediately afterwards, the results will not be returned immediately.I'm sorry that I can't...
We are creating a web API using the ASP.net Core MVC model.So I would like to connect to the database and issue SQL and execute procedures.Until now, I have used ODP.net to attach a connection to the ...
I wrote the following batch file to output table data to CSV file using Oracle SQLcl in Windows environment, but it doesn't work except to access the database.Please teach me how to write correctly.@e...
Create Table Space for TBS_USER_IDX create tablespace TBS_USER_IDX datafile'C:\app\oracle\oradata\orcl\TBS_USER_IDX.dbf'size 128m autoextend on next 16m maxsize 1024m; The error is ORA-01119: Err...
When I installed Oracle Database 19c in a Windows environment, launched a command prompt, and tried to log in with SQL*Plus through a SYS or SYSTEM account, I received the following error:ERROR:ORA-12...
SELECT syainNo , name ,date ,place , time FROM YOTEI_DATA_TBL;I selected what I created in oracle db. ORA-00936—The expression is missing.00936.00000 - missing expression*Cause: *Action:Row 16 Co...
This is my first question.Error code 3076 アプリケーションApplication Definition or Object Definition Error 」 when connecting to Oracle server using EXCELVBA.I tried several ways to resolve the error, but it ...
Load text file (id, value) → Perth → Insert to DB (Oracle) (In case of duplicate id, add value in Update) I would like to create a batch of processing, so please tell me how to process it efficiently....
This is a rudimentary question, but what syntax can you think of if you want to get the following results from SQL?No Name Address Tel 1 test + 812 hoge+813 hoge+81Normally, a value is entered in the ...
« | - 2 - | » |
© 2025 OneMinuteCode. All rights reserved.