Stack Overflow
Stack Overflow

Questions tagged [oracle-apex]

Oracle Application Express (Oracle APEX) is a rapid Web application development tool that lets you share data and create applications. Using only a Web browser and limited programming experience, you can develop and deploy applications that are fast and secure.

Note: This is unrelated to the SalesForce Apex platform. Use the and/or tags for that.

Oracle Application Express (Oracle APEX, previously named Oracle HTML DB) is a software development environment based on the Oracle database. It allows a fast development cycle to be achieved to create web-based applications. It can be used for departmental-style applications with a dozen users, but can also scale up to handle thousands of users. The framework itself adds as little as 0.04 second of overhead to each page request; how well an application scales is primarily based on the efficiency of the SQL queries used by the application developer.

Oracle Application Express can be installed in an Oracle 9.2 or higher database, and from Oracle 11g to 12.1 it was preinstalled with the database. It is an optional no-cost feature with any Oracle database licence (including the free XE versions of the database).

Useful links

5236 questions
71
votes
11 answers

Is it possible to output a SELECT statement from a PL/SQL block?

How can I get a PL/SQL block to output the results of a SELECT statement the same way as if I had done a plain SELECT? For example how to do a SELECT like: SELECT foo, bar FROM foobar; Hint : BEGIN SELECT foo, bar FROM foobar; END; doesn't work.
GameFreak
  • 2,652
  • 5
  • 30
  • 38
47
votes
13 answers

Why use Oracle Application Express for web app?

I believe we're moving to Oracle Apex for future development. I've read about Oracle Apex on wikipedia and it's pro and con. It seem to me the con outweigh the pro but maybe I'm wrong. I get the sense that Oracle Apex is for DBA with little or no…
Jack
  • 9,235
  • 22
  • 75
  • 106
22
votes
3 answers

How to handle versioning with Oracle Apex

Oracle Apex is great. The biggest problem I have with it is using it along with source code control. Generally after making a change, the entire application gets exported and the resulting SQL script checked into source code control. The problem is…
eaolson
  • 13,131
  • 7
  • 37
  • 50
22
votes
16 answers

Get started link does not work in oracle 11g server

I have started using Oracle database server on Windows 7 64 bit OS and I have encountered the following error. "Error- Windows cannot find 'http://127.0.01:%HTTPPORT%/apex/f?p=4950'. Make sure you typed the name correctly, and then try again" I…
Ruba Mushtaq
  • 413
  • 2
  • 4
  • 11
15
votes
1 answer

Install ORDS with Apex 5.0

I would like to print reports in PDF format using apex 4.2.2 or v5. I have read that ORDS v3 is required to work even after enabling PDF in instance setting under apex admin. But during installation it halted the process as and when I check the URL…
Muhammad Muazzam
  • 2,714
  • 6
  • 25
  • 53
14
votes
1 answer

Problem in firefox when calling window.open

When i'm calling this code in the link of a chart in apex javascript:window.open('http://google.pt','mywindow','width=400,height=200', 'bReplace=true'); it opens a new window with google page but puts the chart page with a blank page with [object…
macwadu
  • 879
  • 4
  • 21
  • 44
12
votes
2 answers

Link one page to another in oracle apex

this is supposed to be simple i have two pages A and B what i want to do is add a button (a hyperlink or image will do) in page A that when clicked go to page B how can i do that ? thanks
Ahmed Kotb
  • 6,019
  • 5
  • 31
  • 52
12
votes
2 answers

How to access Oracle Apex variables from Javascript?

I'm using Oracle APEX but am unsure how to access the following variables from an external javascript file that may be located on the app server or stored in Shared Components -> Static Files. :APP_ID :APP_PAGE_ID :APP_SESSION How can I reference…
tonyf
  • 30,749
  • 43
  • 137
  • 216
11
votes
1 answer

Are Oracle PL/SQL arrays indexed from 0 or from 1?

I have in front of me a piece of code like this: FOR row IN 1..l_RowSet(1).count LOOP l_a_variable := l_RowSet(1)(row); END LOOP; l_RowSet is an ApEx type -- apex_plugin_util.t_column_value_list -- defined thus: type t_column_value_list is…
Jacques Chester
  • 610
  • 1
  • 4
  • 12
10
votes
10 answers

PL/SQL query IN comma deliminated string

I am developing an application in Oracle APEX. I have a string with user id's that is comma deliminated which looks like this, 45,4932,20,19 This string is stored as :P5_USER_ID_LIST I want a query that will find all users that are within this…
oracle_APEX_so
  • 101
  • 1
  • 1
  • 3
10
votes
2 answers

Oracle Apex: Javascript code in PL/SQL Block

Is it possible to have JavaScript code in the PL/SQL block. I want to execute the pl/sql block containing JavaScript code on submit in oracle Apex page process. DECLARE v_count NUMBER; BEGIN select count(*) into v_count from…
ApexDev
  • 167
  • 1
  • 1
  • 9
9
votes
2 answers

UPDATING Table Column with new Entry

I am working in Oracle APEX and I want to update column in a report with a new value in the following table. The Report Query is shown in the following diagram mentioned below. TABLE "VENDOR_ACCOUNT" ( "VEN_ACCOUNTID" NVARCHAR2(10), …
Usman YousafZai
  • 882
  • 4
  • 16
  • 39
9
votes
2 answers

How do you add an edit button to each row in a report in Oracle APEX?

I'm using Oracle APEX and I have a report region in a page that displays columns from a SQL query. I want to add edit buttons to the first column of this report so that the user can click on it and edit/review one of the results. How do I add this…
Corrine
  • 193
  • 2
  • 5
  • 11
8
votes
3 answers

importing CSV data in Oracle (trying Apex/SQL Developer)

I initially asked this on Superuser, but somebody advised me to repost here. I am using recent versions of APEX (4.1.1) and Oracle (11.2.0.3). I am uploading CSV data to a set of tables. I have been trying it out and am encountering some problems…
boisvert
  • 3,444
  • 2
  • 25
  • 50
8
votes
2 answers

Apex - Interactive Report - Hide Column in CSV Download?

I've got an interactive report in Apex with some columns. The user has the option to download the report as CSV file with the standard functionality. Is there a way to hide a column in the export but display it on the screen. (Background: one column…
Paul Fresner
  • 81
  • 1
  • 2
1
2 3
…
99 100