Clever Geek Handbook

FORM to SQL Query APEX

I am working in Oracle APEX 4.2. I created a form on a table, a table form and a form on a report table. I have tried a lot to create a form in SQL Query, but I cannot.

I have two questions related to a form in a SQL query!

First I want to create a form on a SQL query on two tables ie `

Patient_Registration

Pat_Id(Pk),Name,Address,Gender ,Age,Contact

and Patient_Charges

P_Ch_Id (), Patient_Id (), P_Doc_Charges, P_Extra_Charges

Secondly, if done, can we make inserts on two tables in one form?

+3


source to share


1 answer


I * think * I understand your question.

Create a view with your SQL query and then add a Before Insert trigger that executes the required DML.



Check out some sample apps for ideas in this regard.

+1


source






More articles:


All Articles