How to Use Databases Inside GitHub Actions
GitHub Actions is a platform that automates the build, test and deployment pipeline of your GitHub projects. Since its introduction, GitHub […]
Oracle Database
Technology
1 billion row challenge in SQL and Oracle Database
On the 1st of January 2024, Gunnar Morling launched The One Billion Row Challenge, fitting for a great start to the new
Introducing Oracle Database 23c Free
Oracle Database 23c Free, a free offering of the industry-leading Oracle Database that enterprises rely on every day, is now
Introducing the Oracle Database Error Help Portal
In a continuous effort to increase user productivity, we are pleased to introduce the new Error Help Portal for Oracle
JSON and Relational Tables: How to Get the Best of Both
JSON and relational tables have their strengths and drawbacks. How can you best harness those strengths in your work, while offsetting the drawbacks?
Oracle Database: why do I see “Logon failed because the client is missing the KZTVOV_KPCLOG_O9L_LP capability flag.” in the alert.log?
Last week I got pinged with an interesting question by a user: why do I see kpolnb: Logon failed because
PDB-modifiable Oracle Database Parameters
I got an interesting question the other day: “which Oracle Database Parameters are PDB-modifiable?”, i.e., which parameters can have different
Introducing Oracle Database 23c Free – Developer Release
Oracle Database 23c Free – Developer Release is a new, free offering of the industry-leading Oracle Database that enterprises worldwide rely on every
How to write an anonymous PL/SQL function and use it in your SQL statement
Have you ever encountered a situation when you were in the middle of writing a SQL query and thought, “if
How to cancel long-running queries in Oracle Database
This is a short blog post about a tiny little feature that you are probably unaware of but can make
Technology
Everything you always wanted to know about Oracle Database NLS_LANG and character sets
I have recently come across the Oracle Database Globalization Support again and the question of what character set is used
Technology
SOLVED: Oracle XE: ORA-00821: Specified value of sga_target is too small
tl;dr Open ${ORACLE_HOME}/assistants/dbca/templates/XE_Database.dbc with a text editor Find <InitParamAttributes><InitParams> Add the following XML tag under <InitParams>: <initParam name=”cpu_count” value=”2″/>