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
answer59
viewsError executing Oracle command
Everybody, good afternoon, everybody, I’m having trouble calling a function in Oracle... This is the function: function mataSessao(){ $connect = oci_connect('xxxx','xxxx','xxxxx','xxxxx'); $IDSESSAO…
-
1
votes2
answers3456
viewsGrant for several Oracle tables
I need to create a database user, where he can have permission from all DML, but when creating Grant I have to specify table by table, there is some way to give permission to the whole database,…
-
1
votes1
answer38
viewsHow to change a table indicating that data from a certain field can only vary from date 1 to date 2?
I have a table called "LOC_VEICULO" where the vehicle data are contained. I have the following field: DT_FABRICACAO (DATE), where the dates of manufacture of vehicles are stored. I need to change…
-
1
votes1
answer321
viewsproblems to create multiple tables in Oracle
I am beginner in the use of Oracle, wore the firebird before. I’d like to know, why I can’t create multiple tables at once in the SQLdeveloper. It creates only the first table (Country). I try to…
-
1
votes1
answer76
viewsQuery Rows having Maximum value in a column
I have a problem with a query on a bench Oracle in a table with 3 columns: Id_loja | Canal | Valor_venda There is the possibility of having more than one sale per store and I want to know which…
-
1
votes2
answers13323
viewsHow to add foreign key with Constraint and alter table in Oracle?
I have the following tables : Create table OS( nro_os number(4), data_os date , hora_os number(4) ); Create table cliente( cod_cliente number(4), nome_cliente varchar(12), endereco_cliente…
-
1
votes1
answer793
viewsReturn Oracle Timestamp
I want to convert a date to a number, a timestamp. Within a select I need to return beyond the date her timestamp. Example of consultation: Select sysdate, TIMESTAMP_DE_SYSDATE from dual Timestamp…
-
1
votes1
answer96
viewsOracle , parameters of procedures of an Owner
On Oracle which table or view of metadata I have the parameters of a Procedure. My question is , that procedures HAS parameters with the name similar to "XPTO" ? I tried for the "Dict" but I…
-
1
votes2
answers1117
viewsChange oracle characterset 11g
When performing a dump file import, oracle is returning me the following messages: IMP-00019: rejected line due to ORACLE 12899 error IMP-00003: Oracle error: 12899 found ORA-12899: very large value…
-
1
votes2
answers161
viewsOracle DB and MVC 4 showing ORA-06413 error
I’m having a problem very similar to this one. To summarize, I have an application that runs with ASP.NET MVC 4, using . NET Framework 4.0, using the same DLL of access to Oracle,…
-
1
votes1
answer3824
viewsPL/SQL - Incorrect number of argument types in the call
I’m having trouble with a simple function I created. create or replace FUNCTION dry_login ( username IN VARCHAR2, password IN VARCHAR2 ) RETURN BOOLEAN IS l_user varchar2(70); l_pwd varchar2(70);…
-
1
votes1
answer401
viewsName of Uppercase Columns with Codeigniter and Postgreesql
I am developing a WEB system using Codeigniter with support for Oracle database and Postgresql. In my queries, I use Codeigniter’s own Query Builder. Simple example of Select: SELECT "ID", "NOME"…
-
1
votes0
answers708
viewsHow to send the result of a query via email
I wonder if anyone could tell me how I can perform the below query correctly. I need this to be sent to the email showing the result that in the case would be Name : Ariel [select rtstr1 as hostname…
-
1
votes1
answer3155
viewsHow to solve the ORA-01795 (maximum number of expressions) error in Codeigniter
I am developing a report in Codeigniter, but my select contains a filter that can have more than 1000 expressions in my where_in and then it returns me the error: ORA-01795: o número máximo de…
-
1
votes0
answers1438
viewsjava.sql.Sqlexception: ORA-01000: maximum open cursors exceeded
I’m making the following mistake: java.sql.Sqlexception: ORA-01000: maximum open cursors exceeded From what I researched, the error happens when the maximum number of cursors is exceeded, and to…
-
1
votes3
answers124
viewsUpdate to CD_SETOR column values in all tables found with column
Using the select SELECT * FROM DBA_TAB_COLUMNS WHERE column_name like 'CD_SETOR' i have as a result many tables with different Owner with the same CD_SETOR. EX: Owner Tables Column Type 210…
-
1
votes1
answer159
viewsUpdate warn change
You can tell if a value has been changed in a direct table in the application? Like I gave a UPDATE tabela SET valor = 1 WHERE id = 2; And in the application appear the message: O Valor foi alterado…
-
1
votes1
answer463
viewsCreate 90-day filter before a period
I need you to bring back the results that completed 90 days within an informed period. For example, I have the ability to do: DT_INICIO_REAL <= (sysdate-90), I will have as a result 90 days from…
-
1
votes1
answer28
viewsDoubt regarding the IN in Oracle
I’m putting together a query and bumped into a question. My query is like this: SELECT BASI_030.NIVEL_ESTRUTURA NIVEL, BASI_030.REFERENCIA GRUPO, BASI_030.DESCR_REFERENCIA, BASI_030.CONTA_ESTOQUE,…
-
1
votes1
answer1279
viewsSqlexception: ORA-00257: Archiver error. Connect Internal only, until Freed
Have an Oracle database connection that makes a simple entry into the database. The process was working, but now this presenting the error below. 2017-07-13 14:25:55.929 ERROR 12062 ---…
-
1
votes1
answer6120
viewsRun script file directly in PLSQL
I have a arquivo.sql, which has thousands of lines of scripts, containing, creations, changes, etc. I need to run this file directly in PLSQL at SQL Window, and nay can be via Command Window. Via…
-
1
votes2
answers579
viewsPermissions for an Oracle USER
I am creating an Oracle user for my database, after setting the basics I tried to run my script to create the tabelas and sequences, however, the tool returned me an error saying missing…
-
1
votes2
answers398
viewsWhat is the best way to authenticate in the database?
What is the best way to connect to the database using c#? Create a USUARIOS table, or create a USER in the database to access?
-
1
votes1
answer127
viewsConstrait Oracle Garden
I have a question, when I create a CONSTRAINT UNIQUE , she measures all the columns together? For example, I want a country not to have names or acronyms equal, in which case I must create…
-
1
votes3
answers671
viewsSelect that respects all values in a list
I need to set up a very simple select, but I’m having a hard time. SELECT SEQPRODUTO FROM MRL_PRODUTOEMPRESA WHERE STATUSCOMPRA = 'I' AND NROEMPRESA IN (1,2,3,4,5,6,7,8,9,11,13,14) I need to select…
-
1
votes2
answers245
viewsorder by in oracle subquerys
RESOLVED I solved as follows, I created a view equal to my table of service orders more that was ordered by the team and by the priority, and then I kept the query above by only changing the table…
-
1
votes1
answer49
viewsWrong update on Trigger on Oracle
I have the following problem at Trigger, When there is an INSERT in table TB_DJE_PREPUBLICACAO, it has to be checked if the column DT_DISPONIBILIZACAO is null, if it is and if the column…
-
1
votes1
answer329
viewsOracle - Error connecting with Adoconnection Delphi 10.1 (Berlin)
I have an app that works on Delphi XE2 using the database connection component Adoconnection. When I migrated to the Delphi 10.1 (Berlin), no error. Connection exists, but does not connect, and…
-
1
votes1
answer139
viewsCall Procedure with Oracle return in Codeigniter
I am developing a system and in a part of the code, I need to call a precedent and it returns me a value. How can I do that? For now I did so and it didn’t work: $sql = "CALL P_VERIFICA_VALORES(" .…
-
1
votes1
answer928
viewsHow to set Foreign key in oracle SQL Speed?
I am new using this program, as defined Foreign key in oracle SQL?…
-
1
votes1
answer394
viewsError in query INSERT INTO
I’m new using Oracle SQL Developer and I’m trying to make the query run but this appearing error, see photo.…
-
1
votes1
answer2504
viewsRemove Oracle Single Quotes
How do I remove simple quotes from a string in the Oracle database? If I do Replace(teste, ''', '') doesn’t work.
oracleasked 6 years, 11 months ago Stand Alone 350 -
1
votes1
answer3935
viewsORA-01704: too long string literal
I have a CLOB type field in the BD, but when I give an INSERT it returns me an error saying that exceeded the field size that is 4000 characters. Relatório de erros - Erro de SQL: ORA-01704: literal…
-
1
votes1
answer115
viewsInsert Cities in Oracle Bank
Someone would have a query to insert in the Oracle database all Brazilian cities with accentuation and cedilla in the words? I’m trying to find some on the internet, but all use Internet of multiple…
oracleasked 6 years, 11 months ago Gabriel Souza 25 -
1
votes1
answer419
viewsDate to oracle conversion
I’m having a problem, I’m trying to save a date on oracle with formatted dd/MM/yyyy, however, in the bank it presents the date in the format dd/MM/yy. So, I got the question, if the type I used in…
-
1
votes1
answer2740
viewsHow to use LIKE with OR on Oracle?
I have the following table: CREATE TABLE DEPENDENTE ( IdDependente number(6), Matricula number(6), Nome char(50) NOT NULL, dtNascimento date, constraint pk_IdDependente PRIMARY KEY(IdDependente),…
-
1
votes1
answer1091
viewsPerforming UPDATE on ORACLE using FROM
How to do UPDATE in Oracle records without using a clause IN to change data in bulk? Thus: UPDATE TABELA1 SET DADO = DADO FROM TABELA2 WHERE TABELA1.CODIGO = TABELA2.CODIGO; Currently he me force to…
-
1
votes1
answer966
viewsConvert input to date with oracle
I’m having trouble returning the results of the following query, where I put the variable &mes, if I put '01-Sep-2017' would bring the results I need, but in the dialog box wanted the user to…
-
1
votes1
answer503
viewsCall Oracle function in Laravel?
I did all the configuration to connect on Oracle, it connects, but I want to make a query within a function, but it is giving the following error message: Queryexception in Connection.php line 729:…
-
1
votes1
answer150
viewsInsert data into Oracle table "no returning id into"?
I’m using Laravel 5.2 and when I have enter data he wants to return the last, but at the moment I want to enter and know if the operation was successful. My role in the controller is like this:…
-
1
votes1
answer378
viewsError creating file in oracle
When declaring the name of a trial in sqldevelope get that message Erro: ORA-00972: identifier is too long Example of nomenclature: PRC_IMVW_TISS_VERIFICA_ELEGIBILIDADE CREATE OR REPLACE PROCEDURE…
-
1
votes1
answer72
viewsError running Function in PL/SQL
Code CREATE OR REPLACE FUNCTION BuscaNome RETURN t_name IS t_name VARCHAR(20); BEGIN SELECT T.DS_TURMA INTO t_name FROM TURMA T WHERE T.CD_TURMA = 13; RETURN t_name; END; Error: Error: PL/SQL:…
-
1
votes1
answer657
viewsproblem when changing PHP environment variable
I installed php via xampp and need to change this variable: NSL_LANG. I created a php file with this code: <?php putenv("NLS_LANG=BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252") or die("Falha ao…
-
1
votes1
answer678
viewsHow to create a Foreign key and Unique attribute at the same time?
I would like to know whether there is any way, or how best, of restricting a relationship between two entities, one of which cannot be repeated in this relationship. I have the tables 'Customers'…
-
1
votes1
answer574
viewsDropper my schema tables on Oracle
I am using a Schema in Oracle (sql Developer) and within my schema there are already several tables created that I was using earlier. Now running a new script in this scheme it shows the following…
-
1
votes1
answer30
viewsBring descriptive information from a PHP sequence
I have a form, one of the fields is a dropdown that consults and brings the results as below: <select name="convenio" id="convenio" class="input" style="width:260px"> <option…
-
1
votes0
answers341
viewsPL/SQL - Trigger: Can I see the whole line updated in a line after Rigger?
I am studying PL/SQL in college and the teacher passed some questions based on the Human Resources model of Oraclexe itself. The question I’m asking asks a Rigger to prevent an employee from earning…
-
1
votes1
answer1015
viewsSelect two tables with different columns in ORACLE
I have three tables, one call ALUNO, a callMATRICULA and another call CLASSE and I need to select all students who are male and who belong to the same class as a student who has a specific RGM. The…
-
1
votes1
answer949
viewsData being repeated when using INNER JOIN on Oracle
I have three tables, which are the following : ALUNO,CLASSE and MATRICULA. PUPIL NR_RGM NM_NOME NM_PAI NM_MAE DT_NASCIMENTO ID_SEXO CLASS CD_CLASSE NR_ANOLETIVO CD_ESCOLA CD_GRAU NR_SERIE TURMA…
-
1
votes1
answer193
viewsDeserialize Image in ASP.NET Webform
Well I am with a doubt about the deserialization of an image in webforms, I am working with Oracle database that is my context and using the Entity framework for image I am using BLOB, I was able to…