I am trying to use a simple "Drop Table" Statement in PL/SQL Developer on some tables, but they won't drop. The tables are quite large, but I've never had this
I have a table like this, status_change is a dictionary, it has multiple status, How can i return a table: the dictionary key becomes the column header Appreci
I have been stuck to get around this in Oracle SQL. I have a table that looks like following. cust_id event event_date camp_id email_ind(calculated column) 1 O
I want to run 1 store multiple times like this in jobs. But somehow there is a problem that jobs only runs the first line of insert and the following lines do
So I am storing some config values in my table which looks like name value secret 1223 url "url" Now I have a situation where I want to update the secr
Trying CONVERT() Trying STR_TO_DATE() Trying CAST() - neither DATE or DATETIME work Trying CAST(STR_TO_DATE()) Hi, I cannot figure out what I'm doing wrong with
I get this missing right parenthesis but I cant find it CREATE TABLE PUBLICACION AS (SELECT id AS id_revista, nombre AS nombre_revista, COUNT(C.dni) AS cuan
I'm having a problem with my dynamic table name in ADO.NET Destination. The control flow is: SQL Query that bring me all the tables I need from an OLE DB connec
I'm in the process of migrating our database from Oracle to Postgres. We have a number of hardcoded queries in our spring boot application that now break as res
I have a postgres query that creates an anonymous table from string values and then joins on them like this: select distinct anon_table.string1,
Please explain this 'name' keyword What is it? How we can use it? Syntax?
I have the following table: +-------+------------+ | level | count(uid) | +-------+------------+ | 3 | 1 | | 4 | 1 | | 0 |
I am trying to get start date of the week from existing daily date field from the same table. For example daily dates from 05/08/2022 to 05/14/2022 , the start
When one orders results by multiple columns the database has to do something to compare NULL values (e.g. order them first last). But how can I replicate that
I have a scenario where I have to include choice lists of district/sector/cells/village (each of them is a field). I want to build a cascade, that way a choice
I have been stuck with this problem for a while now and can't resolve it, would greatly appreciate some guidance I am comparing records in a persons table to se
I am using Oracle database. The below query is not working as expected. select * from cst_cust_attributes where attribute_value='event' and attribute_value='
Let's take the following example from BigQuery, but it's the same across all other databases I've seen: with tbl as ( select [1,2,3] as arr, '{"IDS": [1
I have problems with slow and duplicated queries, I'll need assistance, I'm working on this for more than 10h+. Latest WP version - Latest Flatsome theme and ju
So my assignment question is to "Get a list of all books withdrawn by people with the initials 'B.W.'. Show a column for the first name, last name, initials, an