Reg. Dashboards
written by Nirmal , August 14, 2009

Hi Kishore,

I am soon gonna get a new requirement to create Dashboard using APEX.
Do I need to have a Java resource with me to handle it ?
If so, then how they can be helpful to me? I am not aware of Dashboards much.
Kindly suggest.

thanks,
Nirmal

Problem with Flash chart
written by Nirmal , August 21, 2009

Hi,

I created a flash chart in APEX of type "2D Column". When I run the page, it displays "waiting for data" with a processing sign.
Its not displaying any chart at all. The page processes (waiting for data) indefinetely. What could be the fault?
Kindly suggest.


Thanks,
Nirmal

MD50/70
written by Abhishek Krishnan , October 02, 2009

Hi Kishore...Excellent site for beginners.....Anyways could you possibly send me sample MD50/70 for any Oracle APEX hands on project that you have.
Thanks in advance

...
written by tommy , October 22, 2009

Hi Kishore,
Thanks for hardwork. It's a good article

Could you possibly send me sample MD50/70 for any Oracle APEX?
My E-mail: This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Thanks,
Tommy

Master detail(tabs) Pages
written by Fred , October 26, 2009

Hi Kishore,

I am a beginner in APEX, but experience in Oracle Designer and Forms.
I was wondering if it's possible to create a master detail page with multiple tabs(details)? like with Oracle Designer?

Much appreciated!

Fred

Screen mockups using APEX
written by Seenu007 , November 10, 2009

Thanks Kishore for your wonderful tutorial.

In APEX, how can we create screen mockup (prototypes). I read somewhere that we can definetly do that but couldnt get any good information. I am currently using some free tool (Axure RP) to develop the screen prototypes.

Please direct me if we can do that using APEX drag&drop feature.

Thanks,
-Seenu

Oracle application express - licence
written by S Uma , November 22, 2009

We have licence for Oracle 10g database, but don't have licence for Oracle 10g application server (AS).

Please let us know whether licence is required for using Oracle Application Express or it is a freeware for us

How to change APEX region background colour.
written by Nirmal , December 07, 2009

Hi Kishore,
I need to change the back-ground colour of my APEX region. Currently its in grey.
Kindly suggest how to do it.

Thanks,
Nirmal

Inserting multiple files using single tabular form
written by Punam , December 15, 2009

Hi,

I have one tabular form. I want to add browse button column in that form. I cannot add that field directly as tabular form is not supporting blob data. Is there any solution to add browse button column to tabular form and upload files?

I have added one NULL column for upload document. and used html expression



and written process to upload cv as:

BEGIN

FOR I IN 1..APEX_APPLICATION.G_F40.COUNT
LOOP
INSERT INTO document(doc_ID, doc_TYPE, LANGUAGE, doc_DATE, FILE_REF, MIME_TYPE, person_ID )
SELECT doc_SEQ.NEXTVAL,
1,
1,
SYSDATE,
BLOB_CONTENT,
MIME_TYPE,
APEX_APPLICATION.G_F02(I)
FROM WWV_FLOW_FILES WHERE NAME = APEX_APPLICATION.G_F40(I);

DELETE WWV_FLOW_FILES WHERE NAME = APEX_APPLICATION.G_F40(I);
END LOOP;
END;

but still it is not uploading file in the database.

can anyone help me "What is the Problem with above code?"

When we are creating file browse button then it creats

a class="eLink" tabindex="999" rel="nofollow" href="/[removed]popupURL('f?p=4000:371:3494102961234719::: 371_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID:1189512577311801,101, 40');" title="Edit">

and one hidden field whose value equals to 1189512577311801 (it changes per item)

As I have created Null column for browse button it is not creating as well as not creating hidden item.

That's why I am not getting file uploaded .... So is there any solution for this problem?.....Please help me on this .....

How to add tab pages inside APEX page
written by Nirmal , December 17, 2009

Thanks Kishore.. I got one more favour.
Inside my apex page, I need to have multiple tabs similar to Sales Order form in OM and Enter and Maintain form in HRMS.
How can I achieve this in APEX?

Thanks,
Nirmal

Conditional display in dropdown
written by Seenu , December 23, 2009

Hi Kishore -

Thanks for the knowledge pool you have put together for APEX.

I am kind of new to APEX and working my way out ....

I have a question w.r.t conditional display of values in dropdown.
There are dropdown combo lists in a region (on a single page). And these 3 dropdowns are dynamic LOVs coming from different database table.
i.e. Dropdown1 --> Table1
Dropdown2 --> Table2
Dropdown3 --> Table3

My goal is to show only first dropdown when a user comes to that page first time. And depending upon the selection made from the first dropdown, I want to show the second dropdown (only for few values in 1st dropdown this second dropdown should be shown) and subsequently based on the value selected from second dropdown, the third dropdown should show a refined list which is a subset of all the rows in table 3.

If someone else have confronted with similar kind of issue , please let me how you worked on it or direct me.

Thanks,
-Seenu

Re: Conditional display in dropdown
written by Seenu , December 23, 2009

Thanks Kishore for your response.

In step (5) , how do I create an application process and use it to set the application item. I have gone thru the URL you mentioned but there its creating an on-demand process using AJAX and referencing that in the page header.

Thanks,
-Seenu

Re: Conditional display in dropdown
written by Seenu , December 28, 2009

Hi Kishore -

Just wanted to followup with my last posting dated Dec 23. If someone else on this forum faced this issue please let me know how you resolved it.

Thanks,
-Seenu

Backgroup color for subtotals and grand total
written by Rajinikanth , March 05, 2010

Hi,

I would like like to show alternate colors for my subtotals or groupwise. also for grand total.

Kindly suggest for making it.

i can show same color - yellow for subtotal and grandtotal under

Report Attributes -> Break Formatting -> #COLUMN_VALUE#

Thanks

Apex Falsh Chart
written by Joe , March 23, 2010

hi,
How do i enable the show values check box for Stacked 2D column flash chart, in Apex

Thanks in Advance...

Oracle APEX
written by swapnil , April 08, 2010

How the the Markert is responding to Oracle apex i.e are the Companies prefering the APex for web development

Tech Sales Consultant
written by Emmanuel , April 14, 2010

Hi,

what is the roles and responsibilities of DBA and Development team in APEX??

Thanks in advance

New APEX Resource
written by Michael Lum , May 14, 2010

Hi Kishore,

Just wanted to let you know about a new resource for APEX developers, consultants, and customers.

http://apex.justdoes.it

It's a community that is free to join, and allows you to both UPLOAD APEX applications that promote your company or service, and DOWNLOAD applications, both free and proprietary, which may be useful for you.

If you're interested, feel free to check it out.

Thanks, and have a great day!

Problem in Orace APex
written by HASEEB kHAN , June 15, 2010

plz. help me , facing problem in
migrating oracle forms converted to xml file
using 11g & apex 3.2. 10g Forms

In application migration project only Access Type
selection is coming . but uploading xml file i need Form Type . How to solve it

Problem with tabular form
written by KRIS , July 12, 2010

Hi Kishore,

I have a column used in the tabular which has to be substituted with a bind variable such as 101_USERNAME only when updated. I cannot use APP_USER/ Please advise....

Thanks
KRIS

oracle forms conversion to Apex
written by Sushil T , July 14, 2010

Hi ,

I designed one form in 10g compiled and generated xml without any button pallets to this form and tried converting into apex 3.2 - successful converted.

scenario 2 - I tried converting a form which already has button pallets and go buttons etc. in forms = while converting it is treating all buttons as columns and even after converting them as non database columns - still i am not able to achive the same look and feel and couldn't succeed successfully.

2. How to build Menu Application with drop down menu for the users to click and access those forms.

thanks in advance if you can put some light on this and assist me with the same.

design and develop a business dashboard application using apex
written by savio , July 29, 2010

can u pls show me an example of dashboard creation using apex as i am new to apex. i need to do a business dashboard, could you pls send me the steps to create dashboard in apex or any examples which i can refer.
many thanks
savio

problem with connecting to sqlplus
written by savio , August 22, 2010

hi kishore
i just installes oraclexe universal and then installed apex3.2. when i tried to connect to sqlplus , an error is shown as " sqlplus is not an internal or external command......" could you pls tell me what is the problem.

IT Specialist
written by mhamilton , August 26, 2010

Do you know of a way in Apex 3.2 to show the tables/views that are used by each page?

Thanks,
Maggie

show tables and views used by page
written by mhamilton , August 26, 2010

Hi Kishore,

I would like to see all the tables and views that a page uses.
Do you know how I can see this information in Apex 3.2?
Thanks,
Maggie

tables and views used by page
written by mhamilton , August 26, 2010

Hi Kishore,

First, I am not having very much luck knowing if my comment is getting through to you. I keep getting error messages at the top of the comment section. This area 'Write Comment' is not user friendly. Nothing against you though, just the comment section is difficult and caused me stress. As an Oracle Apex developer, I do not need anymore stress. LOL

I would like to see all the tables and views that a page uses.
Do you know how I can see this information in Apex 3.2?

Thanks,
Maggie

Series with the same colour
written by JosePablol , August 29, 2010

Hi!.
I would like to know how can I generate a chart of different series with the same colour.
For instance UCL and LCL of a PBC chart (Two series in red

Thanks
written by Steve Teale , September 29, 2010

Thanks Kishore for taking the time to add to Apps2Fusion - it's a great resource for the developers out there.

After just going through your labs I feel I'm starting to get to grips with what APEX can do. It's developed into a very nice tool.

Just a quick question - when a field is a required field you do not get a graphical indicator in the same way you do with say OAF pages (the little blue circle) - is there any way you know where you can enforce such a thing - other than creating a new item for it and programatically populating it (I'm guessing you can programatically query the attributes of a field like you can in say - Oracle Forms).

...
written by Abisai , October 15, 2010

Hi there

I am new to Apex

I have two tables (Master and Child) for simplicity sake lets say Orders and Order Details

However I need to split the fields of the Order Details between two tab pages
So I now have 3 tabs(A,B,C)

Tab A is Orders (PK order#)

Tab B is(Order Details )--Need to capture and display the Product Name on Tab B for the same Order#

Tab C is(Order Details )--Need to capture and display the Product Price on Tab C for the same Order#

My question is how do I carry the primary key on Tab A through to Tab A and B so that when I save/navigate to TAB B and C
only values pertaining to Order# currently in Tab A are shown?


TAB A (Orders) TAB B (Order Details) TAB C (Same Order Details table)
Order #1 Pk Order #1 fk Order #1 fk
Product Name Product Price

Please help, I am not winning with the multiple page branches especially when one table info is spread over two tabs.

How can I carry through the order # Pk through to the other two pages?

I have a deadline and this is stressing me out.
Thanks.

Capture and display data from a single table over two tab pages
written by Abisai , October 15, 2010

I am new to Apex

I have two tables (Master and Child) for simplicity sake lets say Orders and Order Details

However I need to split the fields of the Order Details between two tab pages
So I now have 3 tabs(A,B,C)

Tab A is Orders (PK order#)

Tab B is(Order Details )--Need to capture and display the Product Name on Tab B for the same Order#

Tab C is(Order Details )--Need to capture and display the Product Price on Tab C for the same Order#

My question is how do I carry the primary key on Tab A through to Tab A and B so that when I save/navigate to TAB B and C
only values pertaining to Order# currently in Tab A are shown?


TAB A (Orders) TAB B (Order Details) TAB C (Same Order Details table)
Order #1 Pk Order #1 fk Order #1 fk
Product Name Product Price

Please help, I am not winning with the multiple page branches especially when one table info is spread over two tabs.

How can I carry through the order # Pk through to the other two pages?

I have a deadline and this is stressing me out.
Thanks.

Hyperlink URL for APEX field.
written by Venkat Kancherla , October 25, 2010

Hi Kishore,
Thanks for this wonderful knowledge on APEX.
A quick question, I am trying to store a hyperlink(url) value in a field so that, users can just click on it and go the webpage stored in that field.

For example...I have a field called "Webpage" and I am planning to store a url like http://www.apps2fusion.com for each record. So, the user should be able to click on this link from this "Webpage" field, so that, they will open a website in a new window.

Could you please let me know.

I appreciate all of your help.
Thank you in advance,
Venkat.

Thank you, Kishore.
written by Venkat Kancherla , October 25, 2010

I have few more questions, can you please email me so that, we can take it offline, if you don't mind, please? My email Id is This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Thank you,
Venkat.

Hyperlink URL for APEX field
written by Venkat Kancherla , October 25, 2010

Hello Kishore, Thank you for your quick response.
When I create a Shortcut, what should be the source? And, where do I need to define actaul website add***s?
Also, how do I Add a column link for a report and give it in the URL?
Can you please give me little more details.
Thank you in advance,
Venkat.

How to use the option BLOB column specified in item source attribute(Storage in apex)
written by mohsinkhan , December 23, 2010

Hi,

I am trying to store the data other than wwv_flow_files how can i do it.

Please share your knowledge and help me out !!!

Thanks

table order
written by Rony , January 22, 2011

hi all ,

i have created report using sql in one table and i need to sort the table because the sort element does not work for that table. could anyone help me

create DHTML list dynamically in APEX 3.2
written by Digisha , May 10, 2011

Hi,

I am new to APEX.
I have manually created DHTML list using lists in APEX. I want to create it dynamically using tables.
I tried but not worked for me.
i choose DHTML list because i want it in (+) sign when click on it all sub list entries should be displayed
and also wanted to create something like when user click on one particular sub entry it should be saved in database
with other fields of table.

Was just wondering if any one came across this sort of query or design.

Thanks in Advance

Regards,
Digisha

How to invoke the sql plus commands via a buttom
written by sarah , August 26, 2011

hi all ,

i am trying to put some sql plus commands together,like the following,
set feedback off
set echo off
set linesize 10000
set heading off
set pagesize 0
set trimspool on
set space 0
set truncate on
spool myout.lst
select 1 from dual
exit
to be invoked by a buttom on the apex webpage.But it doesn't work.
could anyone help me ?
Can they be embedded to the javascript?

Thanks.

Sarah

changing the colors in APEX
written by kahuna1939 , August 31, 2011

Hi ,
How would I do the following in APEX.
Have an application , theres nothing special about the application. I want a button that will allow me to change the colour of the blackground and text colour when I click it. I want to change the background to Black and the text colour to yellow leaving everything else the same.
If you have any pointers that'd be great. ...

thanks

How to send email in apex
written by ompratap singh , November 09, 2011

Hi,
Will u plz help me in sending mail using oracle apex.

Apex Dynamic Display of Columns
written by Rajesh V , December 04, 2011

I have a small issue in Apex. My issue is

I have created a Display item say Voucher Date and also created another Drop Down item containing some Values. Eg Between, Less than, Equal to etc.

Now i want the following.

When the user selects the value Between, two text box should appear and accept the dates

When the user selects the Value Less than, then only one text box should appear and accept the value

Is it possible in Apex? If so, kindly advice and provide me a solution.

Thanks

Rajesh V

Email option in Apex
written by Kiranmaye , December 27, 2011

We are using Oracle 11.2.0. What is the process of sending an email using apex.?

How to create the login page in Apex
written by gurujothi , March 30, 2012

Hi Kishore,
Am entirely new to Oracle apex,I need to develop one application for that I need to create the login page , when the user
enters there username and password it should be redirected to next page which is a form to enter their details,
Can you please kindly tel me where to start and how to proceed.Am new to this please guide me.

Thank you,

With regards,
Gurujothi.D