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
-
1
votes1
answer232
viewsCustomize SQL query output
How do I customize an output of an example SQL query resulting from a sum of the columns OUTPUT: 23000 wanted to customize only this output to R $ 23.000
-
1
votes1
answer320
viewsConsecutive sum of a column in SQL
I wanted to calculate the data from a bad table as follows I have a price column 100 140 300 200 wanted to generate a second column that would make a consecutive sum of the previous table 100 240…
-
1
votes1
answer433
viewsIs there any way to use logical operators with CASE/WHEN?
I am trying to use logical operators with CASE/WHEN in SQL but I am having difficulties, I need to present an answer if the result of the operation is less than 0 and another result for when the…
-
1
votes2
answers87
viewsReplace the second repeated character
I have the following value in an Oracle query. SELECT '3.0.' FROM DUAL I’d like you to return only 3.0 and remove the Last Point (.) I tried to use the REGEXP_REPLACE thus: SELECT…
-
1
votes1
answer111
viewsHow to change the field of a table by referencing values from another table. Using cakephp 1.3
I have an association of tables projeto > auto > anexo. In the project table I have a field cod_status, and in the attached table I have a field status. How do I get when I edit the field…
-
1
votes0
answers28
viewsSrcset0 task failure (Loading) on MICROSOFT_EXCEL ODBC source
Good morning, I’m trying to configure oracle data Tegrator to read an excel spreadsheet in xls and xlsx formats, but I’m having problems and I can’t find a solution! it returns me the following…
-
1
votes1
answer98
viewsORACLE SQL - Sort by sum
I need to make a report and I am not being able to sort it as I wish, I want to select customer debt between 60 and 120 days and sort by total. The code is like this: SELECT SUM(cod_fat_cli)…
-
1
votes1
answer1277
viewsError running Procedure on oracle
I got this trial: CREATE OR REPLACE PROCEDURE buscaturma(cod in INTEGER) AS nomeT varchar2(20); BEGIN dbms_output.put_line('inicio'); IF (cod=0)then dbms_output.put_line('ZERO'); ELSE SELECT…
-
1
votes1
answer36
viewsProblem in SQL selection
Why even if I filter to return only the fiat manufacturer, keeps returning other values? SELECT FABRICANTE, MODELO, VALOR_DIARIA FROM VEICULO WHERE VALOR_DIARIA = (SELECT MIN(VALOR_DIARIA) FROM…
-
1
votes1
answer1902
viewshow to add different record values?
I’m trying to add the value of id 1 and the value2 of id 2 which in this case would be equal to 220, as I do this consultation? ID VALOR VALOR2 ---------- ---------- ---------- 1 110 100 2 100 110…
-
1
votes1
answer111
viewsError using Case and Select in PL-SQL
I have this code: DECLARE BEGIN SELECT p.categoria( CASE WHEN p.categoria = 'A' THEN DBMS_OUTPUT.PUT_LINE('A') ELSE 2000 END ) FROM PRODUTO_TESTE2 p; END; Error message: Bug report - ORA-06550: line…
-
1
votes1
answer484
viewsVariable without pl/sql value
I tried to run this pl/sql but it didn’t work declare v teste%rowtype; begin v.ra; select ra into v.ra from teste where nome = 'Danilo'; dbms_output.put_line(v.ra); end; after a long time I decided…
-
1
votes0
answers423
viewsLoop, For, PL/SQL cursors (Doubt)
Good morning Guys, my doubt is the following, my table is so currently: Nome Idade ID João 5 Lucas 5 João 2 Lucas 1 I wish she’d stay that way: Nome Idade ID João 2 1 João 5 2 Lucas 1 1 Lucas 5 2…
-
1
votes1
answer1397
viewsUser permission in Oracle tables
There is a way to know which tables a particular Oracle database user is allowed to select?
-
1
votes1
answer5598
viewsMultiply two columns in a select
I have two columns (valor_unitario and quantidade) wanted to make a select that multiplied all columns in the field valor_unitario * quantidade. Example: Valor_Unit|Quantidade 15 * 2 + 10 * 1…
-
1
votes0
answers60
viewsWhat is 'read coherence' in a database?
I’m doing an article on the Oracle DBMS. And when version 4 was released, it was the first database to have readability. However, I can’t find what that or what this functionality means for the…
-
1
votes1
answer3357
viewsWhat is the number of decimal places of type NUMBER(12,2)?
How to know the number of decimals for type NUMBER(12, 2) in an Oracle database ? V_FATURA NUMBER(12, 2)
-
1
votes1
answer393
viewsError when connecting oracle
I’m trying to perform operation Insert on the oracle by Laravel (5.6), but is giving error: The method I do the Insert is this: public function salvar( Request $request ){ $agenda = new Agenda();…
-
1
votes2
answers441
viewsError when connecting to oracle database using web programming on . net
When making attempts to connect to the bank I obtained the error according to the attached image. My application is web in . net, visual studio 2010, oracle sql database developed 3.1.07. My code…
-
1
votes1
answer200
viewsHow to enter values in Laravel
I am trying to use the following command to insert: $sql = "INSERT INTO tabela (campo1, campo2, campo2, campo4) values(:campo1, :campo2, :campo3,'S')"; $campos = array( ':campo1' => $nome,…
-
1
votes1
answer109
viewsGet Constraint and drop name next
I have a constraint UNIQUE in the PERSON table and is from the field CPF. To get the name of this contraint I use the query: SELECT UC.CONSTRAINT_NAME FROM USER_CONSTRAINTS UC INNER JOIN…
-
1
votes1
answer210
viewsStart and end of a month/year last in parameter (Oracle)
I need you to return the total monthly data according to the MONTH and YEAR parameter reported. I did it this way: WHERE a.dt_mesano_referencia between to_date('01/'|| :NR_MES ||'/'|| :NR_ANO ||'…
-
1
votes0
answers206
viewsOracle - Lock preventing SELECT
Lock preventing SELECT The situation is as follows : An ERP application (Totvs) with multiple tables All these tables use as primary key a standard field R_E_C_N_O_ The application (I believe)…
-
1
votes4
answers95
viewsOptimization in sql
Considering these two tables in the database: Product Table: | id | nome | |-----|-----------| | aaa | Produto A | | bbb | Produto B | | ccc | Produto C | Attributes Table: | id_produto | atributo |…
-
1
votes1
answer193
viewsReset the priority of a record in the table
I need to update to reorder records in a table in an Oracle 9 database. This table stores records that are requests made by users to IT. So, briefly, I have in the table the following fields: PK |…
-
1
votes0
answers42
viewsDifferent results 'Count(*) from V$ASM_DISK'
I have a script that connects on an Oracle basis and makes the following select: select count(*) from V$ASM_DISK; This script is in a . sql file, then I make the following call in the OS:…
-
1
votes2
answers865
viewsSelect to know customers without service in the last 30 days plsql
I have the following columns: CODCLI, CLIENT AND DTULTCOMP I need to know which customers you haven’t bought in the last 30 days. the DTULTCOMP column is in DATE format Table: PCLIENT
-
1
votes2
answers1727
viewsOracle-Variable without data
I have a problem and a doubt at the same time, I made a function to see invoiced orders and declared a function variable so: select filsaida into v_loja from mov_itped where pedido= p_pedido and…
-
1
votes1
answer680
viewsReturn Oracle PL/SQL string range
Good morning ! I need to return the value inside a string between a range of | in the select below I can get the value from the first |. The expected result is: 83,1 SELECT…
-
1
votes1
answer201
viewsSubstitution of Oracle character
I have a field in my table with a string as follows: 80,82,45,80,82,79,88,73,77,79,32,65,32 I want to replace the comma (,) comma between single quotes (','), to stay:…
-
1
votes2
answers108
viewsCreate a Sequence, through a Trigger. Oracle
I’m trying to create a sequence in a trigger. When trying to create by Execute Immediate, I’m getting the following feedback: ORA: 4092 - Cannot commit in a Trigger. For all I’ve researched, use the…
-
1
votes1
answer387
viewsExit command in PL/SQL
I noticed the command exit works like a break, it stops running the current block and switches to the next one, but which command can stop the whole procedure in PL/SQL?
-
1
votes2
answers165
viewsSearch full month ORACLE
I need to run a report that returns the entire amount for the previous month. He used the following form: where cliente.dtultcomp > trunc (SYSDATE-30) But there are cases of the month being 28,…
-
1
votes1
answer205
viewsError when adding FK
I found just about this type of error in "Select", I followed all the restrictions but it didn’t work! Error from line : 86 on command - alter table tb_consulta add constraint…
-
1
votes1
answer106
viewsHow to convert JSON to XML in ORACLE 11g?
Good afternoon, I have a problem at work. Need to create a Function in oracle that performs the conversion of json to xml and show the result as table. I know version 12 of oracle does this easily,…
-
1
votes2
answers841
viewsData in SQL ORACLE
How do I apply a function in ORACLE SQL that brings me only records for the current month? BS.: I have a date column in date format (e.g.: 13/09/18). In sql server I applied the function below and…
-
1
votes1
answer540
viewsHow to select XML and return a specific column from an anonymous block?
I have an anonymous block in PL/SQL that returns to me an XML as the result of running a web service. How do I select this XML to only get a desired column? Anonymous block: DECLARE l_filename…
-
1
votes0
answers168
viewsProcedure with EXECUTE IMMEDIATE
I created a script in Oracle that runs on an Owner, selects on several others and updates on another Owner on another server through a linkedserver. Due to the fact of making select in multiple…
oracleasked 6 years, 6 months ago Reginaldo Rigo 3,638 -
1
votes0
answers22
viewsSELECT Invalid Identifier
I’m in trouble where I use {Routes}.[Qualquer] us subselects. The error returned is "ROUTES"." COLUMN": invalid Identifier. I tried to expose the column on select but I still have the same mistake.…
-
1
votes3
answers134
viewsI’m having trouble summing up the column
I want to sum up the column Value, I know that to use SUM() I also have to use GROUP BY, only I’m not able to make the sum. I don’t know which fields I have to put on GROUP BY. SELECT DISTINCT…
-
1
votes1
answer78
viewsDelete Oracle - Web Api
I’m trying to make this springboot code, become a code in Webapi @RequestMapping("/deletarEvento") public String deletarEvento(long codigo) { Evento evento = er.findByCodigo(codigo);…
-
1
votes0
answers75
viewsCalling in PHP the Jasperreports file with Oracle database
I have some files generated by Jasperreports (.jrxml) consulting an Oracle database. My question is in direct execution with parameterized in PHP (codeigniter framework), MVC standard. I have tried…
-
1
votes2
answers715
viewsWith limit Select output on Oracle
I’m making a bank select and it’s returning me 15 lines. I used ROWNUM to pick up the first 8 lines, only I want to do another select and pick up from line 9 to 15. SELECT * FROM (SELECT DISTINCT…
-
1
votes0
answers587
viewsHow to calculate hours per shift
I have a table in oracle with start time and end of surgeries, I need to add the hours per shift (from 6 am to 11:59 am morning, 12pm to 17:59 pm is afternoon, 18h to 23:59 pm is night and 00 is…
-
1
votes0
answers54
viewsVisual Attribute in Oracle Forms Personalization
I’m having a problem with the Forms Personalization, I am a beginner in Oracle EBS and Forms Personalization. I need to change the background color of my item, but when I use the property…
-
1
votes1
answer287
viewsWhat exactly is the UTL_HTTP (ORACLE) SET_PROXY Proxy
utl_http.set_proxy(http://pgau:abcd@[email protected]:5678'); In this example what exactly this Proxy address ? I tried the internal IP and it didn’t work , the below my company said not to have…
-
1
votes1
answer40
viewsRecover from Oracle Dump
I received an Oracle 11g database for analysis, but the dump file is in format .datp . I couldn’t find any reference anywhere on the internet about this type of file. The client’s instructions are…
-
1
votes1
answer1783
viewsDatabase swapping accent for "?"
In my PL/SQL all accents are being replaced by "?". Example of a table comment: Flag device indicator to be???? used in embracing term or not. Possible???? values: 1 - Yes or 0 - No. Default: 1 When…
-
1
votes1
answer33
viewsPerform schema import by changing Grant and synonym
In one environment I have 5 schemas that make grant and synonym among themselves, of which they are already working. Now I need to duplicate that default environment for the customer environment,…
-
1
votes1
answer1123
viewsDatabase query error - invalid number
Good afternoon. I’m having trouble with a database query. When performing it, returns this error: ORA-01722: número inválido 01722. 00000 - "invalid number" *Cause: The specified number was invalid.…