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
votes3
answers8406
viewsORA-01036: illegal variable name/number
I’m having a little problem in my application. The routine of INSERT causes me to make a mistake: ORA-01036: illegal variable name/number Remembering that the database is Oracle and the application…
-
1
votes1
answer157
viewsHow to get the records found and not found via IN
I have a simple command SELECT MATRICULA FROM ALUNOS WHERE ID_ALUNO IN (1,2,3,4,5,6) I would like to know how to get via SQL a result like this: ID| STUDENT 1 | LUIZ 2 | MARIA 3 | 4 | JOÃO 5 |…
-
1
votes2
answers714
viewsMultiple Schemas on an Oracle Owner
Hello, I have a question for a while and can’t find a definitive answer: I may have several schemas on an oracle Owner? Ex.: Owner: Renan Schemas: Indicators Alert Etc. Tables:…
oracleasked 9 years, 8 months ago Renan Rigo Calesso 33 -
1
votes1
answer92
viewsHow to fetch data from an Oracle sys_refcursor via PHP?
I have a Package with a function where the return of it is a sys_refcursor: FUNCTION getConfigPlaca(placa_aux VARCHAR2) RETURN sys_refcursor; If I consult this function with a "from dual" I get:…
-
1
votes1
answer1009
viewsHow to make an x64 application connect to a 32bit ODBC driver?
I have an x64 application written in C# with .Net Framework 4 you need to connect to the Microsoft ODBC for Oracle driver. When using this driver with the application in x86 mode, this connection…
-
1
votes1
answer4703
viewsConversion is not valid
public int ObterTotalAcessos() { int obtertotal = 0; using (var connection = ServiceLocator.ObterConexao()) { var command = connection.CreateCommand(); command.CommandText = "SELECT SUM (ACESSOS)…
-
1
votes1
answer9353
viewsORA-12154 TNS: could not resolve the connect Identifier specified
I’m having trouble when an application tries to connect with the database, I get error ORA-12154 TNS: could not resolve the connect Identifier specified. When I give a tnsping or try to connect by…
-
1
votes1
answer238
viewsProcedure with out parameter (SYSREFCURSOR) with Entity Framework
I am having a problem that is keeping me awake. I am making a database migration, from SQL Server to Oracle, in a C#application. The application mentioned is using Entity Framework to perform…
-
1
votes1
answer110
viewsJava project with Oracle and Mysql at the same time?
In view of an Oracle BD and a Mysql BD, and the impossibility of integration of both bases: It would be possible, for example, a class of my application to 'look' at the mysql table and update an…
-
1
votes1
answer177
viewsSQL: Can I have clauses in Groupby that don’t appear in Select?
I know I can’t have clauses in select that don’t appear in Group By. But is it possible otherwise? For example: Select B From Table Group By A,B
-
1
votes0
answers717
viewsOracle Data Modeler - Connect to Mysql Database
Hello! I’m having problems about two days ago about how to connect the ODM ( Oracle Data Modeler) to a mysql database. The process in all the locations I found consists of: -Start Oracle Data…
-
1
votes1
answer94
viewsCheck if CONSTANT exists in Package
I have a Package: CREATE OR REPLACE PACKAGE LETRAS AS possuiA CONSTANT BOOLEAN NOT NULL := TRUE; possuiB CONSTANT BOOLEAN NOT NULL := TRUE; possuiC CONSTANT BOOLEAN NOT NULL := TRUE; possuiD…
-
1
votes4
answers1852
viewsOracle11g - Problems SELECT command
I’m making the following mistake: java.sql.Sqlsyntaxerrorexception: ORA-00933: SQL command not properly ended This happens after I run the following line from SQL: /* Listar todas as reuniões do…
-
1
votes1
answer324
viewsError of consultation per month
I need to let the user choose the month to calculate the ESTDIA. In red and bold line. When I leave the :MES and executes the error and leave already set example V.OUTUBRO the SELECT wheel…
-
1
votes1
answer138
viewsQUERY SELECT (oracle sqldeveloper)
Have the query below. SELECT 'A. ABERTOS' QUANTIDADE, (SELECT SUM(S) FROM (SELECT COUNT(*) S FROM VW_SOLICITACAO_DETALHE VW INNER JOIN SOLICITACAO SOL ON SOL.ID_SOLICITACAO = VW.ID_SOLICITACAO WHERE…
-
1
votes2
answers1664
viewsUTL_SMTP: Sending Accents
Hello, I am using Oracle XE 11.2 to send emails using the UTL_SMTP package, but whenever there are accents to the subject or message, it is replaced by a "?". Here’s what I got: I have a protocol…
-
1
votes1
answer299
viewsError when connecting ORACLE database with PHP
When trying to connect to an Oracle ORACLE database appears the following error: TNS:System was not Given the SERVICE_NAME in CONNECT_DATA I have already set up php.ini and included the following…
-
1
votes1
answer86
viewserror when converting an Oracle precedent into a Postgresql function in pl/pgsql
I adapted the code, but there is the following error : ERROR: relation "fields" does not exist CONTEXT: compilation of PL/pgsql function "p_grava_log" CREATE OR REPLACE FUNCTION F_GRAVA_LOG ( TIPO…
-
1
votes0
answers401
viewsThe MSDAORA Provider is returning "?" instead of special characters
I’m going through a problem trying to configure my computer to run the application the same way it runs on the server, the characters that are returned from the Oracle database, appear with a ? in…
-
1
votes1
answer57
viewsUnderstanding pl/sql syntax Oracle 11g
I have an Oracle PROC 11g. Inside proc has something like this: v_prazo_subs_ans ts_odo.odo_controle_sistema.val_parametro%type; Where: v_prazo_subs_ans is a variable ts_odo.odo_controle_sistema is…
-
1
votes1
answer270
viewsSelf relationship Doctrine
I’m using Doctrine, and now I have the following problem. I am making a register of menus system, where the same can have several "children" and their "children" can also have "children", and so on.…
-
1
votes1
answer622
viewsError Case and Group by - Oracle SQL Developer
Hello, I’m trying to group the results of a query with case as follows: select case when sal BETWEEN 0 and 100000 then 1 when sal BETWEEN 100001 and 200000 then 2 when sal BETWEEN 200001 and 300000…
-
1
votes1
answer458
viewsInner Join table on 1 = 1 can be considered a gambiarra?
I have a table of provas and a table of alunos who have no direct relationship, I still have a table of inscrição aluno and a table of escolas, as follows in the modeling below: I need to create a…
-
1
votes1
answer353
viewsTrigger prevents table change
I need to make a Rigger that prevents the same employee from being part of more than one crew on the same day. The crew table is as follows: Tripulação = {id_Voo, data, id_Funcionário } The 3…
-
1
votes1
answer2399
viewsMER - Entity and relationship model
I wonder if my MER is correct and if it is possible to make a relationship N:N between animals and schedules. Specifications I created for the system: Computerize the scheduling of a bath and Osa,…
-
1
votes1
answer921
viewsUpdate in table with date field
Hello! I need to update a table. I have a kind of chat in the bank, where it records the time the conversation was started, and should record the time it ended. However, before I implemented the…
-
1
votes1
answer61
viewsHow to bring the name of the fields and type of an oracle table in c#
How do I bring up the name and type of fields in a table, using Oracle and C#(WPF)?
-
1
votes0
answers635
viewsHow to make a Delphi-Oracle connection without Oracle Client
I have an application that was developed at a time we had a client-server system , with this there was always an Oracle client on each machine, now we have a 3 layer system and we no longer have…
-
1
votes0
answers40
viewsOracle10g integration with Sql Server 2008 via JDBC
I need some help, I have a system that integrates Oracle with Sql Server, that worked perfectly but Sql Server was 2000, it was upgraded to Sql Server 2008, it used the jdbc 2000 driver, now I…
-
1
votes1
answer3034
viewsHow to select by taking the record that has the maximum value of a field?
I am doing a select that is seeking records that meet some conditions and then should take from them only the record that has the maximum value of a given field. It’s like this: SELECT…
-
1
votes0
answers64
viewsNginx with Oracle
I’m having the following problem, I set up mine Nginx with the Gem Passenger, for my application ruby-on-Rails, using Oracle database (Instant client), everything is configured correctly at first,…
-
1
votes1
answer777
viewsError Registered the JDBC driver [oracle.jdbc.driver.Oracledriver] but failed to unregister
I’m making a system Javaweb using jsp that’s on that topic: Doubt in database query, error in query, and in a database query, I came across a driver error that is just below. I use the IDE netbeans…
-
1
votes1
answer556
viewsReturn JSON with date and time
I’m having a problem returning json with date and time the code is as follows: <?php $sql = "SELECT CRED_NUMERO, MOV_DATAHORA FROM APOIO.LOG_CREDENCIAL_APOIO A WHERE A.CRED_NUMERO = 10734568 AND…
-
1
votes1
answer876
viewsHow can I run a . rdl (Reporting Service) file with Report Viewer without using the server?
Good Afternoon, I am in need of a solution to run the . rdl local files without using the Report Services server, I need to use the local file. The goal is to use existing reports, with SQL Server…
-
1
votes1
answer200
viewsBring value from a grouped record
Dear colleagues I took a query that I thought was simple but it’s complicated! I have a database where I have all my NF per commodity input product, I need to find the product value in the last…
-
1
votes2
answers12423
viewsOracle Insert of multiple lines
I need to input multiple records into a table where only one of them will change, the others are constant. For example: Insert into processo (ID, status, descricao) values (1, 'X01', 'lorem ipsum…
-
1
votes1
answer133
viewsProcedure pl/sql
Do you guys talk? Well I am new in PL/SQL and I am creating my first Precedent, because I need to load in two tables (Insert or Change), I am using Merge. But when I try to run my past I already get…
-
1
votes1
answer63
viewsDifficulty loading oracle data with js(jquery and ajax) function
This is my scenario: I have two pages (A and B). In B I load a variable with data coming from Oracle. In B I also mount my table that will be displayed in A with this data. On page A I have my…
-
1
votes1
answer47
viewsGit Permission denied for longer pathnames
I have to do the clone of the project in the directory: C:\xampp_5.3\htdocs\Meu-projeto First running configuration to allow pathnames more extensive: git config --system core.longpaths true…
-
1
votes1
answer1927
viewsORA-01799: a column may not be Outer-joined to a subquery
I am having a problem with oracle, it is not accepting a subquery in a left Join, if I change to Inner Join works, but changes the result of my select so it does not meet the solution. the problem…
-
1
votes1
answer319
viewsTaking reserved SQL words out of a Java string
I’m making a view that has an open field (textarea) where the user can write SQL and then run the same SQL. The point is that the oracle user where it will run SQL has permissions for everything and…
-
1
votes1
answer473
viewsError while fetching a list in the bank
Eae personal, So I have a question about my college job, I have two tables a user and USUARIO_AMIGO both related, by java I’m searching a user list that brings all registered users, and another list…
-
1
votes2
answers1031
viewscalculate how many hours between call opening date and current date in pl/sql
I need to make a query that brings the calls that are outside the 48 hrs SLA calculating the dates and times of the opening of the call and current date, someone can help me?
-
1
votes2
answers161
viewsHow can I use something like an IF in an SQL query
I am applying a query SQL in the Oracle SQL Developer in multiple tables where a Column a view is null in some places and then I will need to use values from another Column and I don’t know how to…
-
1
votes1
answer150
viewsSelect Banco Oracle - Constraint
Good morning guys, if anyone can help me, I need a query that will return me the constraints of a table and its data types. I am trying to assemble a generator of Procedure to facilitate, it takes a…
oracleasked 8 years, 5 months ago Ulisses Gimenes 443 -
1
votes1
answer704
viewsOracle SQL - Query multiple schemas
I was able to assemble the result, now missing create the view with this result. Which is the best way? This consultation: "SELECT CONCAT(CONCAT(CONCAT('SELECT * FROM ',a.OWNER),'.TAB2'),CASE WHEN…
-
1
votes0
answers497
viewsHow to pass a parameter of type 'Nested Table' for a stored file in Oracle
I have been working with Oracle for a little more than 2 months and I need to pass a data set to be used in the query parameter within the process. I searched a lot on the net and did not find any…
-
1
votes1
answer229
views -
1
votes1
answer1788
viewsHow to set output size in Sqldeveloper "script" option
Oracle - Sqldeveloper - Version 4.1.3.20 Build MAIN-20.78 When running an SQL block there are two options (Run Instruction or Run Script), in this option , after an update is made, there is a…
-
1
votes1
answer94
viewsOracle SQL Error Invalid Number
I have the query below, which shows me date and time, saved as default sysdate oracle: SELECT TO_CHAR(DATA, 'DD/MM/YYYY hh24:mi:SS') D1, TO_CHAR(DATA_FIM, 'DD/MM/YYYY hh24:mi:SS') D2 FROM…