Questions tagged as 'oracle'

1
answer

SQL Converter minutes to hour: minute: seconds

How to convert a value in minutes in oracle to the format hour: minutes: seconds?     
asked by 29.02.2016 / 13:40
1
answer

Sql Server Management Studio can handle any database?

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...
asked by 04.03.2016 / 15:33
1
answer

Query works in database but not via code

using (var cnx = new OleDbConnection(new AdministradorDAO().conexao)) { var sql = @"insert into usuarios(matricula, nome, senha, nivel, maleta, email) values (@matricula, @nome, @senha, @nivel,...
asked by 16.09.2014 / 22:42
1
answer

"ORA-01756: quoted string not properly terminated"

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...
asked by 02.01.2019 / 13:09
1
answer

Call Java class inside Oracle

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?     
asked by 13.08.2014 / 16:44
2
answers

PLSQL know the amount of records inside a "for cursor"

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?     
asked by 23.08.2014 / 13:13
1
answer

Oracle 11 is expiring passwords. How do I reset this?

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...
asked by 11.03.2014 / 17:56
4
answers

How to extract data from a SQL query in C #

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...
asked by 08.12.2017 / 19:09
1
answer

Select the previous line if it is null

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?     
asked by 24.05.2017 / 16:38
1
answer

Query using Entityframework Why performance variation?

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 =>...
asked by 14.02.2017 / 15:59