It seems to me that AI Oracle APEX application generation is just not there yet. These pages can be generated by hand very quickly and will then better suit the business

Nice work Whats different between your way and when use required field in item properties

hey Saurav, configured Cohere AI per your other video. when I asked Cohere APEX Assistant to write a simple query just like yours, I got this error "Error in backend AI Service cohere_genai" (fyi cohere_genai is the static name for this service that we configured). BTW same error while creating an app too. Also I did confirm the WebCredentials.

I know by validating email id on the server side, you were just demonstrating how server side validations work. But I think your followers will benefit any mention of best practices like validating email id in the front-end instead of server side. We don't want to make a server trip for validations like this one.

Thanks for putting time in making the video lessons. It indeed was a long video but worth it.

CAN U TELL ME WHERE I CAN PREPARE FOR ORACLE APEX INTERVIEW AND HOW TO PREPARE ? WHAT TYPES OF QUESTION INTERVIEWER ASKED IN INTERVIEW ?

Hey Saurav, got a weird error while creating the side-by-side page. Page got created but with an error "1 error has occurred" and there is no way to see what this error is as I cannot see the components of this page in the left, center and right panels (all 3 panels are blank). I closed the page and reopened it but same error. This is why it's weird, the side-by-side paster/details page for the user is working fine. I have the screenshots but I don't see a way to attach here. Anyway, can you think of how can I see what the error is, and why there's an error for me and not for you?

Hey Saurav, we have Oracle Apex installed on a VM. Any time VM is restarted we have this error: "ERROR: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only". We know the solution to this problem i.e. connect to oracle db using SQL Developer and run this command - "ALTER PLUGGABLE DATABASE orclpdb OPEN" and everything works fine, Now question, is there a way "orclpdb" is always open/started and can get opened/started after the VM is rebooted? Found a possible solution (refer URL), but this solution has its own drawback. The ORDS service, which I configured as a Windows service using NSSM utility doesn't pick up "orclpdb" and hence I have to stop/start this service and then orclpdb get picked up and everything starts working fine. URL for orclpdb solution - asktom.oracle.com/ords/f?p=100:11:0::::P11_QUESTION_ID:9531671900346425939

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

How can we create Form and Report in Oracle APEX manually? Steps to create them manually - 1. Create a blank page 2. Create an Interactive Report 3. Create a button which will redirect to Form Page to create the record. 4. Create Edit link in Interactive Report to redirect to Form Page to update and delete the record. For any suggestion and feedback, please give your response here - apex.oracle.com/pls/apex/r/myblogs/ideas/home

Select * from table(apex_string.split(colname,','));

As always great info and hands-on. Saurav, how did you get those EBA_CUST_* tables so we can use the same tables to follow along your video lessons?

very good information! I want to make summary report and last column my be down arrow when user click it will open the detail of that summary when click again on up-arrow it will close. detail report must be display from bottom of the clicked row.

Hey Saurav, to make it easy to follow along we would like to use the same tables that you are using. So quick question, how to get those EBA_CUST_* tables that you are using? Our sample database has many tables but not the ones that you used in the video. Thanks

You can raise your request to this App Link: apex.oracle.com/pls/apex/r/myblogs/ideas/home

I can't catch the like plz put it here

Hey Saurav, one of the developers on my team is following all your Apex lessons. While working on this particular one though , he has a question for you. As he doesn't have the same table as you do for Calendar region, so he used EBA_DEMO_CARD_EMP. The edit case worked just fine but creating a new record is not. For this table EMPNO is the primary key and hence it is not one of the fields on the form because of which he is getting the error as in the screenshot (PK cannot be null... obviously it cannot be). Do you have any take on it? Just realized, chat does not allow screenshots but anyway error is "cannot insert NULL into the tableName.EMPNO. keep up the good work 👏

If i want add button for create activity in cell? How. How get default date depend the date who is click

THANKS SAURAV❣

thanks for this tutorial. waiting for the further videos

Cool

Finally ❤

Hi SarHi Saurav. When you are going to start full Apex classes

Very clear introduction. Thanks

Hello Sir,your explanation was just awesome through out SQL and plsql series,can you please tell whether this is the end of plsql series or you are yet to upload more tutorials here?

Thank you nice Explaination

Thanks please , i write the same programme but i don t know why i dont have the msj inserted or …

What if I want multiple items to be NOT NULL?

I am using a shuttle type. When I am trying to insert those shuttle values in table. It is not working. Just coming ::: Not coming the values

Sir I have a query Sir, I want that once the user edits the data and saves it, he should not be able to edit it again and just as the edit button is row wise, the save button should also be row wise. Sir, how to do this? Please help.

Very helpful session sir

how to export this data to excel or pdf

Very nice tutorial... Thank you!

Please explain the universal page and make video on them How to use them

a copy of manish sharma

Thank you!

I have doubt can you please clarify it

hola bs tardes, como podemos descargar esta aplicación?

I need to run the processor in this place -- Authentication Scheme -Post Logout Procedure Name

create or replace PROCEDURE update_user_active_now(P_USERNAME IN VARCHAR2) IS BEGIN UPDATE usernamer SET active_now = 0 WHERE log_in = P_USERNAME; COMMIT; END;

CAN YOU HELP FOR MY PROCEDURE TO UPDATE TUBLE USERS FAELID ACTIVE_NOW FROM 1 TO 0 WHEN THE WEB SINGOUT OR CLOSE PAGE THIS PROCEDURE DONOT WORG IN ORACLE APEX