Well, I have a problem with the following: I want to do a table partitioning in postgres because a table has zillions of records and it takes a long time to fetch it (this table tends to grow considerably in the coming months) and a solution tha...
Hi, can anyone give me a hand? I have the structure below, it returns 4 columns, I need to get 6, but I got lost in the "hit < >"
SELECT DATA,
NVL(
(SELECT MIN(MINTOTIME(BATIDA,':'))
FROM ABATFUN B...
I need to optimize a load application that runs through a database and writes to another database, but that has to be done through a Windows Forms application.
I am doing this using ArrayBindCount of OracleCommand , but it is retu...
I have a packcage with the following SP:
procedure sp_WEB_PECAS_OBJTV_LOJA( pPECAS_OBJTV_LOJA_ID in WEB_PECAS_OBJTV_LOJA.PECAS_OBJTV_LOJA_ID%type,
pPECAS_OBJTV_LOJA_COD_EMP in WEB_PECAS_OBJTV_LOJA.PE...
I'm trying to create a table in apex5 with reference, having a foreign key from another table and having that foreign key column be populated. But creating is returning the error:
ORA-00922: missing or invalid option
I've already check...
I want to generate a view through php for an oracle database where the select is done through the result of another query.
This query mounts the select to the view:
$sql1 = "SELECT TESTE FROM VIEW_TESTE";
$result1 = odbc_exec($conOraSql , $...
I have the following problem:
I have a table with a list of values for a composite key. Here's an example:
ID | ItemCode | Localidade | Preco
---+----------+------------+-------
01 | 001 | 001 | 3.5
02 | 002 | 001...
As I do for a connection to the Oracle database, show all tables. I made a connection and I have more than 500 tables in the database and it only shows 74, the three that I need to mount the POC I'm doing, I can not map them.
see the tables t...
My xml may be wrong, of course. but as I'm not sure, I say: I need to pass a parameter via programming to a proc. As in my program it is coming null, I have decided to run first manually straight into pl / sql and still nothing comes. The xml mo...