I'm asking this question because I find this DBMS simply fantastic, so I'd like to use it with another database (not because I want to, but because most of the databases I have are in Mysql).
Is there any adapter, plugin, or any feature that...
Talk to people, good morning, I have a legacy code and I'm having the following difficulty:
When I try to check a word that has a single quotation mark I get this error ORA-01756
Ex: raphael me'lo
Now when I try:
Ex: raphae...
I would like to know if it is possible to call a Java class within the Oracle database.
I have already installed the JVM inside the Oracle server, but I can not compile the Java class.
Does anyone know of any way I can do this?
Inside the example below:
Begin
For r in (select * from tabela)
Loop
..... ;
End loop;
End;
Is there any direct way to know within the loop how many records the cursor has?
Recently I migrated (six months ago) to Oracle 11 and now when using the command
sqlplus system@INTANCIA I got the message below:
ORA-28002: the password will expire within 7 days
NOTE: I can still log in and it only warns that the...
I've been developing C # for a while now, so I'm still learning ... How do I extract the result data from the query done in the database?
public static DataTable ConsultaCidade()
{
DataTable pDados = ExecutaSql.ConsultaBanco("SELECT * FROM...
I have the following table in Oracle and I want to fill value that is null in the Activity column with the value of the previous row. How to do it using Oracle?
I have the following querys using Linq to Object:
_Context.GerenciaTransacao.Where(x => x.Placa == "LUN1320").ToList();
In this query, results return in 100ms.
and
string placa = "LUN1320";
_Context.GerenciaTransacao.Where(x =>...