Questions tagged as 'oracle'

Tagged questions
0
answers

Oracle - Lock that prevents SELECT

Lock that prevents SELECT The situation is as follows: An ERP application (Totvs) with several tables All these tables use as primary key a default field R_E_C_N_O_ The application (I believe) creates a new record common select max (R_E...
asked by 13.03.2018 / 21:16
1
answer

Batch with parameters in SqlPlus

Hello, I need to create a batch file that drops the user from the database, recreate and import the database with an existing backup. I have already created a routine that gives a drop in user and recreates with the permissions defined, th...
asked by 13.03.2018 / 21:51
0
answers

Execute PLSQL anonymous block with Hibernate

I need to run multiple function in Oracle with Hibernate FUNCTION ISNUMBER(value IN VARCHAR) RETURN NUMBER DETERMINISTIC AS RC NUMBER; BEGIN IF (value IS NULL) THEN RETURN 0; END IF; RC := TO_NUMBER(value); RETURN 1...
asked by 12.03.2018 / 19:12
0
answers

intersection of polygons and union of polygons

Good afternoon, I have points on a map I want to generate a voronoi diagram on the points, and I want the limit of this voronoi diagram to be a polygon (the city), and once these polygons created would like to unite some between each other, I ne...
asked by 14.03.2018 / 18:45
0
answers

Statistical Functions in MySQL (eg Oracle)

Is it possible to use statistical functions in MySQL, such as those already in Oracle? Examples:    OVER / PARTITION BY    CORR    DENSE_VAR    FIRST    LAG    LAST    RANK    DENSE_RANK    I know they do not exist natively, but c...
asked by 08.03.2018 / 20:51
1
answer

Retrieve the last value found inside a string

I need to take an average of payment terms in the database and I came across the situation where the condition column is a string and it can receive parcel values separated by slash. I need to get the last value after the last bar, percent sign...
asked by 20.02.2018 / 19:35
0
answers

INSERT with query in string Entity Framework

This is trying to give an insert in the table using a string containing a sql code ... when I use the DELETE command it runs perfectly now when I squeeze the insert no ... the insert runs straight into the database. Follow the code: public voi...
asked by 16.02.2018 / 21:08
0
answers

Error creating a PROCEDURE

I am creating a procedure to be able to insert data into a table in the database, but it is giving an error that I can not identify: Command: begin INCLUIR_CLIENTE(1, 'SUPERMERCADO XYZ', '12345', NULL, 150000); end; Message submitted:...
asked by 09.02.2018 / 18:01
0
answers

How to do a query using Oracle.Managed.DataAccess in C #

I have the following method in C # public static ProdutividadeBean GetProdutividade() { Console.WriteLine(CairuUtils.UserContext.getCodUsuario()); String strConnection = "Data Source=(DESCRIPTION=(ADDRESS=(PROTO...
asked by 14.02.2018 / 21:35
1
answer

Error generating PLSQL file in oracle!

Code CREATE OR REPLACE PROCEDURE CRIARARQUIVOTXT AS Arquivo_saida UTL_File.File_Type; Dir_Arq VARCHAR2(60); Cursor cur_arq is Select f.NOME from tfuncionario f; BEGIN -- Diretorio do Arquivo Dir_Arq := 'C:\Users\xxxxxx\Documents...
asked by 09.02.2018 / 00:24