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
answer1044
viewsORA-01722: invalid number
Help me with this error please, I wanted to understand why it is happening when trying to recover the ID of the enrollment field, when selecting the enrollment field in my select list in my form.…
-
-1
votes1
answer36
viewsUnrealized/ subquery failing
Using Sub-Query, make a query that returns the active materials, with the Description, Batch, Barcode Cod and Validity only of Dt Smaller validity of each Material. My code so far: select…
-
-1
votes1
answer56
viewsUpdate oracle via c#
I created a method that updates to oracle. However, it is absurdly slow when it does. When I do other operations like "INSERT and SELECT" in this same table, the response time is very fast. Could…
-
-1
votes1
answer57
viewsBring data regardless of the order of the numbers are found
Good afternoon! Can someone help me? I need to bring the data of a query (query) with the return as below, regardless of the order of the numbers are. I have a table of metrics, and this query is…
-
-1
votes1
answer119
viewsHow to get the table name of the first select Oracle?
I have the following oracle query: SELECT * FROM TABELA_PESSOA A WHERE A.CPF IN (SELECT B.CPF FROM TABELA_CONTA B WHERE B.CPF = A.CPF) I want to get the table name of the first select which is the:…
-
-1
votes1
answer55
viewsWhere to delete records that were entered a certain time ago
Help to create a delete with where if the record has been inserted for more than 5 minutes. I have the point marking table with the columns: cd_register - integer cd_enterprise - whole cd_matricula…
-
-1
votes1
answer335
viewsTime range between ORACLE SQL dates
Good afternoon guys, I have a question in oracle SQL in which to solve I wanted to get the following information: Before, I have this query: SELECT…
-
-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…
-
-1
votes1
answer68
viewsHow to insert the average of a table into another table?
I created this bank: create table aluno( codaluno int primary key, nome varchar(30), datanasc date); create table curso( codcurso int primary key, descricao_c varchar(200)); create table disciplina(…
-
-1
votes1
answer46
viewsTrigger to prevent repeated data on ORACLE
Opa personal I am trying to create a Trigger to prevent the entry of repeated data in Oracle but am not succeeding. You cannot use Constraint Unique, because I will have repeated data, because it is…
-
-1
votes0
answers12
viewsHow to make an oracle creation function to insert data into the table?
someone could give me a hint, as it transforms this function table Valued functions, from mssql, to oracle! Parameter entry is ini month, ini year, end month, end year And returns year, month and a…
-
-1
votes0
answers17
viewsPHP connection to ORACLE 12C database
I’m trying to make the connection to an ORACLE 12C database for some information query. My application runs on PHP 5.4 Debian Linux server. I tried various types of connections I found, but always…
-
-2
votes1
answer563
viewsJDBC Callablestatement: Application hangs when calling Procedure
When I run a Procedure by the application it hangs, but in the bank performs normal. This is the way I use to call Procedure: public int incluir(TOCompra compra) { try { PreparedStatement ps =…
-
-2
votes1
answer37
viewsI compile a package and give errors. Error location is wrong
After compiling a package, comes this error message: 249/36 PLS-00103: Encountered the Symbol "TS_ODO" when expecting one of the following: := . ( @ %; The Symbol ":=" was substituted for "TS_ODO"…
-
-2
votes1
answer29
viewsErasing OBJECT_TYPE from Oracle
Good afternoon. How do I pay for an OBJECT_TYPE from my OWNER? need to delete this object_type, because it is giving SYNON error
oracleasked 6 years, 7 months ago Leonardo Palmieri 71 -
-2
votes1
answer996
viewsAdd and split columns to oracle
I have 4 columns. I want to do the subtraction process in 3 and divide by the fourth. How do I do this operation in BD Oracle? COLUNA1 - COLUNA2 - COLUNA3 = RESULTADO; RESULTADO / COLUNA4 = COLUNA5…
-
-2
votes4
answers177
viewsCount(*) returning null
I have this query: SELECT COUNT(*) FROM USER_IND_COLUMNS WHERE TABLE_NAME = UPPER('TABLE') AND COLUMN_NAME IN (UPPER('ANO'),UPPER('MES'),UPPER('DIA'),UPPER('HORA')) GROUP BY INDEX_NAME HAVING…
-
-2
votes1
answer66
viewsDoubt with Concat on Oracle
I have a problem in exporting data to Excel, the number recorded in the database and very large generating several strange characters in the conversion that Excel tries to do, so I need to send it…
-
-2
votes1
answer529
viewsHow to create a table in Oracle using Foreign key
The situation is that I have a table called OS and I want to create a link from this OS table to the CLIENT using the CPF column as FK. Where I am missing? I am editing the databank straight from…
oracleasked 6 years, 3 months ago Alexandre Bezerra 1 -
-2
votes1
answer125
viewsDaily count - PL/SQL
Good morning! In the example sent we have a number of attendance, the date of arrival and the date of departure of the patient; and the daily count. In the daily count I am considering only the…
-
-2
votes1
answer134
viewsInsert with select if the field is null
I have today this INSERT in JAVA running but I need to implement a new routine: public void gravarLogAbonoUnificado(TbLogAbonClickUnic entity, RetornoAuxDto auxDto) { STRING SQL = "INSERT INTO" +…
-
-2
votes1
answer63
viewsHow to prevent the creation of records where one of the fields has the value already registered?
Create Table genero_filme( NomeF varchar2(30) NOT NULL, genero varchar2(20) NOT NULL, --Restrições de intregridade --1. Não existe gêneros diferentes com o mesmo nome Constraint fk_Filme_g FOREIGN…
-
-2
votes1
answer1337
viewsIs there a way to add column comments in the same command as create table from Oracle?
There is a way to add column comments in the same command as the oracle create table, just as it is possible in Mysql? CREATE TABLE user ( id number COMMENT 'unique ID ' )…
-
-2
votes1
answer307
viewsORA-00907: Missing right parenthesis, but why?
I was already having problems creating this table in relation to time, but finally, with help I managed to solve the problem. In the end I came across another mistake, but I don’t understand why.…
-
-2
votes1
answer370
viewsTest date field in Oracle query
need to ask a question, I am using this to_date shown below, for now we have no validation and sometimes the user puts the character (...) or other invalid character in the field date, breaking thus…
-
-2
votes1
answer31
viewsSQL - Set Timestamp in Select
How do I set the min("Timestamp") in a select and then return the last data where it is different from this min("Timestamp")? My Code: SELECT min("TIMESTAMP") AS PrimeiroLog, ID, UF FROM bd.test…
-
-2
votes1
answer228
viewsHow to view month and year only oracle sql
So I’m making a list of exercises, and in a given one, you ask me to make a query that returns the total value of a column, and that those values be grouped by month and year, but the date column…
-
-2
votes1
answer17
viewsStore as much data as I want in a tebela column in oracle Apex
I’m creating a page on Apex And I need to create a graph of the reasons that cause the most fines, but a fine can have several reasons. I’m not able to store these reasons so I can generate the…
-
-2
votes1
answer823
views -
-2
votes1
answer42
viewsCALCULATION TIME (SECONDS) BETWEEN TABLE FIELDS
good afternoon! I need to calculate the time in seconds of results from the same table/column, only different Status. SELECT e.nm_paciente, e.ds_idade, e.ds_sexo, e.NR_PRONTUARIO, e.DS_ANOS_MESES,…
-
-3
votes1
answer519
viewsHow to insert date and time in oracle? via c#
I’m developing a desktop application and everything was working fine until the time I tried to insert the date and time generated by C# into an oracle table. Can someone teach me the query to insert…
-
-3
votes2
answers59
viewsI’m a beginner in SQL. I need to build an Insert that will validate some fields of the source table and fill in the target table
I know the situation doesn’t make much sense, but the important thing for me is to understand how to "copy and paste" from one table to another according to one condition. The tables are as…
-
-4
votes1
answer102
viewsSQL tags in query
I am starting my studies in SQL and do not know what meaning of this structure below. I would like to know what are these tags. I am using in Java. I have a file mapper.xml to create queries in…
-
-5
votes2
answers870
viewsWhat are the differences between a PL/SQL programmer and an Oracle DBA?
Could someone explain to me the differences between the programmer PL/SQL and the DBA Oracle? I know there are many differences, but I’m not sure how to specify them. I have some doubts too... For…