I am using SQL Developer over a backend Oracle DB. I have a record where the buyer name is Pete Hansen. Why I try I get the result, no problem. However, when I use the following, I do not get any results: Also, when I try the following, I do not get any results but the following works well: Could
Tag: oracle-sqldeveloper
Oracle SQL: select for weekday and converting column to date
I’m having a database with column (with datatype VARCHAR20) Created 2020-01-01T20:30:20.207Z 2020-01-04T23:10:00.242Z In the end I want to be able to filter for a certain weekday. My first step in …
How to access a table with username with special characters in Oracle sql Developer
I have the following usernames/schema: shopping shops[shopping] In both users I created a table named “SHOP_TAKE_CART”, I use shopping for testing purposes and shops[shopping] to publish …
How to transform complex form/poll questions to SQL tables?
I need to make system design out of some big form/poll and transform all of that in SQL tables and make db out of it. My problem are questions in which user can choose answer or if the answer is not preset to write it down. So for example question is: Where did you bought your groceries? 1 – walmart
Oracle SQL Developer flag my working views as broken
Can anyone share me some light on why my Oracle SQL Developer flagged my view as broken while it is actually working? It is not just 1 view, but 10 views have the same problem, they are all created in a different time, with subquery or joining to multiple tables and is always working fine. Thanks in advance! Answer Probably
coalesce, nvl and CASE not working for count(*) in the subquery
I have a query with CTE and I want 0 for the NULL rows. I want to why COALESCE(tsting), NVL(tsting2) and CASE(rw_cnt) is not working? Am i missing anything? And I get data like below: Any suggestion for the query optimization is welcome… 🙂 Answer You are doing a LEFT join of dte to tmp, so you get nulls for
Oracle SQL count same field across multiple tables
I have an oracle database that has the same name field in multiple tables. It kind of looks like this: The common field in each table can either be ‘yes’, ‘no’, or null. I’m trying to get the value counts of all the fields in one query, but I can’t figure it out. Basically I want this: I have this
SQL: How to get salary format of “$99,999.00”
In my table, the salary is in format “99999”, how do I get it/select it into the format of “$99,999.00”? Answer You can use a format mask like the one below. Different format models can be found here.
Using SQL to identify instances where there is a specified unique grouping/combination
In Oracle SQL, I am trying to identify instances where a unique combination of records is present. For example, I have table ITEMS that lists items sold by a store chain where Store_ID is the location …
Dense Rank grouping by IDs
I am having trouble getting my DENSE_RANK() function in Oracle to work how I would like. First, my dataset: I am trying to use the dense rank function to return results with a sequence number based on the DATE field, and grouping by ID. How I want the data to return: The query I have so far: However, this returns