Python - transpose a Pandas DataFrame

I would like to transpose the following dataframe in order to export it to an Oracle table. 0 ID Available Quota \ 1 1724 GOM COD GOM HADD GOM BB GREYSOLE DABS GOM YT 2 1578 GBE COD GBW COD GB BB G...
more »

2017-01-19 18:01 (1) Answers

query with left outer join in sql

I have an issue with the below query: select main.courseid ,main.coursename ,main.catid ,main.catname ,main.need_dte from ( select t1.courseid ,t1.coursename ,t2.catid ,t2 ,catname ,t2.need...
more »

2017-01-19 18:01 (1) Answers

Oracle: how to group by 1st value in row?

Table has 3 columns in a table: ITEM, SUB_ITEM, DATE_CREATED. ITEM - item id (string) SUB_ITEM - item id (int) DATE_CREATE - date the SUB_ITEM was created (date) Scenario: There are 3 Different item's (AAA1, AAB2, ABB3) All 3 of these item's ha...
more »

2017-01-19 17:01 (1) Answers

Oracle JDBC connection timed out issue

I have a scenario in production for a web app, where when a form is submitted the data gets stored in 3 tables in Oracle DB through JDBC. Sometimes I am seeing connection time out errors in logs while the app is trying to connect to Oracle DB through...
more »

2017-01-19 16:01 (2) Answers

SQL trigger - nesting INSERT INTO in IF condition

I want to create trigger registring in new table employees whom salary is being raised above 5000 and didn't get salary higher than 5000 so far. Trigger I wrote is returning error Error(2,41): PL/SQL: ORA-00984: column not allowed here. Here's my t...
more »

2017-01-18 21:01 (1) Answers

oracle index for like query

I'm fighting a case of customer stupidity / stubbornness here. We have an application to look up retail shopper by various criteria. The most common variety we see is some combination of (partial) last name and (partial) postal code. When they enter...
more »

2017-01-18 21:01 (1) Answers

Haversine Formula unit errors - PL/SQL

Overall goal: Find all zip codes within 30 miles of a given zip. Data Source: List of Zip Codes, with Latitude and Longitude as 'x' & 'y'. Example: create or replace view zips as select 37171 zip, 36.362704 y, -87.30434 x,'Southside' City, 'T...
more »

2017-01-18 18:01 (1) Answers

Exception to schedule in DBMS_SCHEDULER job

I have an Oracle DBMS_SCHEDULER job that normally runs every hour on the hour. No problem. But, I recently needed to make an exception to this, so that that last run every Saturday (i.e., the one at 11pm) would run a little earlier. (Reason is a l...
more »

2017-01-18 18:01 (0) Answers

Insert NULL into setDouble method Java

My code attempting to insert NULL into setDouble method in PreparedStatement ps.setDouble(++i, balance.getAmount()); getAmount() is Double field. i am able to handle like if (balance.getAmount() == null ) { ps.setNull(++i, java.sql.Types.N...
more »

2017-01-18 14:01 (2) Answers

ORA-00933: oracle 8i

I want to use join in Oracle 8i. I have my query as below. I have this query of getting data from two tables using an join, but I get the error SQL command not properly ended. private List<StamfordProdRelease> GetStamfordProdReleases() ...
more »

2017-01-18 12:01 (1) Answers

Oracle Spool unable to display special characters

I am generateing a txt file using the below code. The code works fine, but there are issues with some characters. I am using Oracle. Characters such as é, á etc. are unable to be displayed. set echo off set verify off set termout on set heading of...
more »

2017-01-17 14:01 (1) Answers

Apex Oracle print on Internet Explorer

I have a page that contains 2 interactive report. I need to print it so I have a javascript function that calls window.print() So I've put some CSS to adjust my table @media print { width: 100%; height: 100%; margin: 0% 0% 0% 0%; } The prob...
more »

2017-01-17 14:01 (1) Answers

Delete from oracle db with oledb in vb

i got a problem deleting rows in Oracle database using oledb commands dim conn_str as string = "Provider=OraOLEDB.Oracle;Data Source=ORACLE;User Id=Test;Password=Test;" Sql = "delete from rezervacija_test p where p.datum < (select max(datum)...
more »

2017-01-17 13:01 (1) Answers