Questions tagged as 'oracle'

Tagged questions
1
answer

Oracle REGEXP_SUBSTR to SQL Server?

I want to convert the following to MS SQL Server : REGEXP_SUBSTR(m.DESCRIPTION,'CATEGORY=([^,]*)(,|\Z)',1,1,'c',1)     
asked by 17.10.2016 / 19:15
1
answer

How can I group my records by name in Oracle PL / SQL

This is my SQL query as I could group by only the names to retrieve the Top of sold items SELECT A.ART_DESCRIPCION, SUM(VD.VD_CANTIDAD), SUM(VD.VD_TOTAL_GS) FROM VENTAS V, VENTAS_DETALLE VD, CLIENTE C, ARTICULO A WHERE V.VEN_NRO = VD.VD_NRO AN...
asked by 12.11.2018 / 15:01
1
answer

query to oracle database

Good afternoon, I need to make a query to an Oracle database, and it shows me this error    Fatal error: Uncaught PDOException: SQLSTATE [HY000]: General error:   933 OCIStmtExecute: ORA-00933: SQL command not properly ended   (ext \ pdo_oci...
asked by 23.10.2018 / 19:47
1
answer

ORACLE SQL STATEMENT IGNORED missing parentheses right [closed]

I can not find any missing parentheses in the line set project.activity.full_in = TO_NUMBER, I have reviewed it 20 times and the parentheses close well, I have 2 errors: ORA 00907 missing parentheses right and in the previous line to that it say...
asked by 04.10.2018 / 22:33
2
answers

Delete a record from a database in Oracle

Sorry if the question is silly; but I am new in database and I would like to know if you can support me, please. My doubt is that I have a database in Oracle called ( Company ) with non-relational tables, in them I manage folios of people...
asked by 20.09.2018 / 20:48
1
answer

Enable remote connection to oracle database 12c

I have a database on a server and locally the connection is correct with sqldeveloper but if I try to access from another ip it stays loading and the connection drops by timeout, I understand that I must enable the remote connection but I can no...
asked by 28.08.2018 / 00:01
1
answer

problem when installing oracle in debian

I have a problem trying to install oracle 12c release 2 on debian I was looking for online files that made my life difficult, and now that I want to run ./runInstaller I get the following error. You do not have sufficient permissions to acces...
asked by 10.09.2018 / 07:19
1
answer

I have a problem with ORACLE, System.Data.OracleClient

I have a stored procedure Oracle IDE: 4.0.3.16.84 and Visual Studio 2015 OracleConnection con = new OracleConnection(); OracleCommand oracommand = new OracleCommand(); OracleDataReader lector; con.ConnectionString =...
asked by 17.08.2018 / 00:24
1
answer

Store procedure in oracle, select

I am trying to generate an SP in oracle which returns a select of a column. Currently CREATE OR REPLACE PROCEDURE get_usuario(idUser IN USUARIO.ID%TYPE, O_EMAIL OUT USUARIO.EMAIL%TYPE) AS BEGIN SELECT EMAIL INTO O_EMAIL FROM USUA...
asked by 09.08.2018 / 00:21
1
answer

How to format DD / MM / YYYY in a Date type field of a table in oracle?

I have a query which gets some Date type fields The result of this query is downloaded to a .csv file and what it does is that it does NOT show the date fields in DD / MM / YYYY format, try to convert them with to_char but when you sho...
asked by 25.07.2018 / 05:46