Most voted "oracle" questions
Oracle Server is a relational DBMS (Danco Data Management System), created by Oracle Corporation. Do not use this tag for other Oracle owned Sgdbs servers (for example Mysql, Timesten and Berkeley DB).
Learn more…1,134 questions
Sort by count of
-
0
votes0
answers30
viewsIf informed parameter does not bring any data in the Stored Procedure (Oracle)
I’m having a problem in the Stored Procedure below, where it only brings the data if the parameter of EmpresaId come blank. If I inform the parameter EmpresaId, does not bring any data. I am a…
-
0
votes0
answers51
viewsGrant select for view
Good morning gentlemen I created a view and later created a user CREATE USER pafunsio IDENTIFIED BY "pafunsio"; assigns Grant to connection GRANT CREATE SESSION TO pafunsio; and assigns Grant to the…
-
0
votes0
answers46
viewsString INSERT INTO Error with Quotes
I have the INSERT INTO below that shows error in the field where the value is '[/\d/, /\d/, /\d/, /\d/, '/', /\d/, /\d/, /\d/, /\d/]' INSERT INTO ADVDEV."Mascara"("Guid", "MascaraId", "EmpresaId",…
-
0
votes1
answer110
viewsOracle SMTP does not send hidden copy (BCC)
I’m trying to send a "Blind Copy" by our Email Sending Procedure by documentation would be ok , but is not sending or generating any error , the code is below , the sensitive items were exchanged…
-
0
votes1
answer76
viewsSQL Plus - Export CSV without Query in File
I am trying to export the result of a query in SQL PLUS to a CSV. It is working, but I want used for extraction is coming in the first lines of the CSV file, which hinders the end user. Have some…
-
0
votes0
answers17
viewsPASS SQL FORMULA IN ACCESS (TEXT MINING)
Good afternoon! I’m passing a sql formula for access WHEN ((SA_P1_RESULT_VISITA LIKE '%VISITAD%') OR (SA_P1_RESULT_VISITA LIKE '%FACHAD%') OR (SA_P1_RESULT_VISITA LIKE '%INSTALA%') OR…
-
0
votes1
answer74
viewsError in APEX_APPLICATION.G_F01 - ORACLE APEX
I have a problem with this script below: I have a checkbox on my page ( not in report, on the same page, a page item) and I would like the same when clicking and pressing a Ubmit button to perform…
-
0
votes1
answer238
viewsQuery in two Oracle tables
How do I query two tables at once? I have two table structures as follows. TGFCAB ___________________ |NUNOTA| DTMOV | ------------------| | 1 |01/06/2019| | 2 |02/06/2019| | 3 |03/06/2019| and…
-
0
votes0
answers171
viewsTotal results by products in oracle table
I have two tables similar to the tables below: TGFCAB |NUNOTA| DTMOV | ------------------| | 1 |01/06/2019| | 2 |02/06/2019| | 3 |03/06/2019| TGFITE |NUNOTA|CODPROD|QTDNEG|VLRUNIT |VLRTOTAL|…
-
0
votes0
answers37
viewsHow to limit to not being able to pass 3 units of a book in a PL/SQL ORACLE rental
I’m making a bookstore in APEX and I can’t allow the client to rent more than 3 books. But even putting the code the program does not bar. declare W_QUANTIDADE_EMPRESTIMOS number; W_STATUS…
-
0
votes0
answers81
viewsConstraint Fk Composite
Hello, I am creating a Foreign key Constraint composed like this: alter table "Tabela1" add constraint constraint_fk foreign key ("Guid","Tabela2Id") references "Tabela2" ("Guid","Tabela2Id") When I…
-
0
votes1
answer87
views"ORA-00955: name is already used by an existing Object" error
When I try to run this part of my code in Oracle Live SQL, it gives the error "name already assigned to existing object". But there are no repeated names here, other than my primary and foreign…
-
0
votes0
answers12
viewsWhat is the difference between floor and trunc in sql oracle?
Studying SQL with Oracle I came across floor and trunc, apparently both have the same function, which is to round the decimal numbers down. I would like to know if there is any difference between…
-
0
votes1
answer1449
viewsPL/SQL Insert with cursor
Everybody, good afternoon, everybody. I have 2 tables, one of foro_tribunal and another of vara In the table of vara, need to include 111 records by foro_tribunal, so I created a foro_tribunal as a…
-
0
votes0
answers16
viewsConvert Long Raw Data to BLOB ORACLE DB
My situation is as follows, I have 2 tables with different Owners, a stores the photos of the company’s employees in formed LONG RAW and on the other site I need to fetch these photos and present…
-
0
votes1
answer21
viewsProblems with Maven
Hello I read how Maven works, but there is one thing I don’t understand I will depend on Maven after creating my executable program ? i’m a beginner in java, I would also like to know how to use the…
-
0
votes1
answer44
viewsCrontab stops working when Oracle connection arrives in PHP
I am trying to run a routine by crontab, but it hangs on the connection to the Database. But if I run the file normally as: php /var/www/html/pasta/teste.php He returns the data to me normally: This…
-
0
votes0
answers41
viewsHow to not duplicate my LISTAGG
Follows my sql to low oracle use SELECT DISTINCT pf.nome AS servidor, m.matricula AS matricula, ca.descricao AS funcao, TO_CHAR(c.dataadmissao, 'dd/mm/yyyy') AS admissao, LISTAGG(ev.descricao, ',')…
-
0
votes1
answer28
viewsUse more than one value to use parameter in an Oracle function
Good afternoon, I have the following problem: I need to perform a function that calculates the average value of a product on a specific date. SELECT VERIF_VL_CUSTO_MEDIO(PRODUCT.CD_PRODUTO,…
-
0
votes0
answers256
viewsProblem to connect with oracle using php 7.1?
I’m having a problem making a connection to Oracle in PHP 7 appears the error message below: ERROR: could not find driverERROR: could not find driver Notice: Undefined variable: conAD in…
-
0
votes1
answer131
viewsHow to make a bit flags selection filter?
I am a database novice and am participating in an Oracle-SQL project where I need to create a flags selection filter in a column that stores flags as active or not from the position of each binary…
-
0
votes1
answer187
viewsUse column in oracle subquery
Example SQL, revolving this solves my case of the real problem. In select below, I need to use the column mes in the where 1=1, but gives invalid identifier, how can I access that column in the…
oracleasked 5 years, 3 months ago Igor Lisboa 21 -
0
votes1
answer28
viewsOracle Year in full
This question is allowed ? Simple , in thesis SELECT TO_CHAR(SYSDATE, 'YEAR','NLS_DATE_LANGUAGE=PORTUGUESE') FROM DUAL; You should return Two thousand and twenty-one. But returns TWENTY-TWENTY-ONE…
-
0
votes0
answers6
viewsOracle Apex upload data via csv file
I have a problem in my system, I have a demand where I need to implement a functionality to be possible preencher dados através de um arquivo csv, a company would create in Apex the records for the…
-
0
votes0
answers230
viewsUse two fields with different settings on Oracle
I’m having a hard time: I’m trying to use a field that was created as number with a field created as NUMBER NOT NULL ENABLE. The ID_ACESSO field was created like this: "ID_ACESSO" NUMBER NOT NULL…
-
0
votes0
answers43
viewsHow to list the number of open records and which were served in the same sql?
I need to get the number of open calls and the number of open calls that have been answered, all grouped by month. I’m trying like this: select T_aberto.mes, T_aberto.qtd_aberto,…
-
0
votes2
answers251
viewsFailed to create Node pool connection
I am trying to open a connection pool using the oracledb module but I get an Exception when trying to create the pool import OracleDB from 'oracledb' import dotenv from 'dotenv' OracleDB.outFormat =…
-
0
votes1
answer138
viewsTrigger which arrow default value for a field
follows the statement: If the employee department code is not Insert or if it does not exist in the table , assign to it the value standard 20; And I made the following code: create or replace…
-
0
votes1
answer55
viewsSearch records filtering by Count from a subconsulta
I have the following problem: I have three tables and need to show the employee record only when it has 1 and only 1 dependent. And it should also have 0 and at most 1 prize record, according to the…
-
0
votes0
answers152
viewsValidate record that has comma in the Oracle PL SQL field
I’m creating a procedure in PL SQL and I have an "unregulated" field that may have more than one comma-separated record. That one procedurecarries out the cancellation of sending extracts of a…
-
0
votes1
answer202
viewsDynamically referencing dll C#
During the development of an application that will connect to a database of different versions, a question arose whether it is possible to load the dll based on the version selected by the user.…
-
0
votes1
answer69
viewsSequence in Oracle SQL with strange behavior
I created an Oracle database with the following script: CREATE SEQUENCE pcn_integra_ser_nfe INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 9999999 NOCYCLE NOORDER CACHE 20 It is used in only one…
-
0
votes1
answer102
viewsProblems in Object Reference not defined for an object instance
I have a problem with the result of the method SaveChanges(). I am trying to save a record, and it is persisted in the database, however the application is returning the message from exception:…
-
0
votes0
answers260
viewsNull values in Oracle
So guys, I’m having a problem inserting a data into my Oracle tables, entering the data through a PLSQL routine, and I’d like to know how to insert data into a respective table, but if one of the…
-
0
votes2
answers44
viewsDoubt group by oracle
I want to do a group by between two tables by doing an Inner Join. The employee table and the table employed at the post. I want it to return to the most recent entry into a post of a given…
-
0
votes0
answers179
viewsORA-01000: maximum open cursors exceeded golang
I have a service that runs a stack. For this, it performs the reading of this stack through a query in Oracle. Turns out, after hours of execution, I get the message: ORA-01000: maximum open cursors…
-
0
votes2
answers74
viewsSQL EMAIL PATCH
Well I have several emails with problems at the end ex: hotmal without the . com @gmail without the . com, etc. What I am trying to do in oracle database, I look for gmail.com with the function…
-
0
votes0
answers51
viewsCondition for oracle sql query
I have a user information search service by its registration in an x table. The registration I receive as parameter for the search comes complete (Ex: T111111), while in the bank it is registered…
-
0
votes1
answer29
viewsHow do I add a new user to a PL/SQL table using a function?
I recently started working with PL/SQL and one of the doubts I have is in creating and declaring functions. More specifically on this: -Creates a function that creates a new user: 1: Usa uma…
-
0
votes0
answers47
viewsPROCEDURE WITH MEDIUM
Good morning, everyone, I have the following tables: Create table FUNCIONARIOS (num number, nome varchar2(30), custo_hora number); Create table PROJETOS (cod number, nome varchar2(15), custo_acc…
-
0
votes1
answer38
viewsHow do you get the AM out of a date that doesn’t follow a pattern?
My date comes in this format: 3/1/2020 12:00:00 AM (Realize it’s not 01 and 03, it’s only 1 and 3) But obviously it can also come with two numbers on day and month. Ex: 10/10/2020 This makes it more…
-
0
votes0
answers161
viewsChange Regex to validate Java to Oracle sql email domain
I need help changing the Regex below to validate email domains on an ORACLE basis in accordance with RFC 5322, ensuring that the criteria below are met. Email domain rules to be respected: start by…
-
0
votes1
answer21
viewsProblem with ireport Parameters 4.0.1
Good night, I’m doing a report on Ireport 4.0.1 and I’m having difficulty with some parameters. I have a billing report that requires the code here for some filters. The same are, the initial and…
-
0
votes2
answers281
viewsQuestion about recovering data from database
Good morning. I am a beginner in programming and had an opportunity in a project at work to become a developer. The project is only a panel showing some database data from our main application. I am…
-
0
votes1
answer107
viewsHow to run an oracle database via c# with no data return?
I am developing a WEBAPI in c# that runs a precedent on Oracle and after this procedure, it queries a table. This precedent only deletes data from a time table and inserts the the data informed in…
-
0
votes1
answer51
viewsReturn Anniversary of Hiring Weekly in SQL Oracle
I need to provide information on the hiring anniversaries per week. Exemplifying once a week HR will send a message of congratulations to the hiring birthday. I created the following SQL query:…
-
0
votes0
answers35
viewsPROCEDURE ignoring update - PL-SQL
I made the following code: CREATE OR replace noneditionable PROCEDURE comissao IS BEGIN FOR v_linha IN ( SELECT p.codvendedor AS codvend, p.comissao AS comissao, SUM(f.valortotal) AS quant FROM…
-
0
votes1
answer311
viewsValidate Cpf’s from a query
Opa gente, to trying to validate the cpfs of a query, are several Cpf"s. I have the following function to validate Cpf, but I’m not getting call-there I’m trying to do it like this: SELECT…
-
0
votes0
answers199
viewsValidate Cpf’s of an sql query
Good afternoon people, I have the code below to validate Cpf and cnpj However, when trying to call the sql function, it does not execute because of the following error: [Code: 6552, SQL State:…
-
0
votes1
answer62
viewsHow to insert a constant in a PL/SQL line?
Hello, I’m having some difficulties in data presentation. with atores(nome, data_nasc) as (select nome, data_nasc from representa inner join artistas using(n_artista)) ,realizadores(nome, data_nasc)…