Resolution to the problem in connecting to the Oracle database
Read MoreHow 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. In this blog, we will see how to unlock sample Scott user so that we…
Read MoreHow 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 HR user in Oracle 19c. High-level steps to be followed Use the command prompt (cmd)…
Read MoreHow 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 of free RAM 10GB of free hard-disk space A processor based on Intel EM4T or…
Read MoreJoins 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 databases, here we will learn about joins in Oracle. If you are new to Oracle,…
Read MoreDownload 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 backupset selected to be restored If you get an error – “No backupset selected to…
Read MoreInstall 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 applications. In this blog, we will tell you how to install SQL Server 2019 Express…
Read MoreOracle 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. Note: This blog does not contain the solutions, since it will fail the purpose. If…
Read MoreAfter 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 windows start program and type Oracle – HOME_NAME and select Open file location. This will take…
Read MorePrimary 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 is a Primary Key? Every table in a database must have a Primary key. The…
Read More