Most voted "oracle12c" questions
37 questions
Sort by count of
-
3
votes1
answer261
viewsSelect with specific column - Oracle
I’ve been migrating to Oracle and found a question. In SQL Server I could do so: select coluna, * from tabela How do I get a similar result using Oracle 12c?…
-
2
votes0
answers384
viewsOracle PL/SQL - Connection with Webserver SEFAZ
Someone here has already been able to establish contact and authenticate SEFAZ (NF-e or Reinf) servers through PL/SQL with Oracle Wallet? For the last few weeks I have been trying to make contact…
-
2
votes1
answer1566
viewsError: The provider 'ORAOLEDB.Oracle' is not registered on the local machine
Error: The provider 'ORAOLEDB.Oracle' is not registered on the local machine. I need to do some maintenance on a project. NET , with Oracle 12c version and my operating system is 64bit Windows 10…
-
2
votes0
answers34
viewsTrigger that validates the percentage of each tranche in a purchase note greater than x value
Good morning, I’m having a hard time creating a Rigger that checks on the Insert and update a higher apportionment number than x ( I’m using 30 for testing) on each purchase note. This is the first…
-
1
votes1
answer116
viewsRemoving comma from the pl sql column
Good afternoon, I have a table that has names. In some lines the name is separated by comma. Ex: Alberto, Luiz I want to change these lines to stay Luiz Alberto DECLARE final VARCHAR(50); inicio…
-
1
votes1
answer107
viewsHow to select distinct from the Listagg function in the 12C database
Is there any 12c bank function you can use on listagg and does not bring repeated results? SELECT SUM(quantidade) quantidade, LISTAGG (mib.segment1, ' - ') WITHIN GROUP (ORDER BY ROWNUM) item,…
-
1
votes0
answers141
viewsHow to install oci8 on the Azure Devops linux host
I have a php application that requires an oracle connection 12c and when performing the "compilation" on Azure the following error is displayed during the composer install Problem 1 - Installation…
-
1
votes1
answer69
viewsKill ORACLE session 12c
good morning. I would like to run a command to kill sessions on ORACLE 12C but the only command I know is ALTER SYSTEM KILL SESSION 'sid, serial, @instancia' IMMEDIATE; But I wanted to kill specific…
-
1
votes2
answers7751
viewsORA-06502 - string buffer too small numerical or value - Long Field
Good morning, I’m performing a query to query data in a Long-type field. I created the following Function to bring the data: CREATE OR REPLACE FUNCTION "SEARCH_LONG" (r rowid) return varchar2 is…
-
1
votes1
answer41
viewsHow to find Wrapped objects in the database
I have a database with several objects Wrapped, and I need a way to search and locate all objects that are encrypted, ie with the wrap, to subsequently have a treatment. What are Wrapped objects:…
-
1
votes1
answer211
viewsTwo conditions in Where do not bring a result
I am doing a query in Oracle Database 12C and I have a problem: I want only products that have address_1 as 'A' appear in my ResultSelect. In the example below the item "code: 312107" it has two…
-
0
votes0
answers50
viewsError in connection to oracle database after doing Publish on Azure with visual studio
I am developing a project in Asp.net with Oracle data base 12c. The connection to the database locally works. It does all CRUD functions. I am also using the services of Azure (project requirement),…
-
0
votes1
answer125
viewsError inserting data into recordset with oraOLEDB
Good afternoon, everyone. I have a problem in various applications here in the company that are in VB6. When I try to include a record in a recordset an error occurs (it is described in the code),…
-
0
votes0
answers24
viewsInsert as a result of a select, how can I do this on Oracle?
Someone can tell me how to record in the Oracle bank with Loop. When I run below it only saves the first record. INSERT INTO BURD_400 ( NIVEL, GRUPO ... ) SELECT…
oracle12casked 5 years, 9 months ago Anderson de Freitas Migloranza 155 -
0
votes1
answer43
viewsnot in the same table
Let’s say I have the table CON_CONTRATOS and in it I have con_customerId, con_vencimento among others. And I need to make a select that returns ALL contracts of a Costomer whose same only contract…
-
0
votes1
answer203
viewsFind shift based on a given date time in ORACLE/sql
In a table X I have a date column that also returns the time, I wonder if, based on this time, I have how to create a column with the name of the turn. ex( if you have a die 20-02-2002 06:00:00 I…
-
0
votes1
answer190
viewsInsert for each record found - PL/SQL
good morning. I’m new to Pl/sql and I need to insert 110 records (Number 1 to 110) in a table ( table: stick) for each ID of the court table. Insert would be more or less: INSERT INTO…
-
0
votes1
answer689
viewsLong to Varchar data conversion
I am trying to convert data from a Long field to Varchar, but when I do the procedure, it is returning the following error: ORA-01422: Exact extraction returns more than the requested number of…
-
0
votes2
answers67
viewsHow to calculate the value of two subquery in Oracle SQL
How to calculate two subquery on Oracle? Could you explain to me how I sum up VALOR_1 + VALOR_2? SELECT COL1 , (SELECT SUM(TAB1.VLRTOTAL) FROM TABELA TAB1 WHERE TAB1.ID = TAB3.ID) AS VALOR_1 ,…
-
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
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
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
votes1
answer191
viewsWrite Oracle SQL File
Good morning, I am beginner in Oracle PL/SQL, and I created the script below to record the result of a query in txt file, runs without errors but does not write the file, anyone knows what could be…
-
0
votes1
answer52
views -
0
votes0
answers34
viewsProcedure de Update oracle
Good morning! I’m still a layman at BD and I’ve been catching a little bit. I would like, please, to know if you could help me with a given problem. My scenario is as follows. I have two screens, a…
-
0
votes1
answer71
viewsGroup By select
I have an Employee table with the fields Name, Age, Gender and Company. And each employee may or may not be in more than one company. With that I made the following select in this table. select…
-
0
votes1
answer117
viewsIs there any way to get a JSON "result" using Oracle’s utl_http package
Is there any way to get a JSON "result" using the package utl_http oracle ? The status code of the following routine returns 200 but would also return a "Sponse" with a JSON conformation, an…
-
0
votes1
answer24
viewsHow to create a read sequence in a Select field in the Oracle Database?
I have a problem in my code I would like a help with an excerpt of my code. the ITE.SEQUENCIA line did not want to leave the number 1 fixed, because it may be that an item is deleted and starts with…
-
0
votes1
answer27
viewsstatus of a record in a given date range
Greetings! I came across a problem and I’d like some help if that’s possible. I am developing a financial report and in this report I need to get the status of a title in a certain period. For…
-
0
votes0
answers29
viewsProblem with validation process
I am creating a precedent to validate whether the field discount (%) receives a percentage less than zero (negative value) or greater than 100%. But when executing appears an error that I am not…
-
0
votes2
answers59
viewsHow to make a SELECT to get the value of the last registered date
Hello, I would like a help to always use the value of a table. I have a table "COSTS" and every month it suffers price change of the products, but are not all that has update My question is that…
-
0
votes0
answers14
viewsHow to create a temporary table within a function in oracle?
I’m creating a time sheet in the system. The idea is that the user fill in a filter with the reference date and then Function prints every day of the month with the abbreviation of the day of the…
-
0
votes0
answers16
viewsWhy can’t I handle errors when mapping tables?
How can I improve error handling when mapping tables/views? I already solved the error, but I need to e-mail a message with details of the error, as it is not Code First, I end up having these…
-
-1
votes1
answer26
viewsInsert random numbers through Precedent
I am trying to insert some random record into a table but am encountering some errors. I created a test table; `create table teste_p(Handle int, name varchar(20)); I need to insert something like:…
-
-1
votes1
answer48
viewsHow to Restructure a JSON
I created a Node js API connected to Oracle 12.1.0.1.0c where I connect and do the request as follows through the dbconection.js file as shown below: const oracledb = require('oracledb'); const {…
-
-1
votes1
answer53
viewsOracle - Error : ORA-24263: Certificate , how to treat?
Sending https via Oracle Version Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production PL/SQL Release 12.2.0.1.0 - Production "CORE 12.2.0.1.0 Production" TNS for Linux: Version…
-
-2
votes1
answer823
views