I'm growing a database software in oracle utility express (apex) with the aid of the usage of the application builder and I have a short question regarding paperwork and reviews. I know how to create simple forms and reviews but I'm aiming to do something a little more difficult. I need the user to be offered a shape with the fields username and password, and after inputting the username and password I want the shape to crosscheck the username and password inputted against a 'scholar' desk that I created with sq. And if it exists then I need the software to then deliver up a document with the applicable subject containing this data.
As an instance a user inputs 'hello' as their username and 'letmein' as the password through the form and then if it exists in the scholar table the software will then permit them to peer the whole row of information for their particular scholar account only. The cause I want to do it this manner is that I want the students to handiest be able to see their particular row of facts and not any other pupil rows inserted in the 'scholar' desk glaringly because of privateness motives.
I tried to apply the question on shape option while growing a brand new page for the application however it only we could me as the developer put in the question assertion and that I cant do that because it must be specific to whatever the user inputs within the 'username' and 'password' subject at the form themselves.
Wish it makes feel as I have tried to give an explanation for in the high-quality manner viable and I've genuinely been searching for a good few hours looking for the solution however I feel there is restricted oracle utility explicit fabric available on sites like youtube which I commonly usually seek advice from while gaining knowledge of something new. I've additionally regarded inside the oracle utility explicit user doctors but there is nothing that I'm able to find that allows me to attain the results I'm seeking out.
Subscribe to get latest updates