I have three tables, which are as follows: ALUNO , CLASSE and MATRICULA .
STUDENT
NR_RGM
NM_NOME
NM_PAI
NM_MAE
DT_NASCIMENTO
ID_SEXO
CLASS
CD_CLASSE
NR_ANOLETIVO
CD_ESCOLA
CD_GRAU
NR_SERIE
TURMA
CD_PERIODO...
I have three tables, one call ALUNO , one call MATRICULA , and another call CLASSE , and I need to select all students who are male and belong to the same class as a student who has a RGM specific.
The tables are:
STUDEN...
I have a table called "LOC_VEICULO" where the vehicle data is contained.
In it I have the following field: DT_FABRICATION (DATE), where the manufacturing dates of the vehicles are stored.
I need to change the vehicles, indicating the dates of...
I'm setting up a query and I came up with an issue.
My query looks like this:
SELECT BASI_030.NIVEL_ESTRUTURA NIVEL,
BASI_030.REFERENCIA GRUPO,
BASI_030.DESCR_REFERENCIA,
BASI_030.CONTA_ESTOQUE,
BASI_020.TIPO_PRO...
I have a column, where it is written R. TEST, I just need to make a correction leaving for STREET. TEST, how to make this change in the Oracle database.
I'm in doubt, when I create a CONSTRAINT UNIQUE , does it evaluate all the columns together?
For example, I want a country not to have names or acronyms , in which case should I create CONSTRAINT different?
Because I...
I'm developing a web server where I have to store images in String of Base64 exchanged by desktop , mobile and website to Oracle database, but I researched a lot and saw some alternatives that are:
sto...
I have a table in oracle 11g which in turn has a sequence
CREATE TABLE "BANCO"."TEXTO"
("TEXTOID" NUMBER NOT NULL ENABLE,
"NOME" VARCHAR2(4000 BYTE) NOT NULL ENABLE,
"VALOR" VARCHAR2(4000 BYTE) NOT NULL ENABLE,
"DATA...
I'm using xampp on windows 7, PHP version is at 7.0.15. I installed the Oracle Instant Client (32bits tbm) and then extracted into the "ext" folder of php version 2.1.3 of OCI8 according to this site ( link ). The problem is that after doing the...