Oracle add primary key

Oracle how to add primary key

In this Oracle tutorial, we will learn how to add the primary key in oracle 19c and 21c. Also, we will cover the following topics in this tutorial. Oracle how to add primary key Oracle add primary key syntax Oracle how to add column to primary key Oracle how to change primary key Oracle add primary …

Read more

Oracle to_date Format [Complete Guide]

Oracle to_date format 24 hours

In this Oracle tutorial, we will discuss the oracle to_date format function. Using the to_date format, you can convert the char, varhcar2, nchar, or any other string format to the Date format. Furthermore, we will also cover these topics. Oracle to_date format Oracle to_date format sample Oracle to_date format syntax Oracle to_date format 24 hours …

Read more

Stored procedure in SQL Server for insert and update

Stored procedure for insert and update in SQL Server

In this SQL Server tutorial, we will study how to create a stored procedure in SQL Server for insert and update operations. Additionally, we will also discuss the following set of topics in this tutorial. Stored procedure for insert and update in SQL Server Stored procedure in SQL Server for inserting data into a table Stored procedure …

Read more

Temp table in stored procedure in SQL Server

Create local temp table in stored procedure in SQL Server

In this SQL Server tutorial, we will learn how to use and create a temp table in stored procedure in SQL Server. Moreover, we will also illustrate the following set of topics. Create temp table in stored procedure in SQL Server Create local temp table in stored procedure in SQL Server Create global temp table in stored …

Read more

SQL Server Datetime functions examples

SQL Server first day of month

In this SQL Server tutorial, we will discuss some examples related to the DateTime data type in SQL Server. We will also discuss some SQL Server DateTime functions that you can use to get the date and time information. SQL Server first day of month SQL Server last day of month Get current month start date and …

Read more

SQL Server User Permissions

How to check user permissions in SQL Server management studio

In this SQL Server tutorial, we will discuss some of the ways to manage user permissions in a SQL Server database. In SQL Server, authorization is maintained using permissions at different levels. Various objects in the database can be accessed by some specific users or roles. In this article, we will discuss how these permissions are managed …

Read more

Pass parameters to view in SQL Server

Can we pass parameters to a view in SQL Server

In this SQL Server tutorial, we will discuss how to pass parameters to view in SQL Server. Further, we will also illustrate the following topics in this tutorial. Can we pass parameters to a view in SQL Server? Can we parameterize a view in SQL Server? Can we use variables in SQL Server View? Create view with if …

Read more

Postgresql For Loop + Examples

flowchart of PostgreSQL for loop

In this PostgreSQL tutorial, we will study the use of PostgreSQL For Loop and we will also cover multiple examples. There are lists of the topic that comes under discussion is given below: Postgresql for loop Postgresql for loop select Postgresql for loop insert Postgresql for loop without function Postgresql for loop variable Postgresql for loop …

Read more