Questions tagged as 'oracle'

Tagged questions
1
answer

Help with trigger insert

I'm new to SQL and I want to make a page as a new user record, and that this information is stored in a table, (this part I already have) The problem is that when creating a new user, I have 2 tables, one of companies and another of users, then...
asked by 18.12.2018 / 18:29
0
answers

Connections to Oracle Database with Python

I have tried to make a connection to an Oracle DB from my script using import cx_Oracle Since my local machine works well (I have an Oracle of 32 and 64 bits) but in the client I have an error because they have installed an Oracle of 32 and...
asked by 11.12.2018 / 11:38
1
answer

Oracle FORMS - Validate or invalidate records

I'm doing a FORM with a series of columns in GRID which are PARAMETER - ALPHA VALUE - VALUE NUMBER - VALUE DATE - COMMENT Parameter and Comment are mandatory but I want the user to have to enter at least one of the values. If you enter one...
asked by 10.12.2018 / 13:16
0
answers

Insert correctly in VARRAY of TYPE OBJECT

Recently I'm working on SQL Developer and 'messing around' with the creation of data types. For now this is the idea: CREATE OR REPLACE TYPE actividad_t AS OBJECT( nombre varchar2(50), contenido varchar2(50), plantilla varchar2(50)...
asked by 30.11.2018 / 19:59
1
answer

Problem with stored procedures in oracle and with .net

I have a problem that does not allow me to advance in my work, I hope you can help me. I'm doing a Web API that connects to a database in Oracle, it's a simple CRUD, I've done the Stored Procedures and everything, I've tried them from Oracle...
asked by 04.12.2018 / 07:36
1
answer

How to place a variable as a pattern in the LIKE? SQL ORACLE

I am doing a project and I try to make a trigger which assigns the course number automatically. This is the trigger that comes to mind create or replace trigger TG_curso_Auto before insert on cursos for each row declare num_var int; begin...
asked by 26.11.2018 / 22:32
0
answers

Create procedure to print the attributes of a pl / sql object on the screen

I am using sql developer with oracle database, the fact is that I have a created object called mesa, whose attributes are date of manufacture, color, number of legs and name, the fact is that I have a function that returns how old are you and I...
asked by 01.12.2018 / 12:37
0
answers

Table mutating when trying to modify values

In my database I have some procedures and some triggers in the table relation. I want that when I finish making a loan, that is, when I update the return date ('Fecha_Devolución') , my serial number that is a primary value, can change its...
asked by 23.11.2018 / 06:30
1
answer

How to optimize ORACLE query?

I need to optimize queries so that having a better performance when looking for the data is taking me too long an example This is the query I'm using the ORACLE database SELECT SM_ID, ORIGINAL_ADDRESS, DESTINATION_ADDRESS, SUBMISSION...
asked by 23.11.2018 / 13:01
0
answers

Limit in Oracle

They have sent us an exercise in class, and there is one thing I do not know how to do it. I put the exercise and explain you We are going to create the tables for an Academy where different computer courses are taught. We will start creating...
asked by 19.11.2018 / 09:31