I'm having a hard time ... I'm having a server running Debian and I installed Apache and PHP 7, but I'm having trouble activating the Oracle Oci8 connection, I followed this tutorial # Until all is ok, I did all the procedures but when I tested...
I have the following table:
CREATE TABLE Emprestimo (
id int PRIMARY KEY,
dataRetirada date DEFAULT current_date,
dataPrevistaDevolucao date DEFAULT current_date + 7,
dataDevolucao date,
codigoUsuario int,
codigoExemplar int,
FOREIGN K...
I installed the Oracle database, but I can not remember how I connect at the bank prompt. I think it's System connect "password". Someone corrects me, favor.
If I execute a series of SQL commands with Oracle database, OCI library, without executing commit and setting it to commit p>
What will Oracle do at the end of running the PHP script? A rollback or a commit?
How do I update the sequence value?
Situation:
I'm going to create a sequence but this table may be either registered or unconfigured. So how do I generate the sequence 0 or so with value since there is already a record?
create sequence S_...
How to increase your salary by 0.1% of those with lower salary than your department's AVG
This is the table for
I was able to take the average salary by department:
SELECT cod_departamento, AVG(VAL_SALARIO)
FROM FUNCIONARIO
GROUP BY C...
Is there any problem in saving data with a comma or period (.) in my database (SQL Developer)? What is the most appropriate variable to declare for currency (price) fields?
How can I correct an error of this nature (ERROR 00302) and how to know the line in which the error is in Oracle SQL Developer?
Error(16,6): PL/SQL: Statement ignored
Error(16,52): PLS-00302: component 'NOME_PESSOA' must be declared
Error(17,6...