Tag: Oracle SQL

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

After creating a foreign key, you may need to drop the foreign key from the table. You can do this with the ALTER TABLE operator in Oracle/PLSQL. Syntax to drop a foreign key in Oracle /...

You will learn how to use foreign keys with cascade delete in Oracle PLSQL with syntax and examples. What are foreign keys with cascade delete? Foreign keys with cascade delete means that if a...

Foreign Keys is a way to ensure data integrity in your Oracle database. A Foreign Keys means that values in one table must also appear in another table.The reference table is called the...

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 primary key cannot contain the value NULL. A...

The CREATE SCHEMA operator does not actually create the circuit in Oracle. (Learn how to create a schema in Oracle.)The CREATE SCHEMA statement is only used to create objects (i.e. tables,...