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
votes1
answer551
viewsIn PL-SQL how to partially add a value?
I have to add the value partially the values of a category (goes the code below) DECLARE --VARAVEIS CURSOR CPRODUTO IS SELECT * FROM PRODUTO_TESTE2; VPRODUTO PRODUTO_TESTE2%ROWTYPE; Vsoma real;…
-
0
votes0
answers294
viewsError while displaying message in PL-SQL
Code DECLARE BEGIN FOR I IN (SELECT * FROM PRODUTOS_TESTE2) LOOP DBMS_OUTPUT.PUT_LINE(I.codigo|| ' - ' || I.categoria || ' - ' || I.VALOR); END LOOP; END; Error message: Relatório de erros -…
-
0
votes0
answers684
viewsOracle error ora-06550 pls-00103:
I have this PL-SQL code: /*1. Criar um bloco PL/SQL anônimo para imprimir a tabuada abaixo:*/ DECLARE VN CONSTANT NUMBER(2) := 5; BEGIN FOR i IN 1..1O LOOP DBMS_OUTPUT.PUT_(VN || ' X ' || i ||'='||…
-
0
votes1
answer179
viewsExample login with Oracle php
I’m having a hard time creating a login form using BD Oracle , in Mysql and Postgresql works perfectly , I’m trying to use oci_num_rows <=0 , but the variable returns error , saying that Oracle…
-
0
votes1
answer254
viewsInsert using parameters in the C# application for the Oracle database error: ORA-01036: invalid variable name/number
I noticed that there are many questions about this error but none solved my case the connection works normally, there is the Insert method(): public bool Insert(ArrayList arrAlunos) { vsql = "insert…
-
0
votes2
answers358
viewsTrigger to Retrieve Last Record Inserted in PL-SQL Table
I have a Rigger that after being inserted a new user in the table tFunctioning I must fill another table tPlanoSaude with the data of the employee. employee table table Health Plan Code of the…
-
0
votes1
answer407
viewsError generating PLSQL file on oracle!
Code CREATE OR REPLACE PROCEDURE CRIARARQUIVOTXT AS Arquivo_saida UTL_File.File_Type; Dir_Arq VARCHAR2(60); Cursor cur_arq is Select f.NOME from tfuncionario f; BEGIN -- Diretorio do Arquivo Dir_Arq…
-
0
votes1
answer75
viewsError while creating a PROCEDURE
I’m creating a database to insert data into a table in the database, but this gives an error that I can’t identify: Commando: begin INCLUIR_CLIENTE(1, 'SUPERMERCADO XYZ', '12345', NULL, 150000);…
-
0
votes1
answer37
viewsI cannot put result in SQL table
I want to put the result of this equation there where is 'RESULT1' I tried to do result1 = x But it didn’t work, I have little experience with SQL yet; SELECT (VA * VB) / VC FROM (SELECT 5 AS VA, 10…
oracleasked 6 years, 9 months ago Pedro Alencar 89 -
0
votes0
answers51
views -
0
votes2
answers39
viewsHow to insert for all users in PLSQL when there is no data?
Good afternoon! I’m trying to insert to all users when there is no type entered for all users: INSERT INTO USUARIO ( TIPO, PRIORITARIO) SELECT '130', 'N' FROM dual WHERE not exists (SELECT * FROM…
-
0
votes1
answer60
viewsReset sequence every year
I am creating an identifier that has the following formatting sequence/ano, for this reason I need my Quence count to 1, again, whenever there is a turn of the year. Is there any way to do this…
-
0
votes2
answers6870
viewsFatal error: Call to Undefined Function oci_connect()
Error connecting to Oracle database. Below is the code in PHP: <?php $ora_bd = "(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP) (HOST=192.168.0.249)(PORT=1521) ) )…
-
0
votes1
answer2819
viewsOracle - How to generate every day (Calendar) between two Dates with different Years (*No Support Table)
How to generate the interval of all days of the months between two dates? Considering only the parameters: Starting Date: 01/10/2014 End Date: 12/29/2018 Example: 01/01/2014 02/01/2014 03/01/2014…
oracleasked 6 years, 5 months ago AndyDaSilva52 11 -
0
votes1
answer1116
viewsConnect Entityframeworkcore with Oracle database
Good morning guys, I’m starting my studies with Entityframeworkcore and I noticed that it only communicates well with Sqlserver, someone knows some plugin or something like that that make this…
-
0
votes2
answers5935
viewsIs there any clause similar to LIMIT in PL/SQL
I am using PL/SQL and would like to know if you have any clause or sql script that is similar to sql LIMIT clause, I’ve been searching here and found rownum < = X , but does not meet what I want…
-
0
votes1
answer593
viewsField as parameter in Generic Update - ORACLE
Currently I have a precedent that reads an XML, and updates the table fields personal based on the values sent by XML, such as CPF, RG, Name, etc. Today I read the XML values and insert in the table…
-
0
votes1
answer339
viewsOracle - DBMS_APPLICATION_INFO.set_client_info - What is and when to use
About the line below in a PL/SQL script DBMS_APPLICATION_INFO.set_client_info('1111@Blabla'); I get it which is a package calling a trial and that it arrow customer information in the session (in my…
-
0
votes1
answer724
viewsBatch with parameters in Sqlplus
Hello, I need to create a batch file that drops the database user, recreates and imports the database with an existing backup. I have already created a routine that drops in the user and recreates…
-
0
votes1
answer225
viewsOracle - Cursor
I’m studying PL/SQL and testing the use of CURSOR, but I’m not able to test an example: SET SERVEROUTPUT ON DECLARE V_NAME VARCHAR2(50); CURSOR CUR_CURSOR IS SELECT FIRST_NAME FROM EMPLOYEES; TEMP…
-
0
votes1
answer340
viewsHow to compare two Oracle Datetime columns
I have a column where I enter a date when the event happens (local storage), and the date when the event is sent to my system. The difference between the date of the event and the date of dispatch…
-
0
votes1
answer107
viewsError trying to access JAVA WEB database
When I run the program the following error: HTTP Status 500 error - Internal Server Error. java.lang.Runtimeexception: java.sql.Sqlexception: No suitable driver found for…
-
0
votes1
answer291
viewsCreate an Oracle Agent/Job for Postgresql
I wonder if it is possible to create an agent/job in Oracle to query the data of a given table and insert the data from this table to another table that is in Postgresql. Or if I can through…
-
0
votes0
answers411
viewsConversion error in oracle
I have a problem: when I run a function no problem occurs but when running in the php, this error occurs: ORA-06502: PL/SQL: Numeric or value error: Character to number Conversion error the problem…
-
0
votes0
answers198
viewsSpring Boot query does not return records
I am developing a system with Java 8 and Spring Boot with JDBC accessing an Oracle base. When I do a query, using Namedparameterjdbctemplate, it does not return any record, but if I copy this same…
-
0
votes1
answer928
viewsListener refused the Connection with the following error: ORA-1251 JAVA ORACLE
Hello, I’m having an error when I try to connect to an oracle bank. someone I was able to help. code private static Connection ObterConexao() { Connection conexao = null; try {…
-
0
votes1
answer1219
viewsI need explanations of OUT mode and INOUT PL/SQL and Mysql Procedure
Well, I put PL/SQL and mysql because these two modes have in the procedures both Oracle and mysql but anyway.. The IN mode I understood that it works as a Constant, it is passed by the parameter and…
-
0
votes0
answers44
viewsUnknown date format on Oracle
Good morning. I have to access the data in an Oracle database, where a field described as "validation date" has the following data: DtValid ------- 115365 115364 115363 115362 115361 Does anyone…
-
0
votes0
answers87
viewsPL/SQL - how to see the amount of lines manipulated through a Rigger?
I already tried with the sql%rowcount but when it’s a Rigger it just doesn’t work.. how can I return the number of lines manipulated in a DML instruction from a Trigger?
-
0
votes2
answers512
viewsSelect/Where with parameter does not work on Oracle
I am making a select with Where via PHP and Oracle, when it receives an error by the parameter occurs: Warning: oci_execute(): ORA-00911: invalid Character in C: xampp htdocs project includes…
-
0
votes1
answer55
views -
0
votes0
answers221
viewsI’m having trouble connecting the codeigniter on oracle
I’m having two problems configuring the connection with oracle. A PHP Error was encountered Severity: Notice Message: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed…
-
0
votes1
answer130
viewsPercentage in SQL
I have the following consultation code: SELECT AC.DT_AGENDA AS DATA, ME.DS_MULTI_EMPRESA AS EMPRESA, AC.CD_UNIDADE_ATENDIMENTO AS CD_UNID_ATENDIMENTO, UA.DS_UNIDADE_ATENDIMENTO AS…
-
0
votes1
answer70
viewsORACLE USERS
Good afternoon. I have two Owners on my oracle example Owner "X" and other Owner "Y". Where each has its own tables, but I want Owner "X" to be able to update, Insert and delete some Owner "Y"…
-
0
votes0
answers42
viewsTO_TIMESTAMP in Oracle Packages
I was doing some maintenance on object database oracle 11g, but in the middle of this adventure I ended up compiling and recompiling versions that gave error. I wonder if there is any way to perform…
-
0
votes1
answer49
viewsColumn that receives a result if the condition is true
SELECT DISTINCT P.CD_PACIENTE , P.NM_PACIENTE , DECODE (P.TP_SEXO, 'M', 'MASCULINO', 'F', 'FEMININO', 'I', 'INDEFINIDO') SEXO , TRUNC(P.DT_NASCIMENTO) DT_NASCIMENTO , (SELECT FN_IDADE…
-
0
votes2
answers136
viewsReplace a fixed CASE value with a SELECT and JOIN?
SELECT DISTINCT P.CD_PACIENTE , P.NM_PACIENTE , DECODE (P.TP_SEXO, 'M', 'MASCULINO', 'F', 'FEMININO', 'I', 'INDEFINIDO') SEXO , TRUNC(P.DT_NASCIMENTO) DT_NASCIMENTO , (SELECT FN_IDADE…
-
0
votes1
answer503
viewsRun stored Procedure in oracle database in PHP
I have the procedure "exemplo1" which receives 3 input parameters and no output parameters, as I do to execute it in PHP. In case it would be so. EXEC "exemplo1"('para1','para1','para3'); How does…
php oracle stored-procedures php-7 oracle11gasked 6 years, 2 months ago Maicon Fernando Stefene da Sil 141 -
0
votes1
answer1184
viewsPLSQL resume error while retrieving data from Database
I try to extract data from the database and insert it into a record and then show it in the cmd, But when I get a higher registration number the procedure requires an error message. Code: SET…
-
0
votes1
answer156
viewsHow to create a Registry vector in PLSQL
I have a record of TYPE trec IS RECORD ( cd_multi_empresa NUMBER(8,2), tp_atendimento CHAR(2) ); vcAtendimento trec; I need a registry vector, I used this and command: TYPE TcAtendimento IS…
-
0
votes1
answer436
viewsPLSQL shows error: PLS-00487: Invalid reference to Variabel
I have a PLSQL code: in which I receive two values one numerical and another varchar. Code: create or replace FUNCTION hospitalTeste123(MatriculaMedico in number, nomeSchema in varchar2 ) return…
-
0
votes1
answer161
viewsLISTAGG returning repeated values
Hello, everybody. Good afternoon. I have a query that concatenated several record using a certain key. However it brings some repeated values as a result. Below an example of a query: SELECT PEH.PN,…
-
0
votes1
answer25
viewsSubselect Orderby first line
I’m doing the select below but in the last subselect (Mileage) I’m having problems with the ORDER BY "ORA-00907: Missing right parenthesis" error, if I remove the ORDER BY it works. SELECT /* DATE…
-
0
votes1
answer45
viewsselect picking up the items that are in the current day and time
I want to take items that are less than the current date and time, but when I run select from the error message, not a Valid Month. In the database the date is set as follows, '25/09/18 10:23'.…
-
0
votes2
answers391
viewsBring the second and third line of a query
Oracle-SQL I have a chart that records the time records that each employee makes. The table contains the following information: (TABELA QUE ESTOU FAZENDO A CONSULTA) Contrato | Data | Hora 1 |…
-
0
votes1
answer173
viewsUse variable in a run
I’m creating the pl sequinte: declare cont integer; tabela varchar2(100) := 'TABLE_TESTE'; col varchar2(100) := 'TESTE'; begin SELECT COUNT(*) into cont FROM USER_TAB_COLUMNS WHERE TABLE_NAME =…
-
0
votes1
answer733
viewsHow to update a View?
I have a table where you store trucks in and out. In this table there are two fields of the type Date, I want to update the data of these fields. I’m using the select below. UPDATE…
-
0
votes0
answers70
viewsORACLE SQL - Complex Report
Good morning, I need to take a report that is not made available by the system, working with the invoices table. In this table there is the customer data, consumer unit and the debit value. It turns…
-
0
votes0
answers237
viewsOracle 11G XE change size tablespace system
I have following script: DECLARE countTablespaceFile integer; BEGIN SELECT count(*) INTO countTablespaceFile FROM DBA_DATA_FILES where file_name in ('/oracle/bdond/cbiep01/bdrgt/system01.dbf',…
-
0
votes1
answer283
viewsWork with BLOB field on ORACLE using Codeigniter
I have a system where will store certain files in a BLOB type column in my ORACLE database, but I did not find anything about it in the documentation of Codeigniter itself of how to do this, how can…