Oracle delete cascade; Foreign Keys with cascade delete.
- 8 August 2022
- Database Performance ManagementMachine learning
You will learn how to use foreign keys with cascade delete in Oracle PLSQL with syntax and examples….
Creating databases and tables using SQL commands.
This article will show you how to create new databases and tables using SQL commands in a mysql client. It is assumed that this tool is running and co…
Oracle CASE statement.
- 5 August 2022
- Database Performance ManagementMachine learning
In Oracle statement CASE has IF-THEN-ELSE functionality. Starting with Oracle 9i, you can use a CASE statement in an SQL sentence….
Oracle LOOP statement.
- 4 August 2022
- Database Performance ManagementMachine learning
In Oracle, the LOOP statement is used when you are not sure how many times you want to execute a loop body or execute a loop body at least once….
Optimized permanent minimization in MySQL 8.0.
In MySQL 8.0.16 optimizer has improved again!Comparisons of columns of numeric types with constants are checked and stacked or deleted for invalid val…
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!