Oracle Change Database Name

change database in oracle error ora-01127

In this Oracle tutorial, we will learn how to change the name of the database in Oracle Database 21c, 19c, and 12c. Oracle change database name Oracle Database name can be changed using the NID tool, which is installed by default when installing Oracle Database 21c on the Windows operating system. Please note that the database … Read more >>

Oracle rowid Datatype

Using raw datatype in oracle 21c

In this Oracle tutorial, we will learn about the rowid datatype in the oracle database. Also, we will illustrate how to use it to create rowid columns for a table in oracle. Oracle rowid Datatype The ROWID datatype in Oracle 21c stores the unique address of a row in a database table. It is 18 characters long … Read more >>

Exception Handling in SQL Server

Exception handling in SQL Server

I recently worked on creating the table and encountered an error. Errors are common in a development project. Exception handling or Error handling is an essential concept in software development. Like other programming languages, namely C, C++, and Java, SQL Server also provides exception handling. TRY and CATCH can handle errors in SQL Server. This … Read more >>

MariaDB Insert If Not Exists

MariaDB Insert If Not Exists Else Update

In this MariaDB tutorial, we will discuss how to use the MariaDB Insert If Not Exists condition and look at several examples related to it. MariaDB Insert If Not Exists Here we will understand how to insert rows in the table if it does not exist in MariaDB. This is because when we have a … Read more >>

View Line Numbers in SQL Server Management Studio

View line numbers in SQL Server Management Studio

While creating the function, I encountered an error and was unable to find the exact line. After several checks, I found the line number in SQL Server Management Studio. In this SQL Server tutorial, we will learn how to view line numbers in SQL Server Management Studio. View Line Numbers in SQL Server Management Studio SQL … Read more >>

SQL Server stored procedure return value

SQL Server stored procedure return value 0

In this SQL Server tutorial, we will discuss how to return value from stored procedure and how to return some specific values from a stored procedure, etc. SQL Server stored procedure return value In SQL Server 2019, there are mainly 3 methods for returning some values from a SQL stored procedure to its caller. All three methods are … Read more >>

How to execute stored procedure in SQL Server

How to execute stored procedure in SQL Server using ssms

In this SQL Server tutorial, we will learn how to execute stored procedure in SQL Server. We will also discuss different examples related to the execution of stored procedures in SQL Server. Here is the complete list of topics that we are going to discuss. How to execute stored procedure in SQL Server Note:- Before starting this topic, … Read more >>

How To Create Table From View In SQL Server

Create a table from view in SQL Server

In this SQL Server tutorial, we will learn how to create a table from view in SQL Server. Here we will illustrate this implementation using an example. Moreover, we will also cover the following topics. Create table from view in SQL Server In this section, we will learn to create a table using a view in SQL … Read more >>

SQL Server Date Format Example

Sql Server date format mm-dd-yyyy example

This SQL Server tutorial will teach us how SQL Server Date Format dd mm yyyy works. Moreover, we will discuss and learn some examples so that you can understand the concept much better. SQL Server Date Format Example Let us discuss all the cases individually with proper examples. SQL Server Date Format mm dd yyyy In … Read more >>

How to see view definition in SQL Server

How to see view definition in SQL server using query

In this SQL Server tutorial, we will understand how to see view definition in SQL Server. Additionally, we will also illustrate the following set of topics. But, before we start this topic, we recommend you learn about the basics of View in SQL Server. How to see view definition in SQL Server In this section, we will illustrate … Read more >>

Top 200 SQL Server Interview Questions and Answers

Free PDF On Top 200 SQL Server Interview Questions And Answers

Download A 40 pages PDF And Learn Now.