Tag: PL/SQL

In Oracle PL/SQL, the %ROWTYPE attribute provides a record type representing a string in the Oracle database table (or view).A record may store an entire string of data selected from the...

Record type is a group of linked data elements stored in fields, each with its own name and data type. You can use Record as a variable, which may contain a table row or some columns (fields)...

Oracle BETWEEN condition (also called BETWEEN operator) is used to obtain values within a range in SELECT, INSERT, UPDATE or DELETE sentences. Syntax of BETWEEN condition in...

Oracle IS NOT NULL condition  is used to check for the value NOT NULL. You can use the Oracle condition IS NOT NULL either in an SQL sentence or in a block of PLSQL code. Syntax for IS NOT...

The Oracle IS NULL condition is used to check the NULL value. You can use the IS NULL condition either in an SQL sentence or in a block of PLSQL code. Syntax for IS NULL condition in...

The Oracle IN condition (also called the IN operator) determines whether a value or a list of values corresponds to an expression in the specified resulting SELECT, INSERT, UPDATE or DELETE...

Oracle condition REGEXP_LIKE allows to execute regular expressions in WHERE proposal in SELECT, INSERT, UPDATE or DELETE queries. Syntax for REGEXP_LIKE in Oracle/PLSQL REGEXP_LIKE (...

Oracle condition LIKE allows to use wildcards which will be used in WHERE operator in SELECT, INSERT, UPDATE or DELETE queries. This allows comparison with a pattern. LIKE syntax in...

The Oracle NOT condition (also called NOT operator) is used to negate the condition in SELECT, INSERT, UPDATE or DELETE sentences. Syntax of the NOT condition in Oracle/PLSQL NOT...

Oracle AND and OR conditions can be combined in SELECT, INSERT, UPDATE or DELETE operators.When combining these conditions, it is important to use parentheses so that the database knows how...

The Oracle OR condition (also called the OR statement) is used to check several conditions in which records are returned when a particular condition is true. It can be used in SELECT, INSERT,...

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...