Questions tagged as 'oracle11g'

0
answers

Failed to update in registry

I'm having the following problem, when I try to change a registration made by my application, it creates a new registry instead of changing. My question is, if when I do the trigger insertion of the sequence , I should change to...
asked by 03.09.2017 / 07:30
1
answer

Failed to update field of all records with path of files using JDBC

I'm migrating pdf files stored in the database to file systems. In the code as it can be seen below, I use an algorithm that generates the names of the files and saves them in a directory generated through the date of inclusion of the document....
asked by 12.08.2017 / 16:50
1
answer

Variable float with 2-digit precision after the comma in sql oracle

How do I create a float variable with 2-digit precision after the comma in a table in SQL / Oracle. Thank you in advance.     
asked by 06.06.2017 / 15:36
0
answers

How to create a new database in ORACLE?

I installed the oracle database, oracle client, and sql developer on a windows 8.1 64 bit. With the installation of the oracle database a database was created in localhost: 1521 But now I would like to create a new database on this connect...
asked by 08.06.2017 / 17:23
1
answer

Authenticated Users

How do I add (authenticated users) back to the GROUP OR USER NAMES in the Security tab in a given folder?     
asked by 10.05.2017 / 16:32
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
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

Oracle 11g table backup

I use oracle 11g in the free version. According to database classes with oracle, the free version does not allow you to create a database. You can create user and create tables. Based on this, how do I back up these tables? Example of the initia...
asked by 21.11.2016 / 19:25
1
answer

Oracle email attachment plsql goes empty

I have the PLSQL block below listed, the email is sent but the file that should be attached arrives empty in the destination email. Send an existing file, right? What am I doing wrong? Thankful declare ds_email_origem_w varchar2(30)...
asked by 27.01.2017 / 13:58