Shivam Dogra 
In this Oracle tutorial, we will learn how to add row numbers to the oracle database. We are working on Oracle database 19c but the steps shared in this tutorial will work on all the versions of the oracle database. Run the below script to create a table with records. Moving forward, we will use … Read more >>
In this Oracle tutorial, we will learn about the oracle to_char date format using various examples. Additionally, we will also cover these topics: Oracle to_char date format Oracle to_char date format options Oracle to_char date format milliseconds Oracle to_char date format microseconds Oracle to_char date format am/pm Oracle to_char date form at in where clause … Read more >>
In this Oracle tutorial, we will learn how to add foreign key constraints to the oracle database. We are currently working on oracle 19c but this tutorial will work for all the versions of the oracle database. Here is the list of topics that we are going to discuss. Oracle how to add foreign key … Read more >>
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 A primary key in Oracle identifies each row uniquely in the table. There are two major properties of primary key: While fetching … Read more >>
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 converts the date from string data type (char, varchar2, etc) … Read more >>
For a stored procedure for insert and update in SQL Server, you write two: an INSERT returning the new ID through an OUTPUT parameter, and an UPDATE by key that checks @@ROWCOUNT. For bulk rows, a table-valued parameter beat a loop 38 to 1. Quick answer: SET @NewID = SCOPE_IDENTITY(); after the INSERT, and IF … Read more >>
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. Here we are using SQL Server 2019 and SQL Server Management Studio. Create temp table in stored procedure in SQL Server As the name indicates, a temp table … Read more >>
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 In some scenarios, you may need to find the first day of … Read more >>
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? No, in SQL Server, we cannot pass parameters to a view. And it can be considered as one main limitation … Read more >>
In this SQL Server tutorial, we will discuss how to drop a stored procedure in SQL Server. I will explain what are the various methods to drop stored procedures with the help of some examples. Prerequisite for this tutorial: What is a stored procedure in sql server How to drop stored procedure SQL Server? If you want … Read more >>