Tag: PL/SQL
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,...
Oracle Role is a set or group of privileges that can be granted to users or other roles. It is a great way for database administrators to save time and effort. Create Oracle Role The role is...
You can grant and revoke privileges for different database objects in Oracle. We will first look at how to grant and remove table privileges, and then how to grant and remove privileges to...
Set a default persistent table space First, make sure you create a permanent table space.Then you will need to modify the Oracle database to use the persistent table space as the default...
To find the default permanent tablespace in Oracle, you can run the following SELECT operator. Default persistent tablespace SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME...