Questions tagged as 'oracle'

Tagged questions
1
answer

convert varchar to date oracle plsql

I need to convert a varchar to date so that I can filter all dates longer than a certain date, for example: I want all dates that are greater than November 2018 to be listed, I'm doing it as follows: DATA_FINAL > TO_DATE('1...
asked by 17.10.2018 / 16:48
1
answer

How to update a View?

I have a table where I check in and out of trucks. In this table there are two fields of type Date, I want to update the data of these fields. I'm using the following select. UPDATE V_TPL_ACOMPANHAMENTO SET E_POR = TO_DATE('08/10/18 22:24','...
asked by 16.10.2018 / 16:55
1
answer

Problems to invoke / insert data with the procedure

I created this procedure in Oracle, but I am not able to insert data with EXEC . How I'm Declaring EXEC: EXECUTE SP_PRODUTO(8,'teste' 1); erro APRESENTADO: ORA-06550: linha 1, coluna 126: PLS-00306: número incorreto de tipos de argum...
asked by 27.09.2018 / 04:11
1
answer

Working with BLOB field in ORACLE using Codeigniter [closed]

I have a system where I will store certain files in a BLOB-type column in my ORACLE database, but I did not find anything about it in Codeigniter's own documentation on how to do this, how can I manipulate these files, where I need to feed this...
asked by 24.10.2018 / 15:26
1
answer

Error executing a Trigger

I'm having the following error when executing my trigger, how could I resolve it? ERROR The error when I insert insert into the product-purchase table to calculate total INSERT into purchase_product (CPR_CODIGO, PRO_CODIGO, CPP_QTDE, CP...
asked by 10.09.2018 / 21:49
1
answer

Reset sequence every year

I'm creating an identifier that has the following sequence/ano formatting, which is why I need my sequence to count from 1, again, whenever there is a year turnaround. Is there any way to do this automatically or will I have to drop and r...
asked by 05.06.2018 / 21:44
2
answers

How to insert for all users in PLSQL when there is no data?

Good afternoon! I'm trying to insert all users when there is not a type entered for all users: INSERT INTO USUARIO ( TIPO, PRIORITARIO) SELECT '130', 'N' FROM dual WHERE not exists (SELECT * FROM USUARIO WHERE tipo = '130'...
asked by 30.05.2018 / 19:00
1
answer

Oracle - DBMS_APPLICATION_INFO.set_client_info - What is it and when to use

On the line below in a PL / SQL script DBMS_APPLICATION_INFO.set_client_info ('1010103 @ company'); Got it that is a package calling a procedure and that it arrow customer information in the session (in my case it is the enrollment of th...
asked by 13.06.2018 / 20:29
1
answer

How to compare two Oracle DateTime columns

I have a column where I enter a date when the event happens (local storage), and the date the event is sent to my system. The difference between the date of the event and the date of submission can not exceed 168 hours (7 days). I'd like t...
asked by 15.06.2018 / 15:37
1
answer

SQL returning error when selecting nonexistent field

It has a system that several companies use, but the changes in the bank tables are not informed. I would like to create a select that would not return an error when it did not find a field recently taken from a table? Code: SELECT c...
asked by 04.05.2018 / 16:49