Steffen Clauß
@steffenclauss.bsky.social
#orclapex developer, #BVB ...
Opinions are my own | So long, and thanks for all the fish...
Opinions are my own | So long, and thanks for all the fish...
Reposted by Steffen Clauß
AutoUpgrade New Features: Run root.sh After Oracle Home Creation
AutoUpgrade Patching continues to make it even easier to patch your Oracle Database. After installing a new Oracle home, it will automatically run the root.sh script if there's sudo privileges.
AutoUpgrade Patching continues to make it even easier to patch your Oracle Database. After installing a new Oracle home, it will automatically run the root.sh script if there's sudo privileges.
AutoUpgrade New Features: Run root.sh After Oracle Home Creation
AutoUpgrade Patching continues to make it even easier to patch your Oracle Database. After installing a new Oracle home, it will automatically run the root.sh script if there's sudo privileges.
dohdatabase.com
May 20, 2025 at 5:14 AM
AutoUpgrade New Features: Run root.sh After Oracle Home Creation
AutoUpgrade Patching continues to make it even easier to patch your Oracle Database. After installing a new Oracle home, it will automatically run the root.sh script if there's sudo privileges.
AutoUpgrade Patching continues to make it even easier to patch your Oracle Database. After installing a new Oracle home, it will automatically run the root.sh script if there's sudo privileges.
Reposted by Steffen Clauß
Today's fun discovery
ALTER SESSION DISABLE COMMIT IN PROCEDURE
=> if a PL/SQL procedure has a commit it raises an ORA-00034 instead!
=> you can rollback across PL/SQL calls with commits
Note: DML in the proc is rolled back unless you catch the ORA-34
This "new" feature is at least 20 years old!
ALTER SESSION DISABLE COMMIT IN PROCEDURE
=> if a PL/SQL procedure has a commit it raises an ORA-00034 instead!
=> you can rollback across PL/SQL calls with commits
Note: DML in the proc is rolled back unless you catch the ORA-34
This "new" feature is at least 20 years old!
February 20, 2025 at 9:54 AM
Today's fun discovery
ALTER SESSION DISABLE COMMIT IN PROCEDURE
=> if a PL/SQL procedure has a commit it raises an ORA-00034 instead!
=> you can rollback across PL/SQL calls with commits
Note: DML in the proc is rolled back unless you catch the ORA-34
This "new" feature is at least 20 years old!
ALTER SESSION DISABLE COMMIT IN PROCEDURE
=> if a PL/SQL procedure has a commit it raises an ORA-00034 instead!
=> you can rollback across PL/SQL calls with commits
Note: DML in the proc is rolled back unless you catch the ORA-34
This "new" feature is at least 20 years old!
Reposted by Steffen Clauß
Checking if rows match some criteria?
Instead of
SELECT COUNT(*) FROM ...
Use
EXISTS ( SELECT * FROM ...
COUNT gets all the rows; EXISTS can stop when it finds a match
As @lukaseder.bsky.social says
Thou shalt not use COUNT(*) when EXISTS sufficeth thy need
Instead of
SELECT COUNT(*) FROM ...
Use
EXISTS ( SELECT * FROM ...
COUNT gets all the rows; EXISTS can stop when it finds a match
As @lukaseder.bsky.social says
Thou shalt not use COUNT(*) when EXISTS sufficeth thy need
Avoid using SQL COUNT(*) when you could use SQL EXISTS
When checking for the existence of data, avoid using COUNT(*) > 0 as many implementations will nto be able to avoid the work of calculating the exact count
buff.ly
December 10, 2024 at 12:00 PM
Checking if rows match some criteria?
Instead of
SELECT COUNT(*) FROM ...
Use
EXISTS ( SELECT * FROM ...
COUNT gets all the rows; EXISTS can stop when it finds a match
As @lukaseder.bsky.social says
Thou shalt not use COUNT(*) when EXISTS sufficeth thy need
Instead of
SELECT COUNT(*) FROM ...
Use
EXISTS ( SELECT * FROM ...
COUNT gets all the rows; EXISTS can stop when it finds a match
As @lukaseder.bsky.social says
Thou shalt not use COUNT(*) when EXISTS sufficeth thy need
Reposted by Steffen Clauß
New Oracle Red Bull Racing race car from Lego announced. You can pre-order now 🏎️
#oracle #Lego
www.lego.com/en-dk/produc...
#oracle #Lego
www.lego.com/en-dk/produc...
Oracle Red Bull Racing RB20 F1® Race Car 77243 | Speed Champions | Buy online at the Official LEGO® Shop DK
Build your own Red Bull Formula 1® race car
www.lego.com
November 22, 2024 at 5:38 PM
New Oracle Red Bull Racing race car from Lego announced. You can pre-order now 🏎️
#oracle #Lego
www.lego.com/en-dk/produc...
#oracle #Lego
www.lego.com/en-dk/produc...
Reposted by Steffen Clauß
