- 32
- 14 926
ORAPEX
Приєднався 7 вер 2015
Oracle Learning Studio || Learn Oracle From Expert
This is an online platform for learning Oracle. Specially for Oracle Database, Forms, Reports and Apex. I would like to share my attained knowledge about oracle toolsets among those learner/viewers whom are eagerly waiting/searching opportunities to learn oracle. You can connect with me through commenting on a vedio or directly by emailing.
Objectives:
1. Spread Oracle database knowledge through the new learner.
2. Share my knowledge to the learner whom are search for learning opportunities about Oracle.
3. Help the learner to acheived the clear concept about particuler topics.
4. Encourage to adapt new technologies.
Hope, you will be benefited from my channel. Wish your progressive life.
Best Regards
MD. RUMMAN ALAM
This is an online platform for learning Oracle. Specially for Oracle Database, Forms, Reports and Apex. I would like to share my attained knowledge about oracle toolsets among those learner/viewers whom are eagerly waiting/searching opportunities to learn oracle. You can connect with me through commenting on a vedio or directly by emailing.
Objectives:
1. Spread Oracle database knowledge through the new learner.
2. Share my knowledge to the learner whom are search for learning opportunities about Oracle.
3. Help the learner to acheived the clear concept about particuler topics.
4. Encourage to adapt new technologies.
Hope, you will be benefited from my channel. Wish your progressive life.
Best Regards
MD. RUMMAN ALAM
ORACLE APEX- Change alert button labels dynamically
Learn how to customize and change alert button labels dynamically in Oracle APEX! In this tutorial, we’ll walk you through step-by-step instructions to modify the default alert buttons to match your application’s requirements. Whether you want to display custom labels like "Confirm" or "Cancel" or adjust button text based on specific scenarios, this video has you covered.
✅ What You'll Learn:
How to use JavaScript for customizing alert button labels.
Practical examples to implement in your Oracle APEX projects.
Tips to enhance user experience with personalized alerts.
📌 Topics Covered:
JavaScript integration in Oracle APEX.
Dynamic button label modification.
Real-world implementation examples.
Don't forget to like, share, and subscribe for more Oracle APEX tutorials! 🚀
#oracleapex #alert #button #javascript
✅ What You'll Learn:
How to use JavaScript for customizing alert button labels.
Practical examples to implement in your Oracle APEX projects.
Tips to enhance user experience with personalized alerts.
📌 Topics Covered:
JavaScript integration in Oracle APEX.
Dynamic button label modification.
Real-world implementation examples.
Don't forget to like, share, and subscribe for more Oracle APEX tutorials! 🚀
#oracleapex #alert #button #javascript
Переглядів: 51
Відео
Oracle Apex- Preview Image || Display image in large scale
Переглядів 2587 годин тому
In this tutorial, we will learn how to preview and display images in Oracle APEX with dynamic scaling for a better user experience. Whether you want to showcase large images or zoom in for finer details, this video covers step-by-step instructions to implement this feature in your APEX applications. 📌 What you'll learn: Setting up image preview functionality. Enlarging images dynamically for be...
Oracle Apex- How to delete a record from interactive grid
Переглядів 21214 днів тому
In this video, we'll show you a detailed, a little bit different approch step-by-step process on how to remove/delete record from an Interactive Grid. From enabling delete functionality to handling database interactions, you'll learn everything you need to ensure smooth and efficient data management. Whether you're a beginner or an experienced developer, this tutorial is designed to help you en...
Oracle Apex- Extended use of Date Picker
Переглядів 588Місяць тому
Why you use date picker item in oracle apex? Inserting date only, right? Let see how amazing feature you can add into it! Unlock the full potential of the Oracle APEX date picker! In this video, learn how to customize and enhance the user experience with advanced features, tips, and tricks. Perfect for developers aiming to create more interactive and intuitive applications. Watch now and transf...
Oracle Apex- Barcode/QR code generation system
Переглядів 501Місяць тому
Let discover how to generate Barcodes and QR Codes using PL/SQL in Oracle APEX with this comprehensive tutorial. This video provides a detailed, step-by-step guide to implementing dynamic barcode and QR code generation in your APEX applications. Learn best practices, explore practical use cases, and enhance your application's functionality with this powerful feature. Whether you're building an ...
Oracle Apex- Upload and Display Image into Interactive Grid without Saving
Переглядів 493Місяць тому
In this video, we dive into how to upload and display images in Oracle APEX using an Interactive Grid, without the need to save the images to a database or server. If you're looking to enhance your Oracle APEX applications with dynamic image handling, this tutorial is perfect for you! Let see how simple image upload and display in tabular form without saving data! This process will more helpful...
Oracle Apex- BI Publisher Master Detail Report || BI Publisher Template Builder
Переглядів 444Місяць тому
In this video, you'll learn how to create a Master-Detail Report in Oracle APEX using BI Publisher. We'll guide you through the process of leveraging the BI Publisher Template Builder to design and generate dynamic reports, showing how to link master records with their related detail data seamlessly. Whether you're new to BI Publisher or looking to enhance your reporting skills in Oracle APEX, ...
Oracle Apex- Direct Printing Feature || No Print Preview
Переглядів 1,3 тис.2 місяці тому
In this tutorial titled "Oracle Apex- Direct Printing Features" discover how to leverage the Direct Print capabilities in Oracle APEX to enhance your application’s efficiency. We'll guide you through the step-by-step process of setting up direct printing, allowing users to send documents like reports, invoices, and receipts directly to a printer with a single click-no print preview required! Yo...
Oracle Apex- Gmail Account Integration || Send Mail From Apex Application using Gmail
Переглядів 1,1 тис.2 місяці тому
In this video, learn how to integrate a Gmail account with Oracle APEX to enable email functionality within your APEX application. We’ll walk through the step-by-step setup to configure Gmail as an email provider, covering key settings, SMTP configuration, and troubleshooting tips. By the end, you’ll know how to send emails directly from your Oracle APEX app using Gmail, making it easier to aut...
Oracle Apex- Session Sharing || Navigation among apps || Rejoin an active session from external link
Переглядів 3062 місяці тому
In this tutorial titled "Oracle Apex- Session Sharing || Navigation among apps || Rejoin an active session from external link", I have try to demonstrate how to rejoin an active session from external link and navigation among applications using single sign in option. Explore advanced session management in Oracle Apex with this tutorial! Learn how to effectively share sessions between applicatio...
Oracle Apex- Run custom pdf report || Simple use of RTF template
Переглядів 9832 місяці тому
In this tutorial titled "Oracle Apex - Run Custom PDF Report || Simple Use of RTF Template," you'll learn how to generate custom PDF reports in Oracle APEX using a straightforward RTF (Rich Text Format) template. The video walks through the process of designing a report layout, linking it to your Oracle APEX application, and running it to produce dynamic PDF reports with your data. Ideal for an...
Oracle Apex PDF Converter || Save Converted PDF into Directory/Database
Переглядів 5732 місяці тому
Welcome to this tutorial on Oracle Apex PDF Converter || Save Converted PDF into Directory/Database. In today's video, I'll walk you through the process of converting an image into a PDF and show you how to save that PDF either in your local directory or directly into a database. Whether you're building a document management system or simply need to automate the PDF generation and storage proce...
Oracle Apex- Save Password Tips & Trics || Store credential into cookies to login autometically
Переглядів 3452 місяці тому
Oracle Apex- Save Password Tips & Trics || Store credential into cookies to login autometically In this tutorial, you'll learn how to implement a "Keep Me Signed In" feature in Oracle APEX. The video demonstrates how to securely store user credentials in cookies, enabling automatic login for returning users. It covers useful tips and tricks to enhance user experience by avoiding repetitive logi...
Oracle Apex- Custom Authentication || Verify users from your own database
Переглядів 5902 місяці тому
Oracle Apex- Custom Authentication || Verify users from your own database In this very simple tutorials, I have try to discuss the process of end users authentication using custom method by storing the users into own database schema and verified the users by retriving data from here. This process will simplify your users control. If you have any query, please feel free to ask. Love with #oracle...
Oracle Apex - Camera Integration Tips & Tricks || Capture image and Store into Database
Переглядів 6223 місяці тому
Oracle Apex - Camera Integration Tips & Tricks || Capture image and Store into Database I have try to demonstrate how to integrate webcam (camera) with my application using javaScript. Not only try to access the camera over my application, but also try to capture an images and store it into the database directly. This application is useful in those sectors where a photograph required immediatel...
Oracle Apex PDF Converter || Convert Multiple Images into Single PDF File
Переглядів 5113 місяці тому
Oracle Apex PDF Converter || Convert Multiple Images into Single PDF File
Master Detail Form- Oracle Apex || Master Block using Wizard || Manually Create the Detail Block
Переглядів 8473 місяці тому
Master Detail Form- Oracle Apex || Master Block using Wizard || Manually Create the Detail Block
Oracle Apex Image Upload- Tips and Trics || Display Image From Database into Item
Переглядів 4253 місяці тому
Oracle Apex Image Upload- Tips and Trics || Display Image From Database into Item
Oracle Apex Collections- Part 3 || Insert, Update & Delete data based on Apex Collections
Переглядів 2953 місяці тому
Oracle Apex Collections- Part 3 || Insert, Update & Delete data based on Apex Collections
Custom Button in Interactive Grid in Oracle Apex
Переглядів 4293 місяці тому
Custom Button in Interactive Grid in Oracle Apex
Custom Button in Oracle Apex Interactive Report
Переглядів 4103 місяці тому
Custom Button in Oracle Apex Interactive Report
Upload and Process Excel File's data from Oracle Apex
Переглядів 3233 місяці тому
Upload and Process Excel File's data from Oracle Apex
Geolocation/Phisical Location Tracking From Oracle Apex application without any API
Переглядів 4454 місяці тому
Geolocation/Phisical Location Tracking From Oracle Apex application without any API
Develop Matrix Report Manually From Oracle Reports
Переглядів 1154 місяці тому
Develop Matrix Report Manually From Oracle Reports
How to set header and Logo dynamically in your RDF report
Переглядів 124Рік тому
How to set header and Logo dynamically in your RDF report
Upload external file data into Oracle database table from Command Line.
Переглядів 101Рік тому
Upload external file data into Oracle database table from Command Line.
How to change even rows background color in RTF template.
Переглядів 424Рік тому
How to change even rows background color in RTF template.
Helpfull
Thank you.
How to add a button such that it submits the date parameters and also displays the report in new popup window or page
If you want to open a new popup then nothing is needed o do for submiting date parameter. Just open the modal dialog from the button. On the other hand, when open a new page from the button then there is two way. 1. Set the button behaviour is submit page and after submit section create a branch and set the items value which you want to pass. 2. Set button behaviour is redirect to page in this application and set the items value which you want to submit. Please subscribe my channel if not yet. Thank you.
Kindly share scripts
Please write some line of code. It will sharpen your brain. If copy and paste then it will reverse effect. I can share script but not done it intensionally. Because it is very simple task and maximum 40 line of code. It tooks hardly 10 minutes to type. Thank you.
@@rumman_alam i am new in this platform. If you had shared the script, it would have been better for me, and work has also been done on page 4
Okay, I will share. Please share your mail id.
@@rumman_alam Thanks❤
well done ماشاءاللہ
Thank You.
Nice video .....please do more more videos on oracle apex
Thank you for your complements.
ORA-29278: SMTP transient error: 421 Service not available i am getting this error
Good tutorial. Thanks a lot
You are welcome!
Speed bahut jaada bhai video ka...thora slow banaoo....lakin bahut helpfull hai....thank you for sharing this type of knowlege..
Thank you for your advice. Will try to follow next video.
realice todo paso a paso y no funciono la autenticación
Of course, something missing. Otherwise, it will work. Is your stored password encrypted?
?select ed.first_name||' '|| ed.last_name as emp_name ,ed.job_id ,hel.from_date ,hel.to_date ,hel.no_of_days from emp_leaves hel ,emp_data ed where 1=1 and hel.id_emp = ed.id_emp and trunc(hel.from_date,'MM')=TO_DATE(UPPER(REPLACE(REPLACE(REPLACE(:P2_CURRENT_DATE????))) and hel.from_date = nvl(to_date(:P2_CALENDAR,'MM-DD-YYYY'), hel.from_date) order by from_date desc, ed.first_name||' '||ed.last_name
This is report query.
@@rumman_alam Sorry, is incomplete. Could you please, show the full select?
Sure, but how?
@@rumman_alam Can you write it here? Or you are kidding me?
Hi rumman_alam, looks interesting. I try to create in oracle apex, but i can't see the full select of the Display Detalis, could you show me ?
Sure.
Really interesting, I subscribed to your channel. Can I kindly have the latest update as I can't dynamically change the class in my example
It's the latest update bro. Please watch the video carefully or follow the shared script.
please send the codes which are used ?
Please check description box.
Me falta la parte del IF como termina, que parece que el video se cortó!
Copy it as it is what you seen in the screen. Hope you will be done.
very impressive sir, keep doing this type of videos thank you so much!
You are welcome in my channel. If not subscribed yet, please subscribe to get latest update.
great effort .. what do you mean by PRINT_REPORT
PRINT_REPORT is the key Oracle APEX uses to identify the report operation. For more information, please follow the link- docs.oracle.com/en/database/oracle/apex/24.1/htmdb/understanding-legacy-url-syntax.html#GUID-F249FDCA-972B-4DFB-A51B-DD127AAB9C35
WonderFulll❤
Thank You.
There are additions in the code that did not appear in the video. From minute 4.01, then 4.03, the code was completely different. Is this the instruction??
Thank you for your query! If you complete to write code upto 4:03 then add that code with your code what you see after that. It is better to say that, this tutorial is not complete within 30 minutes. If I posted the whole video, you have lost your interest to complete it. Though you not configure it, please feel free to contact with me through email- rummanalam@yahoo.com . Thank you.
Helpfulll Tutorials👍
Thank you.
As salam u alikum sir your all videos is so teachfull & helpful. I want to need video for zoom meeting integration in oracle apex please sir
Wa alaikumus Salam. Insha Allah, I'll try about this topic. Thank you.
@@rumman_alam thanks sir
Helpful ❤❤❤❤
Thank you!
send the JS code please
Are you not interested to write 8/10 lines code?
@rumman_alam i have no idea how to write this code.
@@leolima22 Just follow the tutorial and copy it as it is. Hope you will de done it.
Nice tutorial can share the code
Yes, sure
can you please share the script Db site configuration ?
Already shared bro. Nothing hide here. Please watch it attentively.
@@rumman_alam bro i mean is there any text files available where the code is written ?
@@MuhammadZubair-fc9lx Yes, I have. But copy paste is not good practice for learning.
@@rumman_alam Its Done Bro thank you so much.
@@MuhammadZubair-fc9lx ORA-29278: SMTP transient error: 421 Service not available i am getting this error have you get this error
Helpfullll
Thank You.
i have a 2 question, 1. when use parameter ways report generate that time how to show report on . 2. which browser is supported google chorme not supported direct print
1. You need to pass parameter value technically. 2. Not only chrome browser but also all modern browser don't support direct access to any device.
Nice helpful video. Can you make a tutorial on single individual user based authentification and dynamic menu based on users? Please?
Insha Allah, I'Ii try.
Its working fine Great job bro
Thank You. Wish your subscriptions.
@@rumman_alam Sure
Hello! Can you please help me? Create option not available in Shared Components -> Report Layout on my instance and showing the below Alert at top of the page. Report Layouts are not supported. Native printing is configured for this application. A Remote Print Server is required to use Report Layouts.
Yes, of course. But how! If you watch it carefully then you can enable create button.
@@rumman_alam I have followed all steps but not got the solution.
@@anjumraza4250 Not get Create button yet?
@@rumman_alam No
Thnk
Will be pleased, if subscribe!
Great job
Thank you.
great job..
Thank you.
Can you plz make a video of how we can manage a application from home page with making an attractive page by html css js
Insha Allah, I'll try.
@@rumman_alam thankyou
Nice vdo
Thank you.
Thanks For this 😀
You are welcome.
Nice video but you can make xml to rtf here we get issue to convert can you plz resolve
Which type of issues you facing?
@@rumman_alam when we click on view button then the layout we provide is fetching only without any type of data
At row level?
@@rumman_alam yes
I think there issue in convert to rtf how can we do so?
Can I upload multiple sheets at once through UI and store it in a table in apex?
In this tutorial, I have try to demonstrate how to run custom reports(rtf/df) from oracle apex application. I'm not clear about your query!
Goood Job
Thank you.
Java script code for itegration?
Yes. Please watch the tutorial again attentively.
Can you also make a video so that we can store the pdf in a table and then fetch it on frontend
Insha Allah, will make another video as per your request as soon as possible.
I need this sir can you plz guide me
@@puneetchauhan9787 Please allow me some times.
Ok
Appreciated Your Content sir
Thank You Very Much.
Nice information
Thanks. 💓
Thank you How to integrate technoriver smartcode with Oracle Apex?
There are two questions for you. What you would like to do? 1. Barcode generate? Or 2. Scan the Barcode?
@@rumman_alam I want to design label by smartcode and data from apex to this label and print it
why can't we use directly upload image page item type . It is already available in Apex Default & do the same functionality. without writing single line of code.
@@vbvlogs2651 Yes, we can so. For that case, we need an static image to upload. But, in this tutorial, I have try to capture image using your webcam and upload/store it into database.
why you use p_16 in display image sql quey and you can work on p_17
Becuase, Apex can't display image directly from database in a reports column. That's why it's need a source item. For that reason, I have create another page (Form using wizard) to upload image. And still now, it is needed still now to display image.
Nice Vedio, could you please share the code?
Have you practice by following the tutorial? Please try to do it by following the video. Nothing hidden here. Hope you can do it. If found any complexity, feel free to knock me.
Helpful 👌
Thanks.
ماشاءاللہ ❤️
Your support is my inspiration. Thank you .
good job. You should put your youtube link in the drive file!
Thank you for your good advice.
Good work If we need to put the data into master block when select one item. And poplute edit or delete the item.
When you want to update or delete data from master block then you need to select the department from the search field. After then do your desired task. Thank you for your comments.