Questions tagged as 'oracle'

Tagged questions
1
answer

Oracle - Filter by date

I have a column dt_atualiza_log that is with type DATE in the table (it is saved in the 01/12/2011 10:10:48 format) I'm not able to filter on and of my query . I have tried in many ways, the last one: AND ma.dt_atualiz...
asked by 11.06.2018 / 18:29
1
answer

Difference between select a. or b [closed]

What is the difference of doing the search by select a. or b.? Example: select --a.num_duplicata,a.data_prorrogacao,a.seq_duplicatas, a.cli_dup_cgc_cli9 as cgc9,a.cli_dup_cgc_cli4 as cgc4,a.cli_dup_cgc_cli2 as cgc2,b.nome_cliente as...
asked by 18.10.2017 / 17:08
1
answer

Is there anything similar to SQL SERVER WITH (NOLOCK) in ORACLE?

I recently discovered in SQL SERVER the option of not locking tables for insertion while reading some data, and thus gain some performance in some specific situations. I searched, but I did not find anything similar in ORACLE. Does anyone kno...
asked by 12.02.2016 / 13:59
1
answer

TO_DATE (SYSDATE, 'YYYY-MM-DD') works sometimes

I have the following problem: I use JDBC to connect to Oracle. And I call rs.getTimestamp(index) to get a date field. When I run the function TO_DATE(SYSDATE, 'YYYY-MM-DD') the getTimestamp sometimes returns a n...
asked by 14.03.2017 / 13:10
1
answer

Automatic class generator

How do I get an entity in the DB (Oracle) and generate a class on my system that represents that entity? Ex: I have this entity    Customer       ID int primary key       Name varchar (100) And now with the tool it already generates...
asked by 17.02.2016 / 11:56
1
answer

View SQL at runtime

Is there any monitor that shows me the sql script at runtime? For example, during the debug, I would like to see how the script was mounted by the following code: var q = (from proc in Sessao.Query<Processo>()...
asked by 28.03.2016 / 14:53
1
answer

Why Oracle does not have autoincrement?

Assuming that Oracle is known to have the capabilities of the sequence table. I would like to understand why I recently implemented autoincrement in Oracle, since it was an existing feature in competitors (SQL Server, MySQL). What motivat...
asked by 01.11.2017 / 13:23
2
answers

Importing Data

Hello, I would like to know how I get a value from my database and take it to an "automatically" field. For example, in the image below, I want this field marked to go to an information that is already saved in my database. I would like to know...
asked by 18.06.2016 / 00:00
2
answers

Is it possible to use native query + spring data to do pagination?

I need to do a paging using dynamic queries because I have to do many joins, I'm trying to make only a select * to test the use of the native query + spring data, but the error message is as follows: Cannot use native queries with dynami...
asked by 10.11.2017 / 16:50
1
answer

Error: Registering? in place of special character only using the browser

I'm having a problem saving data in my ORACLE database. When using my application to fill in fields and register a string, special characters such as accents are replaced by a ? in the database The detail is that if I get the same query a...
asked by 18.03.2014 / 21:33