I have a table called Clientes , and in it I have the following columns:
id_cliente
nm_cliente
dt_nascimento
I need to select and count all clients that were born in the same year. I already tried some things, but they do not return b...
In the image above I have mapped the separation positions inside the warehouse where I work.
I need to calculate the distance that the person who is separating goes through the warehouse.
For example if the person is separating in position...
I've created a VM with Laravel Homestead I need to install OCI8 on it:
Run the command sudo pecl install oci8 as reported here
But I get this error:
ERROR: '/ tmp / pear / temp / oci8 / configure
- with-php-confi...
I have a database on oracle where I need it delete all objects from a particular Schema , I can not delete the Schema , since the system validation is done based on an algorithm that takes into account the Schema ID .
I'm working with a Desktop application and I use spring to hold my inserts in the database.
The object I'm using is the JdbcTemplate, which has the encapsulated datasource inside it. I would like to know how to start new transactions with Jdb...
One colleague mentioned that when doing EXISTS in SQL, it is recommended to use DISTINCT 1 to improve performance.
For example, instead of doing:
SELECT *
FROM CLIENTES
WHERE NOT EXISTS (SELECT CODCLI...
From what I saw it is using in Oracle, but can I use it with another bank?
Pro * C / C ++ is useful today?
Could you pass an example code?
Does it have PL / SQL difference? Or are they used together?
Hello, despite the self explanatory title. I'll detail my doubt below.
I have a pre-existing Oracle database, I integrated it with django by configuring the default connection in settings and running manage.py inspectdb > _models.py. So cr...