I am quite new in the oracle forms, and in some codes I always see some forms functions
set_block_property('Table_name', default_where, 'condition');
execute_query;
default_where etc;
I am not sure if I understand why and how to use them. What I understand that it is preferable to not use SQL codes in plsql forms, however for example if i need to create record group based on query how am I supposed to use those functions? let's say for example query is
SELECT NAME, SURNAME, TO_CHAR(ID) FROM EMP WHERE DEPT_ID = 01;
Or am I misunderstanding something?
Any advises or explanations are welcome.