Questions tagged as 'oracle'

Tagged questions
1
answer

Use conditional to check the dates if it does not exist in a column search with the null value

I have the following tables in Oracle DB 11g irrigation ---------------- militet_applied, close_date rainfall --------------- rain_index, reading_date And I'd like to make a select similar to this: select r.rain_index, i.milite...
asked by 04.04.2017 / 09:48
1
answer

RANK () ORACLE Function

Could anyone explain to me what's wrong with my syntax / usage of the RANK function? Problem situation: "Make a ranking of songs per band, so that the songs of greatest occupy the first places. Display band and music name and ranking position...
asked by 31.03.2017 / 03:46
0
answers

How not to convert an exponential number to decimal?

I'm having the following problem: I created a function to put the thousand point (s) in the values that it receives as parameter (VARCHAR2). This function receives integer values and values of type VARCHAR ('Some text'). When the value is not...
asked by 12.04.2017 / 19:56
1
answer

How can I apply Unpivot in a simple select, I want to leave a query vertically

According to the code below: SELECT 1 DADO1 ,2 DADO2 FROM DUAL I would like to leave the search result vertically, I am a beginner in Oracle, I saw what to do with unpivot but I did not find a simple example demonstrating the ver...
asked by 14.03.2017 / 15:06
1
answer

Error nullpointer when doing query in the bank with parameter

When I run the query below I have a nullPointer error. @Query(value = "SELECT * FROM x WHERE USER_NAME = :name", nativeQuery = true) DataBaseCobilling findByCdIdent(@Param("name") String name); But when I run this one it works: @Query(val...
asked by 21.03.2017 / 15:24
1
answer

How to add many clients at once in a database table?

I need to add Name, Phone and Address of many clients that are in excel and pass this to the database. What would be the quickest way to do this?     
asked by 07.03.2017 / 21:48
0
answers

When I run Update eclipse to run

When you get to the part that executes the following query, the system stops and does not proceed to the next line. @Query(value = " UPDATE COOBILING_NUMBER SET CONDITION='Used' WHERE NUMBER_PHONE= ?1", nativeQuery = true) public void update(S...
asked by 21.03.2017 / 21:48
1
answer

Error when inserting an image in Oracle using PHP PDO

I am making a system in PDO PHP which writes some images to the database, that same system was migrated from a MySQL database and was working perfectly, however at the time I'm going to record the image in a column of type...
asked by 02.03.2017 / 18:13
0
answers

How to write a base64_encode image with more than 4000 characters in Oracle using php

I'm trying to insert a base64_encode image with php into Oracle, however at the time of inserting it it returns me the following error: ORA-01704: string string too long. The reason for returning this error is because the string is too l...
asked by 07.03.2017 / 12:13
0
answers

How to create a linkage variable in Oracle with php

I need to create a connection variable to use at runtime with PHP in Oracle, how can I do this?     
asked by 06.03.2017 / 18:27