Dear Shiva, We really appreciate your content. But one suggestion from my side is to upload the script and content of the video in some drive and share link in youtube. So that we can practise as well.
Image has to be loaded as BLOB data, either we can use UTL_FILE package to read as BLOB and insert using DML or we can use any other programming language to inder into table. I will explain with an example, please stay tuned.
In that example I have used UI project in python, that reads the data from database and display in browser, you can write in web based programming language you are comfortable with
Thanyou Sir , unfortunately I am unable to load the file , it says it is not getting the DATA_FILE , but I have kept it in the same folder :\ Path used: Conventional SQL*Loader-500: Unable to open file (DATA_FILE12.TXT) SQL*Loader-553: file not found SQL*Loader-509: System error: The system cannot find the file specified.
@Suvarna, Exactly the same, you can use BLOB column to store any binary data like, file, audio file, image, video etc.... Its up to the UI to read and display in the screen as per the format of the file. In this video, I have used python to read, instead you can JAVA + JDBC connectivity to read and convert into respective encoding format before displaying in UI scree. I will try to post a separate video on JAVA+ORACLE connectivity to store the binary content
