oracle tag

46 questions


1 answers
497 views
0
How to load ini files and connect to Oracle in VisualStudio 2008

Nice to meet you, as the title says We are trying to create a function that reads information in the ini file, connects to DB, and deletes it.I've looked into various things, but I've only used Nuget,...

1 years ago

1 answers
374 views
0
What are the benefits of using DBCA-generated scripts to create Oracle databases?

Is it more efficient to generate and create scripts when using DBCA to create databases?I heard that the script contains the values that you set in the GUI for now, and that it is convenient to recrea...

2 years ago

1 answers
148 views
0
I would like to put the following SQL statement in the where clause in Oracle and introduce it into the case statement to branch the conditions.

I would like oracle to include the following SQL statements in the where clause and introduce them into the case statement to branch the conditions.Prerequisites include columns similar to the followi...

2 years ago

1 answers
140 views
0
Rewrite from oracle's external binding expression (+) to left join is not successful

The format of the sql statement currently used in Oracle has been changed so that it can be used in sqlserver.Therefore, I am trying to rewrite the following sql statements.The select result is not th...

2 years ago

1 answers
97 views
0
partial match search for integer fields

I would like to write a SELECT statement that considers an integer field (the range of values is 0 to 99) to be a string and searches for a partial match.For example, if you specify 7, 17 or 73 will b...


3 answers
164 views
0
How do I absorb the dll version difference between development and server environments?

The environment is divided into several dlls, and I would like to replace only the dlls that were fixed, but when I deployed the dlls that I created in the server environment, the following error occu...


2 answers
75 views
0
I want SQLPLUS to return a negative value when running a SQL file.

I would like to return a negative value when running SQL PLUS.As a result of the execution, it would be good to see the following:>sqlplus-Luser/pass@[email protected]>echo$?>-1Simply put in the D...

2 years ago

1 answers
142 views
0
Obtaining Oracle Statistics from the Symfony Command Console

I was using the URL below to create the command, but I didn't know how to get Oracle statistics using Doctrine.http://docs.symfony.gr.jp/symfony2/cookbook/console.htmlIf you run it with the following ...

2 years ago

2 answers
109 views
0
I want SQLPLUS to return a negative value when running a SQL file.

I would like to return a negative value when running SQL PLUS.As a result of the execution, it would be good to see the following:>sqlplus-Luser/pass@[email protected]>echo$?>-1Simply put in the D...

2 years ago

1 answers
85 views
0
Obtaining Oracle Statistics from the Symfony Command Console

I was using the URL below to create the command, but I didn't know how to get Oracle statistics using Doctrine.http://docs.symfony.gr.jp/symfony2/cookbook/console.htmlIf you run it with the following ...

2 years ago
- 1 - »

© 2024 OneMinuteCode. All rights reserved.