Questions tagged as 'oracle'

Tagged questions
1
answer

Error registering with Oracle from JAVA Netbeans

Good afternoon friends I have a problem with an application that I am developing, it is something simple. By registering a person in my Oracle Database. That's my Conexion class. public Connection xconecta(){ try { Class.forName("or...
asked by 18.03.2018 / 18:49
0
answers

How to validate a Trigger with a Function? - Oracle

I am still incurring the Oracle world and I encountered a Situation. I would appreciate even the slightest suggestion or help:). Now, I have a "SENSOR" Table with a "QUERYS" field, this field has records with queries that will simply return n...
asked by 21.02.2018 / 16:38
0
answers

ORA-01927 privilege is not revoked: can not REVOKE privileges you did not grant

With the user SYS it is required to revoke the privilege EXECUTE of the table AWRRPT_HTML_TYPE however when executing the statement REVOKE EXECUTE ON AWRRPT_HTML_TYPE FROM PUBLIC; Displays the following message:   ...
asked by 21.02.2018 / 20:37
0
answers

OracleDependency

I want to make an application that has push notifications, using OracleDependency, I follow the instructions in the documentation. I execute the following commands: grant change notification to SN_Hospitales; GRANT EXECUTE ON DBMS_CHANGE_NO...
asked by 03.09.2018 / 10:43
0
answers

Does not show dates from PHP when consulting Oracle

I have an Oracle database that I can access through PHP and visualize information about it, through SQL Developer I have a statement that executes and returns these results: But executing the same sentence in PHP: $tsql= "select orden...
asked by 04.09.2018 / 15:18
1
answer

Avoid entering duplicate data in an Oracle table

I would like to know how to create a Trigger in Oracle that prevents data from duplicating data in a table. To start I have my temporary table: CREATE TABLE temporal( Nombre varchar(50), Tipo varchar(50), Pais varchar(50) ) That when you...
asked by 02.01.2019 / 03:39
1
answer

configure memory variables for Oracle 11 and 12 linux

I am currently trying to install an Oracle database (11g or 12c) on a virtualized opensuse, within the guidelines I followed request modifying the memory variables in the file /etc/sysctl.conf the variables are kernel.shmmax kernel.shm...
asked by 27.07.2018 / 04:18
2
answers

Problem when rating object-table when doing a SELECT on Oracle

I have a problem with the following query : SELECT USER ,TO_CHAR(LAST_LOGIN, 'DD/MM/YYYY') LAST_LOGIN ,SAILA ,MAX(INTENTS) INTENTS ,MAQ FROM OWNER.MY_TABLE_NAME WHERE LAST_LOGIN >= TO_DATE('22/02/2017' || ' 00:00:00', 'dd/m...
asked by 23.02.2017 / 00:31
0
answers

Use package oracle in java

I'm running a query on my sqlDeveloper and it throws me the correct result >>24 piezas . When I transport this query to java, it throws me a different number of pieces >>39 Here my code: $_Query = "select sum(n...
asked by 05.10.2016 / 21:35
1
answer

Error classic asp and oracle dates

I'm having a problem inserting a date and time into a database. I am using asp classic and the database is oracle. The code I am using is the following Set conn = Server.CreateObject("ADODB.Connection") conn.Open conexion...
asked by 17.07.2017 / 10:18