Oracle Primary Keys.
- 8 August 2022
- Database Performance ManagementManuals
In Oracle PLSQL primary key is a single field or a combination of fields that determines the uniqueness of the record. Fields that are part of the pri…
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…
Why should the MySQL GROUP CONCAT function be used?
This is the function MySQL GROUP CONCAT and how it can change the work with query results. Especially if the database is the data source for the appli…
Encryption of stored data in MySQL 8.
- 5 August 2022
- AIDatabase Performance Management
MySQL 5.7.11 introduced transparent encryption for InnoDB table space, which included support for table space files. Later, encryption for the shared …
Oracle CASE statement.
In Oracle statement CASE has IF-THEN-ELSE functionality. Starting with Oracle 9i, you can use a CASE statement in an SQL sentence….
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!