Tag: SQL

Reflecting on security in MySQL installation, you can consider a wide range of possible procedures/recommendations and their impact on the security of your MySQL server and related...

In this post you will learn how to get the number of MySQL lines in a database. Getting the number of MySQL rows in one table To get the number of rows per table, you use the COUNT(*) operator...

The Oracle condition AND (also called AND operator) is used to check two or more conditions of SELECT, INSERT, UPDATE or DELETE operators. Syntax of the AND condition in Oracle/PLSQL WHERE...

Comparison operators are used in the WHERE sentence to determine which records to select. Here is a list of comparison statements that you can use in Oracle PL/SQL:Comparator...

In Oracle, the EXIT statement is most commonly used to complete a LOOP cycle. EXIT statement Syntax EXIT [WHEN boolean_condition]; Options and arguments of the operatorboolean_condition...

In Oracle, the WHILE LOOP cycle will be executed as long as the condition is true. Syntax of the WHILE LOOP operator WHILE condition LOOP {...} END LOOP; Operator parameters and...

Oracle/PLSQL CURSOR FOR LOOP Statement can be used when you want to upload and process each cursor entry. CURSOR FOR LOOP will end when all records are taken out of the cursor. Syntax of CURSOR...

In Oracle/PLSQL, the FOR LOOP cycle allows you to execute code again for a fixed number of times. FOR LOOP statement syntax FOR loop_counter IN [REVERSE]...

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. LOOP statement Syntax LOOP {...} END...

The GOTO statement calls for code to go to the tag after the GOTO statement. The syntax for the GOTO statement in Oracle / PLSQL consists of two parts - GOTO statement and LABEL_NAME (transition...

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 values or values that are out of...

MySQL 5.7.11 introduced transparent encryption for InnoDB table space, which included support for table space files. Later, encryption for the shared table space was introduced in MySQL...

In Oracle statement CASE has IF-THEN-ELSE functionality. Starting with Oracle 9i, you can use a CASE statement in an SQL sentence. Syntax of CASE statement CASE [ ] WHEN condition_1 THEN...

In Oracle, the IF-THEN-ELSE operator is used to execute code when the condition is TRUE (true), or execute another code when the condition is FALSE (false). Syntax (IF-THEN) IF THE CONDITION...

In this post you will learn how to create, delete, disable, and enable unique constraints in Oracle with syntax and examples.A unique constraint is a single field or a combination of fields...

In this post you will learn how to create, rename and drop indexes in Oracle/PLSQL with syntax and examples. What are indexes in Oracle? In Oracle, Indexes is a performance tuning method to...