1 person found this helpful
for upload photo alter table and add column mimetype,filename,last_update and create form on table
for more details refer Sample database application in order tab
it is provided in the packeged applications?
what is the name fo the sample database application please?
i know the mimtype etc, i will include them, but problem is how to get together both the tables in one entry form?
i want o show you an image which i have on my desktop. how could i share it with you here in the forum?
1 person found this helpful
ya name of packaged application is sample database application
1st refer all tables as well as report of that application also form and then try. it is in product tab.
just a final query,
kindly make me understnd the query behind the report
select p.product_id, p.product_name, p.product_description, p.category, decode(p.product_avail, 'Y','Yes','N','No') product_avail, p.list_price, (select sum(quantity) from demo_order_items where product_id = p.product_id) units, (select sum(quantity * p.list_price) from demo_order_items where product_id = p.product_id) sales, (select count(o.customer_id) from demo_orders o, demo_order_items t where o.order_id = t.order_id and t.product_id = p.product_id group by p.product_id) customers, (select max(o.order_timestamp) od from demo_orders o, demo_order_items i where o.order_id = i.order_id and i.product_id = p.product_id) last_date_sold, p.product_id img, apex_util.prepare_url('f?p='||:app_id||':6:'||:app_session||'::::P6_PRODUCT_ID,P6_BRANCH:'||p.product_id||','||3) icon_link, decode(nvl(dbms_lob.getlength(p.product_image),0),0,null, '<img style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '|| 'src="'|| apex_util.get_blob_file_src('P6_PRODUCT_IMAGE',p.product_id)|| '" height="75" width="75" alt="Product Image" title="Product Image" />') detail_img, decode(nvl(dbms_lob.getlength(p.product_image),0),0,null, apex_util.get_blob_file_src('P6_PRODUCT_IMAGE',p.product_id)) detail_img_no_style, tags from demo_product_info p
i stop understanding from line 12.
could you kindly explaint these lines for me?
from 12th line you should write follow for your report as follow
apex_util.prepare_url('f?p='||:app_id||':page_id:'||:app_session||'::::PX_PIC_ID,PX_BRANCH(i.e used to branch from form page):'||PIC_ID||','||3) icon_link,
'<img style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '||
'" height="75" width="75" alt="PIC" title="PIC" />')
is query to display student pic in report
thanks for the time and guidense,
i am making this thread as answered since the question is answered.
i even do not understand.
could you suggest me a book which have this topic?
like how to find app_id,app_session, and what is px_branch etc.
thanks again pars.
put your example on apex.oracle.com
i will do as you guide,
and i am really searching for words to properly thank you.
i cant put the example right now on apex.oracle.com becuase the it is in my personal laptop which is in my room,
but i got a very better idea from your help.
all i have is just to study thoroughly the sample database application's page and report, and the book you has given the refernece.
i am planning to give my ocp final paper in the coming next days since i receive the confirmation email.
thank you so much paars.