Written by I've read the first 60 pages of, Oracle, and am thoroughly enjoying this book. But I feel like I would enjoy it more if I knew Grim better, and the circumstances surrounding Black Spring, NY. I'll put down, Oracle, and read, Hex, first depending upon the recommendations. Trying to avoid any spoilers from either novel […]
Nvidia forecast its slowest revenue growth in seven quarters on Wednesday, with the artificial intelligence chipmaker failing to meet lofty expectations of some investors who have made it the world’s most valuable firm. Shares of the Santa Clara, California-based company fell 5% after it posted results but quickly pared losses to trade down 2.5% after […]
![Using flink oracle cdc and reported an ERROR [ERROR] Could not execute SQL statement](https://myspacemyanmar.org/myspace.com.mm/wp-content/uploads/2024/09/Vertex-AI-Antrophic-and-Mistral-models-Why-does-it.png)
I am using Flink sql client to commit a job by sql： Flink SQL> create table products ( > id int, > name string, > primary key(id) not enforced > ) with ( > ‘connector’=’oracle-cdc’, > ‘hostname’ = ‘myip’, > ‘port’ = ‘1521’, > ‘username’ = ‘****’, > ‘password’ = ‘*****’, > ‘database-name’ = ‘ORCLCDB’, […]
[This is a table structure. Based on the child and parent status want to populate result column. ][ These three records is a one config. If any one of the child or parent has status as compliance then result should be populated as Investigate for entire config or else it should be default. Want to […]
I have refering a lot of articales on stack i came across one query worked fine for me as expected But need some modification to make it work for me. Need to considering printing MONDAY TO FRIDAY dates only. SATURDAY and SUNDAY with + or – should give me only Working dates. Case 1 : […]
A cool standard SQL:2003 feature is the aggregate FILTER clause, which is supported natively by at least these RDBMS: ClickHouse CockroachDB DuckDB Firebird H2 HSQLDB PostgreSQL SQLite Trino YugabyteDB The following aggregate function computes the number of rows per group which satifsy the FILTER clause: SELECT COUNT(*) FILTER (WHERE BOOK.TITLE LIKE ‘A%’), COUNT(*) FILTER (WHERE […]
I’ve blogged about generic ways of getting top 1 or top n per category queries before on this blog. An Oracle specific version in that post used the arcane KEEP syntax: SELECT max(actor_id) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id), max(first_name) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id), max(last_name) KEEP (DENSE_RANK FIRST ORDER […]
In a previous blog post, we’ve advertised the use of SQL EXISTS rather than COUNT(*) to check for existence of a value in SQL. I.e. to check if in the Sakila database, actors called WAHLBERG have played in any films, instead of: SELECT count(*) FROM actor a JOIN film_actor fa USING (actor_id) WHERE a.last_name = […]