Questions tagged as 'oracle'

Tagged questions
1
answer

Error ORA-00905 when creating table

I'm starting to model a database. I started with a table first (later I could add more elements) but when entering the code to SQL Developer, this error appears: Informe de error - ORA-00905: missing keyword 00905. 00000 - "missing keyword" *...
asked by 03.01.2018 / 20:00
2
answers

DBMS output is not displayed in Oracle SQL Developer

For some reason, when executing the following code, the result of the query is not shown by the output of dbms. The same code has been tested on another PC and it works. For the script output shows that everything went well:    PL / SQL proce...
asked by 23.11.2017 / 09:26
1
answer

Error starting and uninstalling Oracle 10g express

Good evening I have this problem when starting Oracle 10g. When I start it, I get this message: And when I want to uninstall it, the window appears, loads for a few seconds and closes: What could I do? I tried to do what the...
asked by 13.11.2017 / 04:11
2
answers

Help with DISTINCT in Oracle

I've been trying to get a SELECT out of the job since yesterday. Let's see if you are able to help me. Tables: directions ID NUMBER TIPO_Direccion NUMBER id_persona NUMBER direccion VARCHAR2(50) people id NU...
asked by 30.08.2017 / 13:17
1
answer

ORACLE 11g Execute Trigger

How do I assign privileges to a user to execute a trigger ?, I need to know if a trigger can be executed and how to assign privileges if possible     
asked by 25.07.2017 / 22:01
1
answer

Update view in oracle [closed]

I have a table for example Personas that has 20 data, now I create a view from that table and call it Personas_V , which has the 20 data of the table Personas . If I add 2 data to the table Personas would have 22 dat...
asked by 13.06.2017 / 10:52
2
answers

Limit the number of oracle records

I use oracle 11, I have the following query: select * from(select "Loss","Date" from TEST order by "Loss" desc) where rownum < 20 This returns 20 records that you have the largest "Loss", is there another way to do it? My question is...
asked by 20.06.2017 / 13:10
2
answers

Error query sql oracle

I have a java application that is connected by JDBC and I make this query: My code: String date = "21-Dec-16"; StringBuilder query = new StringBuilder("SELECT * "); query.append("FROM TEST WHERE PUBLISHED_DATE='").append(date).append("'");...
asked by 19.05.2017 / 12:04
3
answers

How to get the minutes of a date field

I am trying to update the records in an Oracle SQL database and I can not find the correct sentence. The EXPENSES table is composed of the following fields: DATE TYPE: DATE REGISTER EXAMPLE: 01/01/2018 12:00 SPENDING...
asked by 05.09.2018 / 17:58
1
answer

Incomprehensible error [closed]

I get an error when executing the following code: CREATE OR REPLACE PROCEDURE ListaPrimos (n1 IN number, n2 IN number) AS metodo number; BEGIN if n1<n2 then metodo := n1; while (metodo <= n2) loop...
asked by 12.04.2017 / 12:14