Questions tagged as 'oracle'

Tagged questions
4
answers

Delete thousands of records from a table

I have a table, for example, pessoa , and I would like to all people over 40 , with the script below I do this: > DELETE FROM pessoa WHERE pessoa.idade > 40; The problem that there is more than 2 million records in the table ,...
asked by 14.12.2016 / 19:42
2
answers

What is and what is the utility of the DUAL table for Oracle?

I came across this scenario while modifying a report in the system: One of querys is returning this table as DUAL : select * from dual But in the system there is no DUAL table, and the answer they gave me was that it was a native...
asked by 27.10.2017 / 19:08
2
answers

What is the difference between View and Materialized View?

According to Oracle documentation, a Materialized View is a database object that contains the results of a query and a View is a logical table based on one or more tables or views and does not contain data itself. Okay, the documentat...
asked by 30.06.2016 / 17:23
3
answers

What is the meaning of the symbol || '-' || in SQL

I'm doing a query in an Oracle database and I come across this || '-' || symbology in my query . Would you like to know the meaning? Select xf0cdloc || '-' || XN4CDEMP AS LOCOMOTIVA, From Trem     
asked by 31.01.2017 / 14:07
2
answers

Insert with accents in Oracle

When I make a INSERT for example: INSERT INTO TESTE (NOME) VALUES ('INSCRIÇÃO ESTADUAL'); You're saving to the table this way:    STATE ENROLLMENT And the screen displays "INSCRIÃÃO ESTADUAL" . I am using Oracle...
asked by 15.06.2015 / 19:26
2
answers

Report showing column index

I have a question for generating a report, I need it to get the data from an SQL table and instead the name of the precise table of its ID, below the data that the query generates COD_CLIENTE NOME ENDERECO CPF...
asked by 06.05.2015 / 20:21
2
answers

Entity Framework with Oracle databases

I'm creating an application that will use an Oracle database, but when I enter .edmx (Entity Data Model) I came across the following situation! I can not create a connection with Oracle Database. What do I need to do to make this work?...
asked by 10.04.2014 / 15:38
3
answers

Abort AJAX request

I have a question. I need to cancel an AJAX request on the client side and on the server side. On the client side I use abort() var requisicao = $.ajax({ url : 'xyz.php' }); if(requisicao && cliente_abortou_requisicao){...
asked by 07.11.2016 / 19:05
2
answers

How to get the current year in ORACLE?

I need to get the annual year in ORACLE, but I just know how to get the current date, like this: SELECT SYSDATE FROM DUAL Can you manipulate this to get the Year?     
asked by 27.02.2014 / 19:27
1
answer

Is it possible to define a connection pool for each user in an oracle database?

I searched the oracle documentation and found only ways to change the image, but nothing about creating another. Does anyone there know if it's possible what I'm ordering? And how to proceed? Thank you in advance. Att Harisson Ford A....
asked by 19.05.2016 / 17:33