I have interactive grid page .
I want to insert employee data that include his image.In addition to display this image with the data.
I tried to do that using (sys.dbms_lob.getlength(“EMP_PHOTO”)”EMP_PHOTO” )but i get number in the interactive grid column.
I also insert the photo from form because the field photo in interactive gride has no type of upload file
is there any way to do that?

I have interactive grid page .
I want to insert employee data that include his image.In addition to display this image with the data.
I tried to do that using (sys.dbms_lob.getlength(“EMP_PHOTO”)”EMP_PHOTO” )but i get number in the interactive grid column.
I also insert the photo from form because the field photo in interactive gride has no type of upload file
is there any way to do that?

I have two tables ITEMS_MASTER this table include my (ITEM_CODE, ITEM_NAME,ITEM_QTY ,…) And the other table is called STK_TRANS_DETAILS I insert the items(ITEM_CODE,QTY,PRICE,ITEM_NAME,..) in it based on the DOC_NUMBER and THE TK_CODE . I want to write trigger ON THE TABLE STK_TRANS_DETAILS(this trigger is after insert or update or delete) to update qty column(more than one item in item_master table based on the number of items inserted in the stk_trans_details table based on the doc_number) in items_master table with a value equal to item_qty column in item_master table + qty column in stk_trans_detail table if TK_CODE in stk_trans_detail table =1 or 3 and the ITEM_CODE in the two table are the same value and the DOC_NUMBER in STK_TRANS_DETAILS equal to the page item P113_DOC_NUMBER. and if tk_code = 2 value equal to item_qty column in item_master table – qty column in stk_trans_detail table when the ITEM_CODE in the two table are the same value and the DOC_NUMBER in STK_TRANS_DETAILS equal to the page item P113_DOC_NUMBER.

I have a Table “STUDENT_DATA”, The table – STUDENT_DATA I need to print this report using Apex Office Print. My page layout, with the static file and SQL queryThe SQl query I used to fetch dataThe template I’ve used, FIRST.docx.

I have a Table “STUDENT_DATA”, The table – STUDENT_DATA I need to print this report using Apex Office Print. My page layout, with the static file and SQL queryThe SQl query I used to fetch dataThe template I’ve used, FIRST.docx.

I created an XML output file with APEX_DATA_EXPORT.
It is working fine, but I don’t understand how to change, if possible, the structure and names of the attributes and elements.

I need help with PL/SQL Dynamic Content Region.
Based on selection in page item (on item change event) dynamic content region should be refreshed to show all images based on selected value images in page item. PL/SQL generates html slider: