Follow us on Bluesky
Bluesky · Hashtag

#OracleDatabase

43
posts · 30d
7
users
1
posts / day
6.1
posts / user
-62% vs last week

#OracleDatabase is an active hashtag on Bluesky. In the last 30 days, 7 people shared 43 posts with it — around 1 a day. Activity is down 62% versus the previous week, peaking on Sep 4 with 9 posts.

#OracleDatabase posts per day (last 30 days)

Related tags

Tags most often used together with #OracleDatabase.

#oracle 27 #OracleCloud 19 #AI 16 #Java 13 #GenAI 8 #Developers 7 #OCI 6 #LangChain4J 6

Posts with #OracleDatabase

Carsten Czarski 🤨
@cczarski.bsky.social
almost 2 years ago
... seen the usage of REGEXP_SUBSTR and CONNECT BY to tokenize strings with SQL - and guess what? Was way too slow. So, here's a LiveSQL V2 script to compare a few approaches. livesql.oracle.com/next/l…. JSON_TABLE or APEX_STRING are still my favorites! #OracleDatabase #SQL
Live SQL V2 script to show how delimited strings can be tokenized in the Oracle Database. My favorites are: -- -- Alternative 1: Split with APEX_STRING.SPLIT -- select record_id, count(column_value) as token_cnt from tokens, apex_string.split( record_tokens, ':') group by record_id; -- -- Alternative 2: Split with JSON_TABLE -- select record_id, count(token) as token_cnt from tokens, json_table( '["' || replace( replace( replace( record_tokens, '\', '\\' ), '"', '\"' ), ':', '","' ) || '"]', '$[*]' columns (token varchar2(255) path '$' )) group by record_id;
2 4 13
Carsten Czarski 🤨
@cczarski.bsky.social
over 1 year ago
Check out the new "Sample Vector Search" application from the APEX Gallery, and learn how to leverage Vector Search on Oracle Database 23ai in APEX applications. #orclapex #oracledatabase #vector #ai
Screen shot of the APEX Gallery, with the Sample Vector Search App highlighted.
Screen shot of the Sample Vector Search App. A Vector search is done using the German word "Weltraum", and it finds entries related to space, regardless of the language.
0 1 11
JimTheWhyGuy
@jimthewhyguy.bsky.social
almost 2 years ago
Nice to see so many of my #oracleace and #oracledatabase and #orclAPEX colleagues out here at last. Welcome to the those of you escaping the hellsite formerly known as Twitter, now X ... so if we call it "Xitter" it does sound like the cesspool it has become for so many people. 😑
1 0 11
Andrej Pashchenko
@andrejsql.bsky.social
almost 2 years ago
The wait is over: #DOAG2024 starts tomorrow in Nuremberg. Want to learn about some advanced techniques and concepts around the practical use cases of #SQLMacros in #oracledatabase? Join me in the very first slot at 8:30
0 2 11
Andrej Pashchenko
@andrejsql.bsky.social
11 months ago
New post for #JoelKallmanDay! Ever wondered why the Oracle Optimizer sometimes ignores your histograms? Implicit data type conversions might be to blame. Here’s how to fix it without touching your SQL and with minimal schema impact. #Oracledatabase blog.sqlora.com/en/fix-op….
Fix Optimizer Estimate Issues from Implicit Conversions #JoelKallmanDay

blog.sqlora.com

Fix Optimizer Estimate Issues from Implicit Conversions #JoelKallmanDay

Learn how implicit RAW-to-VARCHAR2 conversions in Oracle break histograms, hurt optimizer estimates, and how to fix them safely.
0 1 8
Carsten Czarski 🤨
@cczarski.bsky.social
over 1 year ago
Something indeed was not right with that - and this is where the SDO_UTIL.DENSIFY_GEOMETRY comes in very handy. We get a line, which actually represents the flight path ... #oracledatabase #spatial #orclapex
Use SDO_UTIL.DENSIFY_GEOMETRY to get the actual shortest path between two coordinate pairs. select sdo_util.densify_geometry( sdo_geometry( 2002, 4326, null, sdo_elem_info_array(1,2,1), sdo_ordinate_array( 11.80, 48.36, -122.37, 37.62 ) ) ) as path from dual
The actual flight path (shortest path) visualized on a map.
0 0 7

Posts are pulled live from Bluesky and cached briefly. Posts with content labels are hidden.

View all posts on Bluesky

Explore trending tags

#art #oc #nsfw #furry #digitalart #fanart #furryart #AI #photography #gay #illustration #fcf
Back to all tags