oracle tag

46 questions

2 answers
92 views
0

The SQL I inquired about once on Oracle has not returned the results since the second time.

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...

sql oracle

2 years ago

2 answers
86 views
0

The SQL I inquired about once on Oracle has not returned the results since the second time.

sql oracle

2 years ago

2 answers
112 views
0

DB Connection Entity Frame in ASP.net Core MVC or ODP.net

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 ...

c# .net oracle asp.net-core entity-framework

2 years ago

1 answers
103 views
0

To run Oracle SQLcl in batches

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...

sql oracle

2 years ago

2 answers
72 views
0

Error creating table space

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...

sql oracle

2 years ago

1 answers
111 views
0

ERROR:ORA-12560 Occurs When Attempting to Log In with sqlplus After Installing Oracle Database 19c

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...

windows oracle

2 years ago

1 answers
102 views
0

ORA-00936—The expression is missing.

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...

sql database oracle

2 years ago

1 answers
98 views
0

Error connecting ODBC to Oracle server.

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 ...

excel vba oracle

2 years ago

1 answers
112 views
0

Please tell me how to create a good batch to register with OracleDB based on the text file.

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....

java sql oracle

2 years ago

1 answers
71 views
0

I want Oracle to return a value that belongs to a particular column to a blank character.

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 ...

sql oracle

2 years ago

- 2 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656