Questions tagged as 'oracle'

Tagged questions
0
answers

Login php and oracle

I am trying to do a login in php with a bbdd of oracle, but when I try to login it tells me what the wrong user is. What can be wrong? The connection to the bdd if it works correctly. <?php //abrimos sesión session_start(); //C...
asked by 08.05.2018 / 19:49
2
answers

REGEXP_REPLACE SQL / ORACLE

Good I am trying to replace certain characters of a string belonging to a field in my database. 352-6325632 Serially Replaced (352) -632-5632 when using the regexp_replace function of oracle the second parameter is always equal to the expected o...
asked by 21.05.2018 / 18:22
1
answer

ora-01830: the date format mask ends

Good I have a problem when launching the following query. I want to bring all the receipts issued in the date range. SELECT COUNT(FCHA_EMSION) AS TotalMesFebrero FROM PREDIAL.DOCUMENTOS WHERE FCHA_EMSION BETWEEN '01/02/2017' AND '30/02/2017';...
asked by 03.05.2018 / 20:53
0
answers

Migrate character set oracle WE8MSWIN1252

in an application I want to migrate from an Oracle version 11 database to a version 12. Currently my database is on a Windows system and has a characterset of WE8MSWIN1252, and I would like to know if migrating the database to a Unix system t...
asked by 23.04.2018 / 15:20
3
answers

how can I apply a DISTINCT to this query?

SELECT ADM.GROUP_ID, ADM.GROUP_NAME, ADM.CUG_ID, ADM.ADMIN_SUBS_ID, ADM.MSISDN MSISDN_ADMIN, ADM.SUBSCRIPTION_STATE ADMIN_STATE, SUBS.MSISDN MEMBER_MSISDN, SUBS.SUBSCRIPTION_ID, SUBS.SUBSCRIPTION_STATE MEMBER_STATE, SUBS.GROUP_I...
asked by 16.04.2018 / 23:33
0
answers

Problem with restart after installing Oracle 11g

Hello friends, the following error occurred to me, I had installed the Oracle 11g database in "Red Hat Enterprise Linux 5". The next day I opened everything as the day I installed it and what happens to me can be seen in the images. What surp...
asked by 13.04.2018 / 01:46
0
answers

Retrieve Value in APEX - ORACLE

I'm still a Rookie at the Apex and I ran into a problem I have an interactive report with a query to a database, I made some adjustments to try to call these records to a modal page with their respective text fields by means of the "id" that...
asked by 05.04.2018 / 22:58
0
answers

Error creating a user in Oracle

I'm trying to create a user in Oracle and I get the error    can not specify temporary tablespace as default tablespace This is what I am trying to do: create user testuser identified by "test" default tablespace temp temporary tablespa...
asked by 12.04.2018 / 16:05
0
answers

Print the two variables of two tables

My problem is this: I want to print the result of two fields that are in two different tables and that show like this: field1-table1 field1-table2 field1-table1 campo1-tabla2 What I have is this and it prints me the values of one table...
asked by 26.04.2018 / 00:02
2
answers

How to add 7 column in Sql?

I have the following query in which I get the following result: I want to add a column for each row, Thank you very much. SELECT COUNT (ID_MODALIDAD_TIPO_TRAMITE) as "" FROM SOL_SOLICITUD_TPO_TRAMT_MODL WHERE ID_MODALIDAD_TIPO_TR...
asked by 03.04.2018 / 19:59