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
-
3
votes1
answer62
viewsSelect max in nested queries
I have to select the candidate who has more publications than any other candidate. select candidato.nome, Count(1) as nr_publicacoes from candidato, cv,ficha_inscricao, publicacao_cv where…
-
3
votes0
answers57
viewsProcess does not start in Oracle BPM Composer 12c Player
I created a process using Oracle BPM Composer 12c, I am not able to start the Player to test the process before publishing in the domain. When I click on the Player button it generates the following…
oracleasked 9 years ago Rafael Genro 31 -
3
votes3
answers1231
viewsHow does the Oracle Express Edition database work?
I would like an explanation as to the operation of the database Express Edition made available by Oracle for students, because by the terminal I created a table and made an insertion and everything…
-
3
votes2
answers1464
viewsI cannot read the values returned from the database using Oracledatareader
I’m having trouble reading the values returned from a select, on the line where I do: OracleDataReader reader = cmd.ExecuteReader(); in the read it brings me the values correctly, but in the next…
-
3
votes1
answer3292
viewsMove text in pl/sql to uppercase
I have many create table scripts, Quence and etc, but everything is in lowercase, what the colleague did. Deleting line by line and capitalizing is unproductive as there are more than 1000 scripts…
-
3
votes1
answer128
viewsApplication stopping when there are many users accessing
My application is crashing and I don’t know exactly why. The only thing that repair is that when there are many users accessing, or making requests it happens. When it happens I have to restart the…
-
3
votes1
answer393
viewsSpool task for the server
Good night! Guys, currently in my job, I have to generate multiple files. txt to be exported to another company’s database. I roll it in my hand and it sucks, every day I spin it, I wait to send it…
-
3
votes1
answer7165
viewsConversion and Grouping of Rows into columns dynamically in Oracle
Context: I have a Project mixed Versions of apps that will be developed, each various Version New Feature Requirement (NF) means each NF with several Code changes in several Repositories. In…
-
3
votes1
answer132
viewsDate in odd fractional format 0.00xxxxxxx
I get that date from the comic book: 0.002976190476190476 I would like to move to this format: dd/mm/yyyy, using javascript pure or jquery. How I do? Here is the ASP that assembles the select:…
-
3
votes1
answer1693
viewsThe Provider is not compatible with the version of Oracle client
I need some help as I am trying to run a windows service in Visual Studio 2015, but cannot proceed due to error message "The Provider is not compatible with the version of Oracle client". Thank you.…
-
3
votes2
answers140
viewsIt is possible to save multiple values in a single database field
I declared the field in the database like this: descricao VARCHAR2(5)not null, It is possible, for example, to save 1,2,3,4 at once (a single record) in the field descricao, where each of these…
-
3
votes3
answers2181
views -
3
votes1
answer189
viewsODBC PHP / Oracle - UPDATE, INSERT, DELETE
I’m in a project using PHP and Oracle. the connection is OK, with this code I can run all the selects I need normally, what I can’t run are INSERTS, UPDATES and DELETE. Would anyone know why?…
-
3
votes1
answer674
viewsSP2-0552: Unstated Bind variable "19"
I am using Oracle SQL Developer to finish a project, when I was popular the database, the software accused an error in the following line: INSERT INTO musica (cod_musica, data_composicao, titulo,…
-
3
votes1
answer842
viewsBest way to structure history table with large amount of data
Functional requirement I own devices. Each device roughly has its unique identifier, an IP address, and a type. I have a routine of pings for every device that has an ip address. This routine is…
-
3
votes1
answer350
viewsChange Sequence value with subselect
I have the following case: I need to change the value of some sequences according to the max(id) of the table, I am trying to do something like: ALTER SEQUENCE CFOP_SEQ INCREMENT BY (SELECT…
-
3
votes1
answer101
viewsTree Page - Oracle Apex
I’m having trouble creating a tree page on oracle Apex. I created the page, but the Apex displays the results, but not grouped by the specified node. It is a paid bond ratio. I would like to create…
-
3
votes2
answers246
viewsDATES applied SQL Decode function
I have a question I need to make a select where I need to show if a client’s registration is active or not, in the database is treated as follows, has a field date of exit if the field is empty the…
-
3
votes0
answers143
viewsHow to fix intersection points to calculate the distance between points?
I need to calculate the distance between points within the place where I work, so I calculated the coordinates of each location in X and Y and I launched the coordinates into the system. I’m making…
oracleasked 8 years, 5 months ago Ariel Gonçalves 81 -
3
votes1
answer103
viewsDoubt in SQL ORACLE query
I am thinking of making a View for the development of reports, and I bumped into the following problem. I would like to join columns PUBLICO1, PUBLICO2, PUBLICO3, PUBLICO4 in a single column. Ex.:…
-
3
votes2
answers1159
viewsOracle reference the type of a column equal to the type of another column
I’m trying to create a table to return in a function. For this, I am trying to create a object type thus: create or replace type relatorio as object ( planta TABLE_NAME.COLUMN%TYPE, resp_0…
-
3
votes1
answer91
viewsPHP date_diff error
I am doing a test, with a query in Oracle database (recording sysdate, result: 13/09/2016 13:24:44) and returning me in PHP. I need to calculate the difference in hours and was trying the function…
-
3
votes2
answers249
viewsTranslation SQL Script for Oracle
I have the script below in SQL Server, but I need to mount it in Oracle. I don’t know anything about Oracle and I couldn’t make it work. Could you help me? Oracle: 11.2.0.4.0 SQL script: DECLARE…
-
3
votes1
answer1479
viewsQuery with random result
I have the query below, used in an internal routine, for distribution of items for separation in data collectors: Select distinct IP, USUARIO, DATA from PCN_ROMANEIO_ACESSO PRA Where pra.STATUS =…
-
3
votes1
answer467
viewsSQL/ORACLE Filter active records in the month
I have a table that records my records where a column records the data_inicial and another column to data_final. I need to generate a report where the user searches all records that were between the…
-
3
votes1
answer1199
viewsSelect and do not return values containing xxx
I’m making the following select: SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME; In this I have the name of the tables, the problem is that for each table I have a table_AUD, ex: PESSOA…
-
3
votes2
answers37
viewsWhy does To_char(3E4) not result in '3E4'?
Guys like me convert an exponential number (NUMBER) to string (VARCHAR) but it is expressed equal?? Example: SQL> SELECT TO_CHAR (NUMERO) NUMCONVERT 2 FROM (SELECT 3E4 NUMERO FROM DUAL);…
-
3
votes1
answer6191
viewsSum of hour+minute oracle/sql
Good afternoon, I have a table that stores times (hour:minute), I would need to group by date and add these intervals, for example day 01/03/2017 I have 04:35 of duration time. I tried a lot of…
-
3
votes1
answer1901
viewsBackup oracle tables 11g
Use oracle 11g in the free version. According to the database lessons with oracle, the free version does not allow creating database. One can create user and create tables. Based on this, how do I…
-
3
votes1
answer93
viewsGroup SQL queries
I have these queries below, independent, and I’m having difficulty grouping them a same query result, IE, leave the 6 columns requested by select in the same consultation. SELECT codigo_processo…
-
3
votes0
answers195
viewsPHP with PDO returning BLOB records with foreach
Good afternoon guys, I’m new here (first question), but Stack has already helped me in several situations. That’s the problem: I am developing an application and on a given page there is a user…
-
3
votes1
answer3140
viewsHow to convert this date to datetime in oracle?
Correct way to convert the date '27/12/2016 16:31:39,137000000' for datetime(timestamp(6)) in the oracle? Some unsuccessful attempts that result in error ORA-01821: formato de data não reconhecido…
-
3
votes1
answer258
viewsWhy using a column of a virtual table makes an SQL in Oracle slow
Good. Without wanting to leave the subject too "gassy" but wanted only tips of things to investigate in the environment. I have an SQL that uses a virtual table, for a number of reasons that are not…
-
3
votes1
answer12023
viewsInsert TIME DATE on Oracle
I have the following information INSERT INTO tabela (codigo, datahora ) VALUES (1, NVL('',TO_DATE('19/07/2017 19:49:00', 'DD/MM/YYYY HH24:MI:SS'))) Why NVL? Because if it has no valid value for…
oracleasked 7 years, 4 months ago adventistaam 3,354 -
3
votes1
answer883
viewsMultiple results in a single record - Oracle
I have the following situation: I have a select where I return that the patient TEST passed the clinic ABC, and performed procedure 01 and 02, however in the result of query he returns to me like…
-
3
votes1
answer2389
viewsThe result of the string concatenation is too long
I made a select with the function LISTAGG to concatenate a field of my table, however the error is returned: ORA-01489: the result of string concatenation is too long Query (SELECT LISTAGG…
-
3
votes1
answer1116
viewsRead a DBMS Procedure in ADVPL
It is possible to read a DBMS Procedure in ADVPL (TOTVS language) treating the return of a Cursor ? Is there any object ? The bank in question is Oracle. create or replace PACKAGE abc IS TYPE…
-
3
votes1
answer845
viewsEntity Framework with Oracle
I am trying to use EF, using Code Frist, along with an Oracle database, for this I am using the Nuget package Oracle.ManagedDataAccess.Entityframework, but whenever I try to run the Update-Database…
-
3
votes1
answer479
viewsSelect Like in Oracle
I’m developing a routine to standardize the descriptions in an Oracle database. So I’m scanning the entire database where I select the description, extract it word for word and compare it to a…
-
3
votes2
answers932
viewsGROUP BY SQL error
I have the following exercise: List the department code and name, newest and oldest admission date of each department, sort by department name. Here’s what I did: select d.department_id,…
-
3
votes1
answer345
viewsSelect cities with the same name in different states
I have the table (result of a query) with the cities and their respective state... ... now only display cities with equal names and different states: How do I command?…
-
3
votes1
answer5770
viewsWhat is the logic behind the trunc function?
What does the trunc to be sure and what other uses may have taking this example?…
-
3
votes2
answers754
viewsMethod that uses a random value as parameter to swap the characters of a string
I have this code that’s working perfectly, but I need random values to appear instead of the X. I want the returned result to be composed of random letters and the position of upper and lower case…
-
3
votes1
answer278
viewsDecode vs Case Query
We have two ways to work with condition within consultations in Oracle SQL, are they the Case and the Decode, the two have the same function. Allow dynamically and practice how to get a return from…
-
3
votes1
answer2370
viewsMy dbms output is not displayed
I’m testing a simple exit from DBMS in Sqldeveloper. I created the connection, ran the set serveroutput on to enable the exits DBMS, but when I run my anonymous code pad, on Saída do Script he…
-
3
votes2
answers2545
viewsORA-00907: right parenthesis not found
Hello, I’ve been working with oracle for a little while, and I’m having this problem in the query, returns me the error: ORA-00907: right parenthesis not found, follows below the same: ("""select…
-
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?…
-
3
votes4
answers3251
viewsSelect first name? - Select in bank
I have a table with the following names: João Goldy Alfredo, Gaby, João Antônio, Rodrigo, Maria Aparecida, Mario How can I get only their first name, and those who don’t have a last name, should…
-
3
votes2
answers1861
viewsHow to consult birthday and month in SQL on Oracle?
I saw some examples here, and tried to reproduce them, however, on Oracle does not accept operators as MONTH, then I was unsuccessful. SELECT nome from aluno where month(datanascimento) =…
-
3
votes1
answer51
viewsSQL script, to insert emails into a table, and then change them
I have a script, which does random insertions of emails into a table, after these insertions, I need to find a way to recheck these inserted emails, and change them This is a part of the Script, I…