15-Dec-2017 02:46:PM by: turntablez
@zootolo You can create form page based on table having blob column (in which you want to store uploaded file) and then you can select 'Blob column specified in Item Source attribute; as storage type in File Browse item.
15-Dec-2017 10:57:AM by: maheshdm
Hello, How to set file-name while downloading file from blob column of a table? I am using this SQL in classic report --> select FILE_NAME as "File Name", sys.dbms_lob.getlength(blob_content) as "Get File" from RC_X_FILES; With this 'file name just comes as 'download' but I want 'something.docx'. Any idea?
15-Dec-2017 10:37:AM by: maheshdm
hello apex beginner here, I'm having trouble uploading BLOB files to my database. I've searched for awhile and thus far, I've only found the following solution: - Use the file browse item to upload the file to APEX_APPLICATION_TEMP_FILES, and then in a 'After submit' process, retrieve values from the APEX_APPLICATION_TEMP_FILES and insert them into my own table. Even though the above solution does seem to somewhat work, I have to go through an extra table to upload a single file. I was wondering if there is an easier way to pull this off. thanks in advance :slightly_smiling_face: APEX v5.0.4
15-Dec-2017 09:11:AM by: zootolo
Navigate to the column in question, in the property pallet there are attributes that will allow you to change the alignment of header and column value
15-Dec-2017 08:28:AM by: alex.nuijten
Could some one please help me out?
15-Dec-2017 05:04:AM by: sgtlaxman
Hi Everyone, I have an issue with interactive reports Column heading and Value alignment. This happens when I create computed columns, the column heading is center and value is right left aligned. Dont see any way to adjust them.
15-Dec-2017 05:04:AM by: sgtlaxman
@pierre here is a bit of code that can get you close to the amount of DB space that the app is using in apex but this is precision-guesswork so no guarantee on accuracy.
14-Dec-2017 07:59:PM by: jaughenbaugh
yeah just change that to select or the option at the top if the drop-down
14-Dec-2017 07:58:PM by: jaughenbaugh
remove the type condition and it should work
14-Dec-2017 07:57:PM by: jaughenbaugh
sounds like the type condition is nullifying the button condition
14-Dec-2017 07:56:PM by: jaughenbaugh
Could someone explain this.. I am working on a DELETE button. Under Server-side condition, When-button Pressed=DELETE, Type= REQUEST != VALUE, VALUE=DELETE. What is this means? Thx.
14-Dec-2017 07:55:PM by: cwong
@pierre if you are worried about the size of the export, you could split up your app into several ones. In that case the exports will be smaller. You might even need to deploy just one or two of those “sub-apps” instead of the big chunk.
14-Dec-2017 07:32:PM by: roelhartman
@pierre another consideration is that the app export is really just the script to install the application so it has extra amounts of code to facilitate this. The data in the database is smaller by any measure. So the quest to ask is are you looking for the amount of storage your app is taking in the DB or in the flat file format of the export?
14-Dec-2017 05:58:PM by: jaughenbaugh
I think you are probably going to have to create a procedure that iterates through the hierarchy or APEX tables. I’m not sure what you want in terms of “size”, though.. Number of pages, regions, items, buttons? that won’t give you the size of the export file, but would give you an idea of the size of the overall application.
14-Dec-2017 03:30:PM by: doug.a.gault
Thanks @doug.a.gault my question is not just for export. How to see the size on an application without necessarily exporting it. .. maybe there is a view where we can see the size of pages, regions, items, and the attributes....? Or maybe we can write a procedure that automatically calculates it, without to export it ?
14-Dec-2017 03:28:PM by: pierre
@pierre - because the definition for an application is all metadata that lives inside the APEX tables, and reconstituting that metadata requires calls to the APEX API’s you can’t “know” the size of an export until it’s created. It all depends on the number of pages, regions, items, and the attributes of said components. Can I ask why you need to know the size prior to export?
14-Dec-2017 02:59:PM by: doug.a.gault
thanks @maxime_tremblay . It is important for me to know how much my application weighs. Unfortunately I have to export it to know that
14-Dec-2017 02:32:PM by: pierre
@pierre the filesize of an exported application cannot be determined without actually exporting the file why do you need to know the size of the file?
14-Dec-2017 02:28:PM by: maxime_tremblay
Hi, Someone know if there is an apex view to see how much the application weighs? currently to see how much the application weighs, I am forced to export it. thank you in advance
14-Dec-2017 01:20:PM by: pierre
@muhammadubaid here is the apex 5.0 Version
14-Dec-2017 11:47:AM by: pierre
The release notes will be available as part of the patch. So be patient...
14-Dec-2017 10:00:AM by: roelhartman
@roelhartman is the list of fixed bugs :ant: / changes already available or will I have to wait for the roll out?
14-Dec-2017 09:58:AM by: p.ettinger
It will be available for download (through myoraclesupport) very soon. I guess later this week or next week. Either way … before Christmas.
14-Dec-2017 09:49:AM by: roelhartman
@maxime_tremblay can i use in apex 5.0 version?
14-Dec-2017 05:15:AM by: muhammadubaid
Hey @shaun.mauer, I'll do it but it's kinda easy to see that. If you go to (| and aim into Tabs Region (Example 1) while refreshing the page you'll see "Tab 2" and "Tab 3" jumping...
14-Dec-2017 12:00:AM by: trevis
@trevis Could you possibly use ScreenToGif ( to record what it is doing and upload it here so we can see?
13-Dec-2017 11:01:PM by: shaun.mauer
Any other suggestion?
13-Dec-2017 10:57:PM by: trevis
I'm thinking to initially have the Tab Container hidden and then display it after the "jumping" finishes... not sure how to detect "jumping done" or if that is actually the best approach.
13-Dec-2017 10:56:PM by: trevis
Hey guys, does someone else also get annoyed when, using `Tab Container` template region, you see all sub-regions jumping from below region to inside the region? I have few sub-regions and it isn't nice seeing them jumping every time user loads the page.
13-Dec-2017 10:53:PM by: trevis
@thomas what do you mean by table? DB table, or HTML table, or something else?
13-Dec-2017 09:24:PM by: maxime_tremblay
hey I'm not sure how to ask this question but is there any way to grab all the rows in a table and put into a javascript array?
13-Dec-2017 07:57:PM by: thomas
@maxime_tremblay thanks. It works.
13-Dec-2017 06:38:PM by: mingat.dalai
if using an IR, this should work ```.a-IRR-table tr.highlight td { background-color: blue; color: white; }``` when you have a look at the UT CSS, you can see that the background color and text color are defined at the td level you had your CSS defined at the row level so the td's CSS is going to override whatever you have at the tr level
13-Dec-2017 06:33:PM by: maxime_tremblay
@mingat.dalai if possible don't use important, you should adjust the CSS so that you override the correct classes/selectors
13-Dec-2017 06:27:PM by: maxime_tremblay
@mingat.dalai try ```.highlight { background-color: blue !important; color: white !important; }``` I guess your CSS is overwritten by color definitions from Universal Theme
13-Dec-2017 06:11:PM by: matze276
Any idea why it is not working as expected? THanks.
13-Dec-2017 05:36:PM by: mingat.dalai
and using ``` $("#rgnMasterInst table").on('click','tr', function(e) { $(this).addClass('highlight'); })``` to hightlight the row when it is clicked.
13-Dec-2017 05:36:PM by: mingat.dalai
hi I defined a css in Header: ``` <style> .highlight { background-color: blue; color: white; } </style>```
13-Dec-2017 05:35:PM by: mingat.dalai

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
16-Dec-2017 00:00
0 replies
15-Dec-2017 21:44
Adding thousand seprator to a number field in Apex Interactive grid when tabs out from the field in
0 replies
15-Dec-2017 18:58
Apex 5.1 Modal Dialog is inheriting size from Wizard Dialog. Most annoying
1 replies - last reply: 15-Dec-2017 20:44- by: Runrig
C Patel
15-Dec-2017 17:20
APEX RESTful Service Resource Handler Query Not Displaying Added Column
0 replies
15-Dec-2017 16:40
How to set/ use simple checkbox in interactive report.
0 replies
15-Dec-2017 15:43
Processes not working after 2nd trigger created
2 replies - last reply: 15-Dec-2017 18:41- by: Idkfa2
Soukaina IDRI
15-Dec-2017 12:27
How and where to custom error page 'THIS SITE IS INACCESIBLE PAGE'
0 replies
15-Dec-2017 12:24
Sending iCalender event via mail
0 replies
15-Dec-2017 10:59
Images not appearing on Apex Public Page
3 replies - last reply: 15-Dec-2017 13:57- by: VukMNE
Soukaina IDRI
15-Dec-2017 10:06
How to use process row of external table/view
2 replies - last reply: 15-Dec-2017 17:15- by: Justin Warwick
15-Dec-2017 09:39
ApEx 5 style column width
4 replies - last reply: 15-Dec-2017 12:54- by: jozzh
Prashanth Raj
15-Dec-2017 09:21
Application Item - Not retaining value in session state inside scheduled Job
4 replies - last reply: 15-Dec-2017 13:55- by: Pavel_p
14-Dec-2017 21:24
How to Set IG item to null on focus
4 replies - last reply: 15-Dec-2017 18:41- by: John Snyders-Oracle
14-Dec-2017 19:59
Use of Cursor to display query results
5 replies - last reply: 15-Dec-2017 14:46- by: 4ec521da-6362-4197-92f0-13fd708f0983
14-Dec-2017 19:49
How to change position of the Login screen?
3 replies - last reply: 15-Dec-2017 16:54- by: Justin Warwick
14-Dec-2017 19:38
ORDS crashes when trying to download a file..
4 replies - last reply: 15-Dec-2017 20:19- by: TexasApexDeveloper
14-Dec-2017 00:32
Reference original/old values before submitting Report page
2 replies - last reply: 14-Dec-2017 04:29- by: LA County APEX
13-Dec-2017 21:14
Interactive Grid - Duplicate duplicates the wrong row
4 replies - last reply: 15-Dec-2017 19:31- by: sect55
13-Dec-2017 13:27
Refreshing page item after session state changed
2 replies - last reply: 15-Dec-2017 15:38- by: Neil Clare
11-Dec-2017 20:01
APEX 5.1 using desktop Application on ipad
1 replies - last reply: 15-Dec-2017 17:07- by: Justin Warwick
Jeff Kemp
11-Dec-2017 05:37
Quick SQL: some improvement needed
1 replies - last reply: 16-Dec-2017 00:18- by: Jeff Kemp
10-Dec-2017 05:04
How to customize the application URL?
12 replies - last reply: 15-Dec-2017 20:35- by: Raj_insight
08-Dec-2017 16:28
Apex 5.2 classic report column width
3 replies - last reply: 15-Dec-2017 12:50- by: jozzh
07-Dec-2017 19:14
Display Image in Classic Report link for Type = "Download Blob"
10 replies - last reply: 15-Dec-2017 18:30- by: ESVK
06-Dec-2017 06:40
Freeze first 2 columns in Tabular form
2 replies - last reply: 15-Dec-2017 22:02- by: Rotan


Juergen Schuster    Other On Air Show: Recording out "All about Security Part 2"
On Air, Security
14-Dec-2017 22:03:36 by: Juergen Schuster
Marc Sewtz    Other
5.1.4 is out!
APEX 5.1
11-Dec-2017 11:47:44 by: Juergen Schuster
Simon Greenwood  
Future of Oracle Forms
Forms (Oracle Forms)
14-Dec-2017 14:18:03 by: Juergen Schuster
Carsten Czarski  
All about the Rich Text Editor
Form, Items, Rich Text Editor
13-Dec-2017 16:11:59 by: Juergen Schuster
Juergen Schuster    Other
New Conference APEX Alpe Adria, 20-April-2018
13-Dec-2017 16:05:59 by: Juergen Schuster
Mazin Abdulah  
Version Control with APEX
13-Dec-2017 11:24:09 by: Juergen Schuster
Pranav Shah  
Save selected Interactive Grid Rows into a collection
Interactive Grid
12-Dec-2017 15:38:37 by: Juergen Schuster
Marko Gorički  
Interactive Grid: Fix blank toolbar DIV
Bugs, Interactive Grid
12-Dec-2017 13:43:05 by: Juergen Schuster
Joel Kallman  
Create Responsive Rich Text Editor
Form, Items, Rich Text Editor
11-Dec-2017 11:44:33 by: Juergen Schuster
Dimitri Gielis  
Reverse Engineering to Quick SQL
Quick SQL
11-Dec-2017 11:41:49 by: Juergen Schuster
Matt Mulvaney  Other
Video Presentation: Interactive Grid API
Interactive Grid, Webinar
08-Dec-2017 11:33:16 by: Juergen Schuster
Joel Kallman  
Bug Downloading Files in 5.1
APEX 5.1, Bugs
07-Dec-2017 23:40:11 by: Juergen Schuster
Scott Wesley    Other
Exporting Page with Shared Components
07-Dec-2017 15:48:36 by: Juergen Schuster
Juergen Schuster    Other On Air Show: Recording out "All about Security Part 1"
Security, Videos, Webinar,
07-Dec-2017 15:37:52 by: Juergen Schuster
Jason Aughenbaugh  
APEX IoT recipe
05-Dec-2017 22:45:58 by: Juergen Schuster
Mazin Abdulah  
ORDS API for read and write files
02-Dec-2017 23:18:17 by: Juergen Schuster
Tyson Jouglet    
New Plug-in: Session Timeout Indicator
Plug-ins, Session
01-Dec-2017 18:01:18 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #18 is out!
01-Dec-2017 15:11:03 by: Juergen Schuster
Marko Gorički    Other
Member of the Month: November, for 2 excellent Plug-ins and Blog Post
Member of the Month
30-Nov-2017 22:38:39 by: Juergen Schuster
Gerald Venzl    Other
New Podcast out: Gerald Venzl, The new Oracle Generation
30-Nov-2017 22:19:00 by: Juergen Schuster
Craig Sykes  Other
APEX and Search
30-Nov-2017 11:08:35 by: Juergen Schuster
Marko Gorički  
Icons before and after Items
Form, Items
30-Nov-2017 01:13:26 by: Juergen Schuster
Jeffrey Kemp  
Converting an APEX App to Multi Tenant
29-Nov-2017 11:14:45 by: Juergen Schuster
Juergen Schuster    Other
In order to keep the #orclapex stream relevant and clean from Q&A (which should go to the Forum, Slack or Mail), we don't retweet Q&As anymore
28-Nov-2017 22:37:35 by: Juergen Schuster
Scott Spendolini  Other
APEXSert 5.1 beta
Applications, Security
28-Nov-2017 17:59:23 by: Juergen Schuster
Juergen Schuster  Other
New Job-Offer: Senegal, Ziguinchor, permanent
28-Nov-2017 09:41:35 by: Juergen Schuster
Moritz Klein    
New Plug-in: JS-Tree Item
25-Nov-2017 21:12:46 by: Juergen Schuster
Miro Masnoglav    
New Plug-in: Save Files To Disk
25-Nov-2017 21:07:10 by: Juergen Schuster
Craig Sykes  
APEX Development on a Raspberry Pi
23-Nov-2017 11:28:03 by: Juergen Schuster
Erick Diaz    
New Plug-in: Time Dropper
22-Nov-2017 21:49:19 by: Juergen Schuster
Erick Diaz    
New Plug-in: Date Dropper
22-Nov-2017 21:46:32 by: Juergen Schuster
John Keymer  
Automated APEX Backup
21-Nov-2017 20:08:35 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20