good day I have a query where I use a merge in store procedure I have a screen that has 7 thousand records that I must insert or update, the detail is that the process lasts about 5 minutes and I want to see a way to do the most fast I have the...
I was trying to create this table called PAIS that is nested to tables that store only abstract data types. The problem is when I execute this script in oracle it gives me warning in the data type row_exp and in others not. Therefore, when creat...
When updating the database model so that it takes changes to the schema of the database, it shows me this error:
An exception of type 'System.ArgumentException' was thrown when trying to update from the database. The exception message is:...
I have a problem connecting from php to oracle.
when using the function
oci_connect();
The result I receive is:
call to undefined function oci_connect()
Windows 10
IIS8
PHP 7.1.19
Oracle 11.2
I have changed the .dll with oth...
I have the following query that shows me the name of RESPONSIBLE and ALTERNATE of a service
the field TYPE RANGE, can have the values 1 or 2, where 1 = RESPONSIBLE and
2 = ALTERNATE
SELECT E.NOMBRE_TRABAJADOR RESPONSABLE,...
I do not know what is wrong with my sentence, I do not believe the table, the line of code is as follows:
CREATE TABLE CONTRAP AS
SELECT OPERACION_DIRECTO.TRAN_NUM,
OPERACION_DIRECTO.INTERNAL_LENTITY,
OPERACION_DIRECT...
Good I am new here but I wanted to ask you for help if someone already had a similar problem.
It turns out that I downloaded a sales system made in Java (Netbeans) that was connected to MySql, this to reports with Japser, everything worked OK...
If I have an access database on computer A and I want to implement a mysql server on a B machine, how do I make the access transfers to MMYSQL faster?
1) I make a public in (// A / publish) and change the data storage path of my MYSQL server...