In this article, you will learn how to use the PostgreSQL CASE conditional expression to form conditional queries. The PostgreSQL CASE expression is the same as IF/ELSE statement in other programming languages. General Usage: [crayon-663cea9f508a4562739250/] Let’s make the following comments according to the name of the movie in the movies table and the lenght of … The post PostgreSQL CASE Statements first appeared on Database Tutorials. The post PostgreSQL CASE Statements appeared first on Database Tutorials ..read more

This Oracle tutorial explains how to use the Oracle CREATE TABLE AS statement with syntax and examples. In some cases, we can create an exact replica of a table or one that meets certain conditions. In such cases, only the NOT NULL constraint is passed to the new table. Other constraints are not passed. We … The post CREATE TABLE AS Statement first appeared on Database Tutorials. The post CREATE TABLE AS Statement appeared first on Database Tutorials ..read more

In this tutorial, you will learn how to use the PostgreSQL IF ELSE statements to execute a command based on a specific condition. if-then statement The if statement works when the condition is true. Below is the simplest form of the if statement: [crayon-6638e7fa3db37023007580/] if-then-else statement The if…then…else statement executes the statements in the if … The post PostgreSQL If Else Statement first appeared on Database Tutorials. The post PostgreSQL If Else Statement appeared first on Database Tutorials ..read more

In today’s article, we will be examining Tables In Oracle Database, which are the simplest structures in which data is stored. There are 8 types. We can learn detailed information about tables and columns from the views below. [crayon-66365adc7ad92510286733/] Tables and indexes should be stored in different tablespace. If we want to write comments about … The post Tables In Oracle Database first appeared on Database Tutorials. The post Tables In Oracle Database appeared first on Database Tutorials ..read more

In today’s article, we will be learning how to make a Oracle AutoExtend Datafile on. 1. First, we must find a datafile that is not auto extent. [crayon-662fbd4995c37078074001/] 2. Then we make the datafile “AUTOEXTEND ON” as follows. [crayon-662fbd4995c42865309928/] The post Oracle Datafile Autoextend On first appeared on Database Tutorials. The post Oracle Datafile Autoextend On appeared first on Database Tutorials ..read more

I mentioned in my previous articles that Postgresql can be written in more than one language, in this article we will be talking about the Postgresql plperl language. To use the plperl language, you need to make the necessary installations for perl on whichever operating system you are using. [crayon-662d63397a0a3189098165/] The post Function Example In PostgreSQL Pl\Perl Language first appeared on Database Tutorials. The post Function Example In PostgreSQL Pl\Perl Language appeared first on Database Tutorials ..read more

In today’s article, we will be discussing the question of how to add a data file to the tablespace in Oracle? 1. We learn columns and data types from dba_data_files. We can find out whether dba_data_files is a view or a table as follows. In TOAD, we type dba_data_files on the editor screen and move … The post How To Add The Datafile To Tablespace first appeared on Database Tutorials. The post How To Add The Datafile To Tablespace appeared first on Database Tutorials ..read more

In this section, we will understand the operation of PostgreSQL functions and learn how to use the function. Like operations in programming languages, user-defined operations in PostgreSQL are plpgsql commands that accept parameters, perform an operation such as a complex calculation, and return the result of this operation as a value. The return value can … The post PostgreSQL Functions first appeared on Database Tutorials. The post PostgreSQL Functions appeared first on Database Tutorials ..read more

In this article, you will learn about the PostgreSQL assert statement and how to use it for debugging purposes. Although the assert command is similar to the RAISE command, its uses are different. In the assert command, unlike raise, we need to put a condition and write the message we want to print by placing … The post PostgreSQL Assert Statement first appeared on Database Tutorials. The post PostgreSQL Assert Statement appeared first on Database Tutorials ..read more

In today’s article, we will be learning how to take an online tablespace offline so that it is temporarily unavailable for general use. If a tablespace is made “Offline”, the data files belonging to that tablespace will also be offline. When a tablespace is made “Offline”, the “CHECKPOINT” operation occurs. When a tablespace is made … The post How To Take Talespace Offline first appeared on Database Tutorials. The post How To Take Talespace Offline appeared first on Database Tutorials ..read more