Questions tagged as 'plsql'

Tagged questions
1
answer

Help with PL / SQL insert in Oracle

What happens is that I am trying to do a search in two tables and through cursors with parameters do the calculation of a tax and insert the data in a new table called taxes. I have three tables, AUTOMOVIL , AVALUOS e IMPUESTOS...
asked by 04.10.2018 / 16:48
2
answers

Update several tables at the same time Oracle

I try to update three tables in Oracle, which are totally different, but in all there is a field exactly the same "STATUS". The issue is that I need these fields to be updated to "NEW". This is why I have asked myself if it is possible to...
asked by 08.05.2017 / 22:12
2
answers

Replace PL / SQL character

I need to replace a particular character of one in oracle. For example: cadena= '12121113' and what I need is to change the "1" to a "2" but only the "1" that is in the 3 position. and return the modified result. As a result, there...
asked by 08.03.2016 / 22:06
0
answers

UPDATE with INNER JOIN in Oracle 11G (Performance)

I am currently starting to work with Databases in Oracle and it is common to have to perform UPDATE from one table to another. Since the databases I have access to do not have many records, if I run an Update with inner join I can not evaluate t...
asked by 12.04.2018 / 23:25
1
answer

Error ORA-06502: PL / SQL

I have the following procedure: CREATE or REPLACE PROCEDURE QUERY_EMP (id IN emp.empno%TYPE, salario OUT emp.sal%TYPE, puesto OUT emp.job%TYPE) IS BEGIN SELECT job, sal INTO salario, puesto FROM emp WHERE empno = id; END QUERY_EMP;...
asked by 08.05.2018 / 20:52
1
answer

Show the letters of a string and how many there are

I have a code that shows me the letters of a name and the number of letters in that name. But when he prints the letters and how many there are, he repeats the letters he has already read and tells me the spaces. Here the code: create or REPLA...
asked by 26.02.2017 / 03:15
3
answers

PL / SQL SMTP: 501 Error: attribute value too long

I am presented with an error when creating an automatic email through the database, I am creating the body and I get this error message:    ORA-29279: Permanent SMTP error: 501 Error: attribute value too long       ORA-06512: in "SYS.UTL_SMT...
asked by 11.02.2016 / 20:45
2
answers

select with groupings

Can be obtained in a single select ??? An example company, department, and production carried out Obtain the percentage of production: the production of the person between the production of his department of his department (production pe...
asked by 13.02.2018 / 15:37
3
answers

Validate in PL-SQL

I'm in a PL / SQL database and I need to put together an anonymous script to insert into a configuration table (config and value fields). Something like this: Config: ‘country’ Value: ‘Argentina’ Config: ‘moneysign’ Value: ‘$’ Config...
asked by 21.09.2016 / 03:43
1
answer

ORA-00928: in MERGE

Good morning, I am trying to update records from a CTE, however I am getting error ORA-00928: I think I'm not missing anything, however, I can not get the update to run. I attach the code that I am making. I hope you can guide me about...
asked by 10.07.2018 / 19:15