Resolution to the problem in connecting to the Oracle database
How to unlock sample Scott Schema in Oracle The sample Scott schema is good for learning Oracle but it does not come as default with Oracle installation. We need to install it separately. It is available to the user Scott. …
How to unlock HR user in Oracle 19c Once you have successfully installed Oracle database 19c, its time to unlock the sample schemas so that you can start learning Oracle SQL. In this article, we will see how to unlock …
How to install Oracle 19c In this article, we will be discussing how to install Oracle 19c on Windows 10 on your personal laptop. We will be installing Oracle 19.3. The system requirements to install Oracle 19c are: Minimum 2GB …
Joins in SQL Joins allow us to combine data from two or more tables based on Primary and Foreign keys. In this article, we will learn how Joins in SQL are implemented. Though join concepts are the same in all …
Download and Install AdventureWorks Sample Database In this blog, we will learn how to Download and Install AdventureWorks Sample Database. We will be using AdventureWorks2017.bak database. Same steps are applicable to restore any database from the backup. Error – No …
Install SQL Server 2019 Express Edition on Windows 10 SQL Server Express Edition is a good way to learn a database. It is a free edition of SQL Server, ideal for development and production for desktop, web, and small server …
Oracle PL/SQL practice questions On request of our students, please find below Oracle PL/SQL practice questions. These examples will use tables in Oracle’s sample database Scott. These exercises will require Oracle Installation. Please provide your solution/code in the comment section. …
After Oracle installation is done, it’s time to learn how to verify Oracle installation on windows 10. Following the below mentioned steps you can verify your installation and unlocking of the databases. How to verify Oracle Installation Go to your …
Primary Key and Foreign Key with example Primary keys and Foreign keys define the relationship between tables in a relational database system. In this blog, we will learn the concepts of Primary Key and Foreign Key with an example. What …