How to install Oracle Database 21c Express Edition on Windows| Download, SQL Developer Configure HR

Video Description

Hello Friends, Please check the below information, Download link for Oracle 21c Express Edition -------------------------------------------------------------------------------- Option 1:: ----------------- https://www.oracle.com/in/database/technologies/xe-downloads.html Option 2 :: ---------------- https://drive.google.com/file/d/1DpAps32uoYr0-zL5rda4Qs9BAsvBcMk_/view?usp=sharing Download link for Oracle SQL Developer :: -------------------------------------------------------------------------------- Option 1:: ----------------- https://www.oracle.com/tools/downloads/sqldev-downloads.html Option 2 :: ---------------- https://drive.google.com/file/d/1zqVCYDyKu5bGzb8vF9W3TadRDC6UySaX/view?usp=sharing --------------------------------------------------------------------------- Unlock/ Install HR Schema SQL Commands :: --------------------------------------------------------------------------- Firstly, Download HR Schema ZIP File from below link, https://drive.google.com/file/d/13Q6YX_fdkDgwAO-ToeVN8HvSIqYBu-v7/view?usp=sharing Later, extract the ZIP file and Place this folder as shown in video. First SQL File to be Executed :: ---------------------------------- @ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql Parameter 1 :: ---------------------- hr Parameter 2 :: ---------------------- users Parameter 3 :: ---------------------- temp Parameter 4 :: { Only this will change} ---------------------- admin Parameter 5 :: ---------------------- $ORACLE_HOME/demo/schema/log Parameter 6 :: ---------------------- localhost:1521/XEPDB1 ------------------------------------------------------------------------------ Except Parameter 4, all are CONSTANT Values, there won't be any changes ------------------------------------------------------------------------------ Second SQL File to be Executed :: ---------------------------------- @ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_cre.sql Third SQL File to be Executed :: ---------------------------------- @ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_popul.sql Fourth SQL File to be Executed :: ---------------------------------- @ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_idx.sql Fifth SQL File to be Executed :: ---------------------------------- @ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_code.sql Sixth SQL File to be Executed :: ---------------------------------- @ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_comnt.sql Final SQL File to be Executed :: ---------------------------------- @ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_analz.sql =================================================== Thanks, Please Subscribe, Share, Like and Comment on this Video.