Hello my problem is that I can not relate two tables that are one to many, simply by executing my code in netbeans the table without foreign shows the record well, but in which contains foreign key does not show simply limited to write where the...
I would like to know how to change the port of oracle 11g and what to occupy, that is, to know one that is free, since port 8080 is occupied by sql server and the 8081 Mysql.
Greetings and thanks.
How can I generate something like an array from a select? , we are not allowed to create procedures or functions in the database.
I expose the problem.
$Query = "select to_char(ld.diario_id) diario_id,COLABORADOR_ID from XXQP.XXQP_DIARIO_LN...
Is it useful to use bind variables when there are no variables?
For example
SELECT count(1) as cantidad
FROM MYTABLA
WHERE CAMPO1=5
This query will always be executed the same, 5 will always be 5 and will not change.
As far as Oracle...
I'm running a console application in JAVA, where I need to run a Stored Procedure done in Oracle , the Stored Procedure has three input variables that are of data type String and two output ones, one of which is String type and the last is of...
I'm doing validations on a register page with regular expressions, but the problem is that when I hit the "Register" button the flow continues, if or if I have to put an if and else, but for that I have to get an value of javascript and this has...
I'm doing 3 dropdown, one that is "department", the other one is "province" and the last one is "district". When my page loads, it is already pulling data from the database in the "department" dropdown, but when I click on one of those data I dr...
I just imported "Oracle.DataAccess.Client" to my file "Register.aspx.vb" but when calling the connection methods, they do not appear. Everything I am implementing in a function to call them in other elements.
Register.aspx.vb
Imports Orac...
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...