I have a query in php / oracle that hides a "" tag while displaying the result in the browser while in oracle sql developer displays everything ok.
Expected: '
Hello, could anyone tell me if there is any significant performance difference in the two ways of doing INNER JOIN below?
Way 1:
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name=table2.column_name;
Way 2:
SELEC...
I have a Decode in my select like so:
.....
DECODE(MAT.IND_TIPO_MAT_MED,
'1', 'BRASINDICE',
'2', 'SIMPRO',
'9', 'TABELAPROPRIA') TIPOTABELA,
.....
I need to pass these values on the where clause, sinc...
I need to install the pdo_oci PHP extension to work with Oracle database via PDO. However, I noticed that the extension available via PECL is deprecated and will no longer be maintained.
As I understand this link (I do not know if I under...
I'm trying to do a delete of all rows from a table via Shell Script.
The database is oracle. The bank for some reason does not let me do truncate and the delete simply does not delete, without presenting any error. I do not really know why, when...
I have a problem with Oracle, where I have two procedures that are executed one after the other.
Where in the first procedure , I have a cursor that makes insert in a table.
This insert has approximately 30 million records , which...
Here is the procedure with the problem:
CREATE OR REPLACE PROCEDURE NOVODIA.PRC_PACIENTES_INATIVOS_95
(
--PARAMETROS
IN_CPF IN VARCHAR2,
IN_CARTAO IN VARCHAR2,
OUT_CURSOR OUT SYS_REFCURSOR
)
IS
--VARIAVEIS
V_COD_CLIEN...
I have a report developed in Sybase InfoMaker (similar to Crystal Reports) which displays two pages, however I need to print the second page only if there is a calculation.
On the second page you see several calculations, but if the report (p...
I have the following problem, first the configuration of my PC.
SO: Fedora 20
PHP 5.5
Oracle Instant Client: 11.2.0.4.0
I try to connect via tnsnames.ora file settings and the following error occurs
ORA-12169: TNS:Net s...