I have a table where two specific fields together can not have the same values.
BELIEVE what they are:
NUM_DIVISION
COD_INDICATOR
Assuming I have this data:
NUM_PERIODO_LANCAMENTO = 1 , COD_INDICADOR = 1 , COD_CR_PERIODO = 1
NUM...
I'm trying to run a connection test in the bank and extract some information, just for the same study, however I'm running into the following error:
Exception in thread "main" java.sql.SQLException: ORA-00923: palavra-chave FROM não localizada...
Well, I wanted to start learning MySQL , but I'm not getting started, I do not understand the software or anything, web tutorials do not talk about MySQL on Mac , only on Windows .
I downloaded MySQL on Oracle's w...
I need to change the parameters nls of Oracle, putting the characteristics of the image below:
I've tested a lot of tips, but it always says I have insufficient privileges.
These are my settings:
NLS_LANGUAGE AMERICAN
NLS...
For the sake of curiosity I got a story from my second half of ADS and this is a SQL script based on 3 tables: ALUNO , CLASSE , MATRICULA .
I made the script according to the statement, but my script does not execute, the fo...
Good afternoon.
I have two owners on my oracle
example Owner "X" and the other owner "Y". Where each one has its own tables,
but I want the owner "X" to be able to update, insert and delete some tables of the owner "Y".
Is it possible?
Well, I put PL / SQL and mysql because these two modes have procedures in both Oracle and mysql, but anyway.
The IN mode I understood that it works like a constant, it is passed through the parameter and can not be changed inside the procedure ....