I have tables like below. I would like to grouping and counting by referreing to its score. First, I would like to sum score by customer It achived by group by method. second, I would like to count by binning following band. I couldn’t figure out how to count after grouping Are there any way to achieve …
Tag: oracle
CONVERT_TZ() equivalent in Oracle
I am trying to convert a timestamp value of the format YYYY-MM-DDTHH24:MI:SS to another timezone value YYYY-MM-DD HH24:MI:SS.SSSSSS. I was able to do this in MySql using the CONVERT_TZ(date, from_tz, …
SQL – Select rows partially depending on another table
I am very new to the database and queries. I am not sure if this is very basic. Please help me to find a solution. I have two tables – subscription and customer with primary keys as subscription_id and customer_id respectively. the customer_id is foreign key pointing to customer table customer_id column…
NetSuite ODBC Limitations
I’m trying to find out if anyone is aware of any list of the limitations of NetSuite’s ODBC SuiteAnalytics Connect Service being used through OpenQuery? I’ve been running into many problems with some of my more complex queries failing for no apparent reason, and I finally started narrowing i…
Very slow query when using CONNECT BY LEVEL
NEEDS I want to create a table like the following in Oracle SQL: COUNTRY NAME WMWHSE_ID DATE US CRD2 1 040620 GR WAZ 2 040620 CN KOL 3 040620 …
How to do a SQL query with SRFs and display only distinct values?
I’m trying to think about a way to do a query with a single row function and display only distinct values. Lets suppose that I have a table employees with the columns employee, store and salary and I …
ORA-00933 in ODI procedure
I’m mapping two table in ODI and I have a problem. i’ve mapped the source table to the target table (called DM_BUSINESS with the columns BUSINESS_ID, NAME, ADDRESS). After that I’ve created a …
Select field based on other column max value in oracle pl/sql
I am calculating a field called “Degree Level” in a view. This is a field in the table “Degrees”, and the table shows degrees for each faculty member. A faculty member can have more than one degree. The field “degree level” is also in the table “Crosswalk_Table”…
Sum REGEXP_SUBSTR resulting ORA-01722: invalid number error
I’m creating a reconciliation report where I basically just want to know document value of each sent batch. Batch ID is in its own column and sent data is in one column and it’s comma separated, see randomly generated example below: Each batch have minimum 2 rows and max can be 2000 rows. In this …
ORA-06553: PLS-801:Internal Error [55018]
I want to make a function call like SELECT URUN_GETIR(‘test1’) FROM DUAL; but i got ORA-06553: PLS-801: Internal Error [55018]. I tried ORA-06553: PLS-801: internal error [55018] when testing function returning ROWTYPE this like for ex URUN_GETIR(‘test1’).KULUSERNAME but getting same e…