I'm trying to compile the package below and the error is being returned: Error (9,3): PLS-00103: Found the "BEGIN" symbol when one of the following symbols was expected: language
CREATE OR REPLACE PACKAGE PCK_TB_ESTADO
IS
PROCEDURE PRC_INSER...
Hello, I'm using a search method with entity framework and oracle, and I encountered a problem with dates.
In my search I use the following logic:
Find(x => x.Data_Intencao >= Periodo.Date, c => c.SubOrigem_EF);
But in my Dat...
I've created a diagram in sql-server , where it automatically creates the entire database structure, but I will have to migrate to Oracle.
Can I migrate the entire structure (tables, FKs, PKs, etc.) with some tool?
Obs. 1: There are no d...
Can someone tell me a good data migration tool for the oracle database for the sql server database and vice versa?
I need to get lots of records from the oracle database and save it to the sql server database, I need the migration to be done in...
I am developing a report in PowerBuilder and would like to know how to merge results from two SQL queries into the report.
If I add the function f_block_to_number in the first query and add the invoice table in from, the records multiply in the...
I have a procedure inside the oracle database, but I'd like to run it from a desktop java application I'm developing.
How do I execute an oracle procedure with parameters in java?
Hello, I would like to know how to query the Oracle database to know: What is the average number of guests per day of any given week.
Here's the script for the bank:
CREATE TABLE APP.HOSPEDAGENS (
hsp_id number(6),
hsp_checkin...
How can I return the first 100 rows of a table without having to read all of its records?
My table has 4 rows of rows, and I'm having trouble trying to return only its first 100 rows, because every time I use ROWNUM, sgbd reads the entire tab...
I'm developing a web application in MVC with C# .
I made a method that makes a select in my bank oracle and with the value returned I fill in a DataTable .
But it returns an error when I run " dataAdapter.Fill(resultado)...
In the select below, I would like to use the novonome alias in the second column (instr).
select
substr(titulo, 1, 20) AS **novonome**,
instr(**novonome**, ' ')+1
from conteudo;
But I get the error:
ORA-00904: "newname...