yycwanderer

low key

[CTV News Calgary @CTVCalgary]

Missing Calgary boy last seen at Cambrian Heights day home: police https://t.co/iVv67rV1Cw

[yycwanderer @startupdba]

@Jung_Luna_ @BTSVancityARMYs Ooh. Thanks for the response!

[yycwanderer @startupdba]

@Jung_Luna_ @BTSVancityARMYs Congrats!
How much in total did it cost you? Including shipping and customs duties. TIA

[yycwanderer @startupdba]

Hey, #Canada, Check out this new band NYXORITH
https://t.co/Lpv7IlGXiD
They're rockin' it! 🔥

#yyc #calgary #rockband #numetal #altrock #calgarymusic #supportlocal
#alberta #calgarylocal #livemusic #rock #fypシ゚

[yycwanderer @startupdba]

@yooniesbf @BTSxCanada @BTS_twt Not in Calgary 😭

[RogersStadium @Rogers_Stadium]

Are you ready for BTS WORLD TOUR ‘ARIRANG’ IN TORONTO? They’re finally BACK! Tickets for the shows at Rogers Stadium on August 22 and 23 are on sale now: https://t.co/PJVvecOxvy

#방탄소년단 #BTS #BTS_WORLDTOUR_ARIRANG #BTS_WORLDTOUR_ARIRANG_TORONTO #BTS_WORLDTOUR_ARIRANG_NA

[yycwanderer @startupdba]

@LauCorreaaaaa @jinniebaby0T7 How much for w104 row 2?

[yycwanderer @startupdba]

@BTSVancityARMYs Oh wow. Thanks! 💜

[SQL Daily @sqldaily]

De-duplicate rows in #SQL query results with

SELECT DISTINCT col1, col2, ...

This returns one row for each unique combination of values stored in the DISTINCT columns

This should be a rare operation!

Repeated use of DISTINCT is often a sign of flaws in the query or schema

[SQL Daily @sqldaily]

Filter the rows returned by a #SQL query with

WHERE <condition>

<condition> can be any valid SQL condition, e.g.

number = 1
letter like 'A%'

You can combine conditions with AND/OR; the database returns rows where

AND - all conditions are TRUE
OR - any condition is TRUE

[BIGHIT MUSIC @BIGHIT_MUSIC]

[공지] BTS (방탄소년단) WORLD TOUR 개최 안내 (+ENG/JPN/CHN)

🔗 https://t.co/UN1hL6O0Gt

#방탄소년단 #BTS #BTS_WORLDTOUR

[Alberta Emergency Alert @AB_EmergAlert]

This is an Alberta Emergency Alert. The City of Calgary has issued a water supply alert.

This alert is in effect for all communities of Calgary’s water supply, including Airdrie, Strathmore, Tsuu T’ina Nation and Chestermere.

A feeder main break along 16 Avenue Northwest has impacted the city’s water supply. Supply levels remain in a critical state, affecting the city’s ability to provide water to communities and ensure adequate water is available for firefighting.

All residents and businesses must conserve water. Reduce indoor water consumption as much as possible.
Limit showers and flushing toilets.
Only do full loads in the dishwasher and washing machine.
Monitor local media or https://t.co/1lAYYzydTb for updates.

[Oracle Exadata @OracleExadata]

Looking for strategies, tools, and best practices to upgrade or migrate to Oracle Database 23ai? Don’t worry—Oracle Data Deep Dive at #AIWorld has the sessions you’re looking for. Learn more: https://t.co/P7RmGsDoI0

[SQL Daily @sqldaily]

Are you making any of these common #SQL mistakes?

Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions

Lukas Eder explains what to do instead & lists 7 more

https://t.co/k8ArDcvvUQ

[SQL Daily @sqldaily]

Oracle Database 21c enhanced FOR LOOPs in PL/SQL to enable you to use

Custom increments (BY)

Lists of values to loop through

Conditions to skip the loop body (WHEN)

Expressions to set the next value (REPEAT WHILE)

Mutable iterands to set their value inside the loop (MUTABLE)

[Oracle APEX @OracleAPEX]

🛠️ Oracle APEX 24.2 Patch Set Bundle 10 is available!

Learn More: https://t.co/V6KmDJFwVJ

Known Issues: https://t.co/MBG4vDRDG6

#orclAPEX

[SQL Daily @sqldaily]

You can subtract one year from a date in Oracle #SQL with either

ADD_MONTHS ( dt, -12 )
- INTERVAL '1' YEAR

But take care - these handle 29th Feb differently:

ADD_MONTHS => 29th Feb -> 28th Feb in previous year
INTERVAL => 29th Feb -> 29th Feb in previous year => error!

[SQL Daily @sqldaily]

Create blockchain tables in Oracle Database with

CREATE BLOCKCHAIN TABLE ... ( ... )
NO DROP UNTIL n DAYS IDLE
NO DELETE UNTIL n DAYS AFTER INSERT
HASHING USING SHA2_512 VERSION "v1"

These

Allow INSERT
Disallow UPDATE
Disallow DELETE/DROP until you wait N days as defined

[Oracle APEX @OracleAPEX]

🚀Learn 4 Free Ways to get started with Oracle APEX!

https://t.co/xfKIkksgEC

#orclAPEX #LowCode