Low Code App Dev with Oracle APEX: Building a Simple Movie App

This video introduces Low Code Application Development and how you can use Oracle APEX, the native low code platform of the Oracle Database, to quickly and easily build a compelling application from scratch.
The demonstration begins with a simple spreadsheet containing movies data that we turn it into a full fledged app that includes a dashboard, ad-hoc reporting and analysis, faceted search.. and dark mode!
You can download the app export (with sample data) here: bit.ly/apex-si...
Right-click to download the file.
Note: The CSV file is part of the application and uploaded into the Shared Components, Static Files. Once you have installed the app, run it and on the homepage, there is a link to download the sample movie set.
This video uses Oracle APEX 19.2 and was recorded on January 8, 2020.

[@stonekid8250]

amazing ! i felt like he is talking with showing me all the things. i will definitely give this a try

[@leonidaschrisochoou1529]

A great presentation and introduction to Oracle APEX, as always I must say, from Shakeeb

[@OracleAPEX]

Thank you for the kind words! I'm glad you enjoyed it!

[@itsQuark]

Excellent Shakeeb, your are for sure tempting us to check Oracle Apex again!

[@alexbershtansky8433]

Respect Shakeeb!It was pleasure to meet You on ILOUG Apex Forum!

[@johnachee1395]

Best APEX presentation I've seen. How did you generate the CSV movies file? Very few of the image URLs are valid now, I'd like to continue working on this its a very cool use case. Did you use the tmdb API to extract the data? Or is there a read-to-go movie file I can just go and download?

[@OracleAPEX]

Thanks for your comment, John ! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@tharunichandu]

Great tutorial!!! But the download export with sample data link is showing as link deactivated, is there a new one?

[@OracleAPEX]

Hello! Thanks for your comment. The link has been updated in the video description. You can also access it here: bit.ly/apex-simple-movies-app-export

[@namrapiyush]

Really good work Shakeeb. You inspired me to learn APEX now. :)

[@mindboostmotivation3198]

nice article . can we use it on cloud domain?

[@ankanchanda8272]

I am not able to download the link. Can you please post it again from where its downloadable?

[@OracleAPEX]

Thanks for reaching out, Ankan! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@worse-than-gnomes]

Great presentation. A lot of material covered here. ⭐️⭐️⭐️⭐️⭐️

[@igordozor]

Epic presentation. Just brilliant.

[@necatiuygun5571]

Thank you. Where can I find the csv file ?

[@OracleAPEX]

Thanks for reaching out, Necati! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@mohammedqamarulhaq8980]

I am not able to find the HTML coding side for the Movies card part neither the columns in the search results area. Can anyone help me with this?

[@Bruhfinally]

Movies app with no video feature? Does apex integrate a video component or embed a video player like KZbin?

[@TechMining69]

Yes, Shakeeb can do this with excellence.

[@cerenbulbul5373]

Could you share your dataset, please?

[@OracleAPEX]

Thanks for reaching out, Ceren! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@suvashishdas7739]

great example of faced search . thanks for share this nice work

[@ayushdas17]

is there any video integration option in Apex

[@leandroborelli644]

Amazing! Have used the same concept to create my own workout app

[@danshen52]

Great tutorial! But the download export with sample data link is not working any more..... do you have a new one?

[@OracleAPEX]

Thanks for reaching out, Dan! The link has been updated in the video description. You can also access it here: bit.ly/apex-simple-movies-app-export If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@Bryant-oi1or]

Where can I find the movies.csv file? I would like to practice this demo.

[@devangthakkar8301]

same quetion ?

[@OracleAPEX]

Hi, Bryant! Thanks for reaching out! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@OracleAPEX]

@@devangthakkar8301 Hello, please use the link above to download the file. (video description). If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@daxelai]

I want to play move from my google cloud and Google cloud movie path store in database. How I can do that

[@Bruhfinally]

Great presentation. Truly well done.

[@marceloosorio525]

Thanks Team, but after import I just was able to see the app , but without any object...tables & data....

[@OmarMohamed-ro7jn]

Can i please have the app export (with the sample data) because the link is expired

[@mohamedsameer3549]

Great work , I love oracle apex and it's really helps me a lot. One day I'll join oracle apex team to develop more features for beginners level programmer like me.

[@ahmedharoon2740]

can you help, in 19.2 (current ver) how I can implement 2 things, in IG I want to have a button or link in every row to open a Modal Dialog ( keep in mind, a blank row should have a working button / link ) and from that Modal Dialog - Interactive Report user will click on a row and that row should return 3 columns to populate calling IG row 3 columns. This is just like a LOV in Oracle Forms which return multiple columns.

[@OracleAPEX]

Thank you for the kind words!

[@aymansaied3756]

Great presntation as usual Shakeeb :)

[@renovatiodre]

Where can I get the Excel file to practice. I am doing a project for University. Please help!

[@OracleAPEX]

Thanks for reaching out, Sebastian! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@softnetworks]

download link not working kindly give me new link from where i can download source code or sample app?

[@OracleAPEX]

Hello! Thanks for reaching out, Khurran! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@ukmconsulting8355]

Great presentation, as a newcomer in ora db and non coder background, make me see the potentials. Thank you ....

[@OracleAPEX]

Thanks for your feedback! We're glad you enjoyed it!

[@ahmedharoon2740]

can somebody guide, in 19.2 (current ver) how I can implement 2 things, in IG I want to have a button or link in every row to open a Modal Dialog ( keep in mind, a blank row should have a working button / link ) and from that Modal Dialog - Interactive Report user will click on a row and that row should return 3 columns to populate calling IG row 3 columns. This is just like a LOV in Oracle Forms which return multiple columns.

[@sohailnawaz2473]

I downloaded and imported sample app, but table is missing. How to install underlying table?

[@satria78ful]

How do I import data into Apex? To access the new Data Loading utility, Navigate to SQL Workshop > Utilities > Data Workshop. You'll see a drop zone which allows to drag files to be uploaded. Drag a file to be uploaded here.

[@juliorengifotanchiva6894]

Great work

[@khadijashahzad9130]

Can i get the excel data sheet

[@fabianoteixeira9259]

The link to download the app export is broken. Can you fix it, please?

[@OracleAPEX]

Hello! Thanks for reaching out, Fabiano! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@santiagokilling1165]

very good explanation.

[@batoolazzam3985]

Where can I find the csv file ?

[@OracleAPEX]

Hello! Thank you for your message. Please see file access instructions in the video description details.

[@hamdiraouafi6143]

I can't find the CSV File.

[@OracleAPEX]

Thanks for your comment, Hamdi ! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@hernandezdrums81]

@@OracleAPEX Hi, i can´t find the cvs file in the APEX Community, do you have de direct url to download. Thanks!!!!!

[@kahsan07]

Thanks for Very good presentation. Please give the like of Movie Dataset.

[@OracleAPEX]

Thank you for watching! We've updated the description to provide a link to download the app export. It also includes the sample data used.

[@SazidAhmedNassir]

Sir please make more project base video

[@aminebouazizi3767]

this link of download is incorrect , please put an other link !!!

[@OracleAPEX]

Thanks for reaching out, Amine! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@rasiyanin]

Nice realizing of apex abilities!

[@PraveenKumar-bv3hg]

The link does not work now...can you please update the link..Thanks

[@OracleAPEX]

Thanks for reaching out, Praveen! Please try again. If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@lauroribeirotrader4952]

Thank you.

[@mohammadkhattab3103]

Thank you ..!!

[@mohammedabbas110]

Very nice demo..

[@duytringuyen7123]

I can't download the app export with sample data ???

[@OracleAPEX]

Thanks for reaching out, Duy! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@mohcineregragui3274]

Alooots of images not working !!!!

[@chaitanyashah527]

Hello how to get the poster path?

[@OracleAPEX]

Hi, Chaitanya! Thanks for reaching out! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@sralinternational8364]

Please share direct link to download csv file.

[@OracleAPEX]

Hello, thanks for your comment! Please see the instructions in the video description. If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@sralinternational8364]

@@OracleAPEX i got the csv file. very thanks.

[@eugenewilson6540]

Please How did you get the csv file?@@sralinternational8364

[@devangthakkar8301]

how we can download the movies data exel file??

[@OracleAPEX]

Hello, Devang ! Please open the video description (Show More) and try right-click/'save link as'. It will open the option to save on your computer.

[@brianramirez5178]

@@OracleAPEX do you have an updated csv file? it seems that most of the POSTER_PATH are old, so the images are broken.

[@OracleAPEX]

@@brianramirez5178 Thanks for your comment, Brian! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@VeeraKondalu]

I love it....

[@silmaragaldino7934]

Tomara que hoje em Custódia

[@mahmoudothman3210]

hi if any one can upload data tell us how he can do it thanks

[@kimballchoo]

Is this free? Sorry I haven’t have the time to see the vid… just skimming through the video

[@edwinyulianto3660]

Any link to download the excel?

[@OracleAPEX]

We've updated the description to provide a link to download the app export. The app also includes the sample data used.

[@sohailnawaz2473]

@@OracleAPEX I downloaded and imported the sample APP, but there is no table MOVIES.

[@edwinyulianto3660]

@@OracleAPEX Hi, I imported the app. It said: ORA-00942: table or view does not exist.

[@OracleAPEX]

Sorry for the confusion. The CSV file is part of the application and uploaded into the Shared Components -> Static Files. Once you have installed the app, run it and on the homepage, there is a link to download the sample movie set.

[@edwinyulianto3660]

@@OracleAPEX Thanks.. I didn't read your notes.. sorry :).

[@maxamad13]

the link tow download is not working

[@OracleAPEX]

Thanks for your comment, Maxamad13 ! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@MrHaliava]

thanks

[@hetshah727]

given link is deactivated

[@OracleAPEX]

Hello! Thanks for your comment. The link has been updated in the video description. You can also access it here: bit.ly/apex-simple-movies-app-export

[@9810600]

What are you doing!!!! OMG!

[@hikmettas5030]

BRO SEND ME THE LİNK.

[@OracleAPEX]

Thanks for your comment! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@sameerahmad7592]

Hello Mr.Shakeeb, Kindly send that excel sheet having all the Movie details at my mail-id, I would be thankful to you. Regards Sameer Ahmad

[@devangthakkar8301]

i want that csv file please can you send me?

[@OracleAPEX]

Thanks for your comment, Sameer! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@OracleAPEX]

@@devangthakkar8301 Hello! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@sameerahmad7592]

Thanks a lot ... 🙂

[@inamhusain]

Just rubbish sound quality and comentary

[@shoppersdream]

I can't download this file. Can you please put a new link? Thanks

[@OracleAPEX]

Hello, Peace! Thanks for reaching out! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.

[@kinganime9388]

I can't download this file. Can you please put a new link? Thanks

[@OracleAPEX]

Thanks for your comment, King Anime ! Please use the link above to download the file. (video description) If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum.