Questions tagged as 'oracle'

Tagged questions
0
answers

Call in JasperReports file with Oracle database

I have some files generated by JasperReports (.jrxml) that querying an Oracle database. My question is in direct execution with parameterized in PHP (framework codeigniter), standard MVC. I've tried some XML's, but to no avail. I need to gene...
asked by 28.09.2018 / 00:05
3
answers

How to consult a record that does not contain certain code?

I need to make an appointment where the calls that were not validated are listed. It works like this: A call is a support request, in which several actions occur, and all are recorded in an auxiliary table. I need to filter out all the cal...
asked by 28.09.2018 / 00:16
0
answers

Code Based Configuration - EF6

I've been trying to implement a connection to an Oracle 11g database using the EF6 code-based configuration for a few days, but nothing I've done so far seems to work. Currently this is my implementation: App.Config<?xmlversion="1.0"...
asked by 12.09.2018 / 16:56
1
answer

SQL - IN within a SUB SELECT with NOT IN - ORACLE

I wanted to make my INSERT dynamic, which does not require me to change the ids manually. I have this script that returns all PRODUCTS that do not have a relationship with the table EST_PROD_PRECO_CUSTO_EMPRESA SELECT prod.ID_PRODUTO AS "ID...
asked by 12.09.2018 / 20:46
2
answers

SQL Syntax Error Exception: ORA-00928: SELECT keyword not found

I'm getting this message when trying to run a Stored Procedure created in Oracle:    java.sql.SQLSyntaxErrorException: ORA-00928: SELECT keyword does not   found       at oracle.jdbc.driver.T4CTTIoer.processError (T4CTTIoer.java:447) at   ...
asked by 17.09.2018 / 12:33
1
answer

Oracle where case

I need to create a condition in where according to boolean . If% of_% then I will select lines with final values larger than expected ( boolean = true , etc) if it is ConfirmedVolume > ExpectedVolume I select ever...
asked by 31.08.2018 / 14:39
2
answers

Search for entire month ORACLE

I need to run a report that returns the values for the entire previous month. It used the following form: where cliente.dtultcomp > trunc (SYSDATE-30) But there are cases of the month having 28, 31 days for example. Is there a way to alw...
asked by 08.08.2018 / 18:43
0
answers

How to convert JSON to XML in ORACLE 11g?

Good afternoon, I have a problem with my work. I need to create a function in oracle that performs the conversion from json to xml and show the result as a table. I know that version 12 of oracle does this easily, but unfortunately our bas...
asked by 10.09.2018 / 20:56
0
answers

sqlldr sql loader oracle insert file name in a column

Can I put the name of the file I'm loading in a column via sql loader? LOAD DATA APPEND INTO TABLE PFD_FILE TRAILING NULLCOLS ( FILENAME char, FILENAME_CERTIFICATION , DATE_CREATE "TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS')" )     
asked by 17.07.2018 / 18:49
0
answers

How to call a procedure that uses an out oracle type course with C #

I'm doing a test to find out how to call a procedure that has this type of course. IntheprocedureIhavethis:createorreplacePROCEDURE"PTESTE" ( pcd_servicoagendado integer, ptipo integer, -- 0 principal, 1 debitos p_cursor out pkgcursor.t_cur...
asked by 06.07.2018 / 17:08