Hello Friends,
Please follow/ Execute the below steps as shown in the Video
=============================================================
**************** Website to be launched Soon *************************
=============================================================
Watch complete Setup Video for Oracle Database 21c Express Edition Software on Windows Operating System
=============================================================
Video Link : • How to install Oracle ...
Download link for Oracle 21c Express Edition
--------------------------------------------------------------------------------
Option 1::
-----------------
www.oracle.com/in/database/te...
Option 2 ::
----------------
drive.google.com/file/d/1DpAp...
Download link for Oracle SQL Developer ::
--------------------------------------------------------------------------------
Option 1::
-----------------
www.oracle.com/tools/download...
Option 2 ::
----------------
drive.google.com/file/d/1zqVC...
---------------------------------------------------------------------------
Unlock/ Install HR Schema SQL Commands ::
---------------------------------------------------------------------------
Firstly, Download HR Schema ZIP File from below link,
drive.google.com/file/d/13Q6Y...
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.
13 мар 2022
