Slack

it's good now
22-Jan-2019 12:37:PM by: ERICKP
ok ,thanks its ok
22-Jan-2019 12:34:PM by: ERICKP
I hope you’re not asking how to create a view … and for virtual column, just google,
22-Jan-2019 12:33:PM by: roelhartman
Now your missing a semicolon at the end : :new.BILLET_100 ) ;
22-Jan-2019 12:33:PM by: roelhartman
how ??
22-Jan-2019 12:31:PM by: ERICKP
CREATE or replace TRIGGER tri_MONTANT before insert or update ON "TTRASACTION" for each row begin :new.MONTANT:= (:new.BILLET_1 + :new.BILLET_5 + :new.BILLET_10 + :new.BILLET_20 + :new.BILLET_50 + :new.BILLET_100 ) end; /
22-Jan-2019 12:31:PM by: ERICKP
message error(Erreur(11,1): PLS-00103: Encountered the symbol "FROM" when expecting one of the following: * & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between overlaps || multiset year day member submultiset The symbol "* was inserted before "FROM" to continue. )
22-Jan-2019 12:29:PM by: ERICKP
remove “from TTRASACTION” from that trigger. But you shouldn’t store that redundant data in the first place, You should use a view or a virtual column to show the sum.
22-Jan-2019 12:28:PM by: roelhartman
i tried whith :CREATE or replace TRIGGER tri_MONTANT before insert or update ON "TTRASACTION" for each row begin :new.MONTANT:= (:new.BILLET_1 + :new.BILLET_5 + :new.BILLET_10 + :new.BILLET_20 + :new.BILLET_50 + :new.BILLET_100 ) from TTRASACTION ; end; / but they have error !!
22-Jan-2019 12:26:PM by: ERICKP
HOW create a trigger to sum (BILLET_1 + BILLET_10 + BILLET_20), the sum put it in MONTANT ???
22-Jan-2019 12:24:PM by: ERICKP
CREATE TABLE "TTRASACTION" ( "NTRANS" NUMBER NOT NULL ENABLE, "USER_NAME" VARCHAR2(30) NOT NULL ENABLE, "TYPE_OPERATION" CHAR(1) NOT NULL ENABLE, "NCOMPTE" NUMBER NOT NULL ENABLE, "BORDEREAU" VARCHAR2(30), "LIBELLE_OPERATION" VARCHAR2(100), "BILLET_1" NUMBER(10,0), "BILLET_5" NUMBER(10,0), "BILLET_10" NUMBER(10,0), "BILLET_20" NUMBER(10,0), "BILLET_50" NUMBER(10,0), "BILLET_100" NUMBER(10,0), "MONTANT" NUMBER(10,0), "MONTANT_EN_LETTRE" VARCHAR2(100), "CREER_LE" TIMESTAMP (6), CONSTRAINT "TTRASACTION_PK1" PRIMARY KEY ("NTRANS") ENABLE )
22-Jan-2019 12:21:PM by: ERICKP
soit :
22-Jan-2019 12:21:PM by: ERICKP
Nevermind, forgot about the number field automatically trimming zeroes, frustratingly.
22-Jan-2019 12:19:PM by: Ross Henderson
Is there a way to preserve leading zeroes in an Interactive Report?
22-Jan-2019 12:07:PM by: Ross Henderson
Will explore that and get back to you @maxime_tremblay
22-Jan-2019 12:02:PM by: Kiran D
>This example shows how you can control the ability to update or delete on a per row basis. See the CTRL column that implements a simple rule that managers and presidents cannot be edited or deleted. This column is selected in attribute Edit: Allowed Row Operations Column. Remember to set Source: Query Only to Yes for any column that is an expression that cannot be updated. > >Rows that cannot be edited are show in a darker color when in edit mode.
22-Jan-2019 12:00:PM by: maxime_tremblay
Have a look at the sample interactive grid package application The example “Protected Rows” is exactly what you want
22-Jan-2019 11:59:AM by: maxime_tremblay
Ok :wink:
22-Jan-2019 11:58:AM by: maxime_tremblay
Sorry, rows*
22-Jan-2019 11:57:AM by: Kiran D
You want to disable the columns or rows?
22-Jan-2019 11:56:AM by: maxime_tremblay
Hi All, My scenario is I have to disable "deptno 10" related columns in IG and rest of the department columns should be editable. How to achieve this in IG??
22-Jan-2019 10:54:AM by: Kiran D
You will need to use a REST service to do it. It's normally really quite easy to do.
21-Jan-2019 09:29:AM by: Ross Henderson
Hi ,bug in apex18.2 : when i use popup lov colums in interactive grid for label in chart show me this error 'no_data_found'
20-Jan-2019 09:28:PM by: meysam
:joy:
19-Jan-2019 02:58:PM by: Nadine Bri
2 hours lifetime wasted for a non-existent option :ballot_box_with_check:
19-Jan-2019 02:57:PM by: Nadine Bri
Must be an error :sweat_smile:
19-Jan-2019 02:53:PM by: maxime_tremblay
:see_no_evil:
19-Jan-2019 02:53:PM by: maxime_tremblay
I checked again. It's really there in the documentation, see screenshot. Here the URL: https://docs.oracle.com/en/database/oracle/application-express/18.2/htmig/upgrading-from-previous-Oracle-application-express-release.html#GUID-0E9AC015-883E-406C-96C5-FCAB7CD54CD1
19-Jan-2019 02:11:PM by: Nadine Bri
Ah, OK, thanks. I read in the documentation somewhere that I should have 18.2 in the selection. Therefore I thought that something went wrong...
19-Jan-2019 02:05:PM by: Nadine Bri
5.1/18.1 is the latest so you should go with that one
19-Jan-2019 02:04:PM by: maxime_tremblay
I did some time ago and it’s working :wink:
19-Jan-2019 02:00:PM by: maxime_tremblay
Hi all, I upgraded APEX to 18.2. However, in the app settings compatibility mode, I cannot set the compatibility mode to the current version. There is no 18.2 or 'current version' entry in this dropdown field. Maximum is 5.1 / 18.1. According to documentation, there should be an entry for current version. I already searched the instance settings for a global option which prevents me from doing this, and I also upgraded all offered application items in the app utilities, but without result. Any ideas on this?
19-Jan-2019 10:35:AM by: Nadine Bri
Thanks Maxime! I read this and it sounds like a solution. However, I did not try it out yet.
19-Jan-2019 10:29:AM by: Nadine Bri
Hi, Does anyone have experience sending SMS using APEX application?
18-Jan-2019 09:54:PM by: Didou
Hello !! How create the page of reset password on apex5 ??
18-Jan-2019 11:23:AM by: ERICKP
I don't think there is a way to get the MAC-address. You can run this in the SQL Command window, to see what kind of CGI information you might get. begin owa_util.print_cgi_env(); end;
18-Jan-2019 11:16:AM by: svenweller
Good idea! The log seems to have the info, but it is dificult to distinguish between the various developers. Apex_application_pages is also promising. But it seems empty when looking at it from inside an app. I could grant access to the base tables, but that option limits its usefullness to environments where we can set such a thing up. Also there is the cookie ORA_WWV_REMEMBER_UN which often has the info I want.
18-Jan-2019 11:03:AM by: svenweller
Hello all. if i have multiple Interactive Reports on one page and I need to have an export to CSV button for each of them instead of using the download option under actions. I know I can use this link f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.:CSV: if I have one report on a page. Does anyone know how I can modify this link to work on multiple IR's on one page, each having its own Export to CSV button? thank you!
17-Jan-2019 09:15:PM by: abul_feed
you could try to query apex_workspace_activity_log
17-Jan-2019 07:02:PM by: peterraganitsch
My default solution for this problem is to use two items. One to display which is not stored and one hidden to store.
17-Jan-2019 06:21:PM by: svenweller
From inside an apex app, is there a way to find out which developer is currently logged on/working? Like the APP_USER of the page designer app itself.
17-Jan-2019 06:13:PM by: svenweller
Colleague got it working, I made a mistake (y)
17-Jan-2019 10:54:AM by: Ross Henderson
It doesn't seem unfortunately. I forgot to mention that the key is generated on page load by returning a random 16 digit string via a function. So if I call it again by the computation it will return a new key, not the one that's displayed.
17-Jan-2019 10:16:AM by: Ross Henderson
Thanks Maxime, I'll give it a go today!
17-Jan-2019 08:47:AM by: Ross Henderson

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
Eslam_Elbyaly
22-Jan-2019 10:52
Selection doesn't change automatically - Is it a bug?!
Link
0 replies
3417553
22-Jan-2019 10:12
Apex connection problem
Link
1 replies - last reply: - by:
AhmedHelmy
22-Jan-2019 09:44
Jet Chart Stacked Tooltip
Link
1 replies - last reply: - by:
Martijnke
22-Jan-2019 08:53
migrate from apex 3.2 to 18.2
Link
3 replies - last reply: - by:
ar_dev_mea
22-Jan-2019 06:43
PDF generated file store in physical location(oracle directory)
Link
0 replies
user6248358
22-Jan-2019 01:58
Apex Mail
Link
1 replies - last reply: 22-Jan-2019 02:24- by: Scott Wesley
K Cannell, TH
21-Jan-2019 20:16
APEX 18.2 Data Load Wizard w date format - no data found
Link
5 replies - last reply: 22-Jan-2019 04:58- by: K Cannell, TH Tech
Hoek
21-Jan-2019 20:07
APEX 18 - Social sign-in Google keeps on giving "Null username passed to login procedure"
Link
1 replies - last reply: 21-Jan-2019 22:56- by: Scott Wesley
LukeT
21-Jan-2019 18:27
IR report slower in 18.2
Link
0 replies
AmitK05
21-Jan-2019 17:51
Interactive Grid report display in APEX
Link
1 replies - last reply: 21-Jan-2019 20:32- by: Jorgelina
Eslam_Elbyaly
21-Jan-2019 15:06
Debugging in Apex
Link
5 replies - last reply: 22-Jan-2019 04:54- by: Angel Flores T.
Eslam_Elbyaly
21-Jan-2019 15:03
Debugging in Apex
Link
1 replies - last reply: 22-Jan-2019 04:54- by: Angel Flores T.
92e9890f-f55d
21-Jan-2019 14:51
APEX_APPLICATION_PAGES missing
Link
3 replies - last reply: 21-Jan-2019 17:02- by: 92e9890f-f55d-40ae-ad89-c13cf308ff52
Eslam_Elbyaly
20-Jan-2019 18:26
Hosting an apex based website
Link
7 replies - last reply: 21-Jan-2019 20:00- by: Eslam_Elbyaly
ebenwalker
20-Jan-2019 16:16
Tab Key control on an Interactive Grid
Link
1 replies - last reply: 22-Jan-2019 05:02- by: K Cannell, TH Tech
Ananda Basak
18-Jan-2019 19:40
How to set value of a page item on Mouse enter on a report column
Link
6 replies - last reply: 21-Jan-2019 17:50- by: Ananda Basak
Lauricio
18-Jan-2019 11:29
APEX 5.1 send mail
Link
4 replies - last reply: 22-Jan-2019 05:07- by: Angel Flores T.
NelsonMendes
17-Jan-2019 20:32
How to create a validation between 2 date picker fields :PA cannot be > then :PB
Link
9 replies - last reply: 21-Jan-2019 16:43- by: Franck N
PraveenSwa
16-Jan-2019 15:48
Oracle Apex 18.2 - Issue with LoV, Text with Autocomplete and DA
Link
7 replies - last reply: 21-Jan-2019 16:25- by: Jorgelina
idrees
16-Jan-2019 06:03
oracle apex architecture and suggestions for ORDS or Embedded PL/SQL Gateway
Link
2 replies - last reply: 22-Jan-2019 05:14- by: idrees
AhmedHelmy
14-Jan-2019 13:36
Pie Chart Title
Link
5 replies - last reply: 21-Jan-2019 16:12- by: Hilary Farrell-Oracle
Bradley Burge
12-Jan-2019 21:20
Email URL to populated page
Link
2 replies - last reply: - by:
Fahd Bahoo
03-Jan-2019 19:20
Hide Action Button from Interactive Grid
Link
13 replies - last reply: - by:
ouadaz
13-Dec-2018 08:42
Apex 18.1 Bubble Chart label not displayed
Link
1 replies - last reply: 21-Jan-2019 18:03- by: Hilary Farrell-Oracle
Eslam_Elbyaly
09-Dec-2018 10:09
Master-Detail between a form on a table and an interactive grid
Link
12 replies - last reply: 21-Jan-2019 14:50- by: Oleh Tyshchenko

News

X
    
 
ImageNewsFavoriteForward
Jackie Mcilroy    Other
First Live #LowHighPodcast: Feb. 6th, 12pm ET, join and participate
Podcast
Link
17-Jan-2019 19:32:49 by: Juergen Schuster
Jaydip Bosamiya  
Custom Nested Reports
Reports, jQuery
Link
22-Jan-2019 07:41:54 by: Juergen Schuster
Scott Wesley  
Customizing Session Expiry
Session
Link
22-Jan-2019 02:56:39 by: Jackie Mcilroy
Marc Sewtz    Other
Webinar: Municipal Open Data APIs, Feb. 7th
REST, Webinar
Link
21-Jan-2019 18:38:17 by: Juergen Schuster
Dimitri Gielis  Other
Advantages and Disadvantages of APEX new release system
APEX 18, Installation
Link
21-Jan-2019 15:14:17 by: Jackie Mcilroy
Tobias Arnhold  Other
APEX Competition 2019
Press
Link
21-Jan-2019 14:59:05 by: Jackie Mcilroy
morteza mashhadi  
intro.js quick help
Help
Link
19-Jan-2019 12:08:08 by: Juergen Schuster
Carsten Czarski  
Interactive Grid on Web Source Modules Part 2
Interactive Grid, REST
Link
18-Jan-2019 20:15:39 by: Juergen Schuster
Niels de Bruijn  
New Kerberos SSO version
Authentication, SSO
Link
18-Jan-2019 16:19:06 by: Juergen Schuster
morteza mashhadi  
Alternative Reporting in Stimulsoft
Charts, Reports
Link
18-Jan-2019 06:53:37 by: Juergen Schuster
Carsten Czarski    Other
Office Hours: Fuzzy Search, Jan, 24th
Webinar
Link
17-Jan-2019 19:58:11 by: Juergen Schuster
Scott Wesley  
Switch authentication schemes at runtime
APEX 18, Authentication
Link
17-Jan-2019 17:55:35 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: USA, Salt Lake City, permanent, on site
Jobs
Link
17-Jan-2019 15:56:45 by: Juergen Schuster
Scott Wesley  
Social Sign-in Authentication
Authentication, SSO
Link
17-Jan-2019 03:40:09 by: Jackie Mcilroy
Scott Wesley  
Application Session Sharing
APEX 18, Authentication
Link
17-Jan-2019 03:35:48 by: Jackie Mcilroy
Juergen Schuster  Other
New Job Offer: Germany, Munich, permanent, Working Visa
Jobs
Link
15-Jan-2019 20:38:50 by: Juergen Schuster
Juergen Schuster    Other
New Slack Channel: #aop for the free unsupported cloud tier, join
Slack
Link
14-Jan-2019 16:16:04 by: Juergen Schuster
Dimitri Gielis    Other
AOP 19.1 is out, Free to use Development Mode on Cloud
Printing
Link
14-Jan-2019 16:08:31 by: Juergen Schuster
Craig Sykes  
Use Oracle's Apiary to document your Webservice
REST
Link
14-Jan-2019 15:15:29 by: Juergen Schuster
Martin Nielsen  
Maximize JET Charts
JET
Link
13-Jan-2019 19:44:15 by: Juergen Schuster
Andrei Radzetski    
New Plug-in: Load Files from local file system directly to 3rd party cloud providers
File Upload, Plug-ins
Link
11-Jan-2019 18:03:42 by: Juergen Schuster
Patrick Wolf    Other
Video Office Hours: Page Designer
Page Designer, Videos
Link
11-Jan-2019 16:34:47 by: Juergen Schuster
APEXUTIL Wrocław  
Store Files outside the DB into public cloud
File Upload
Link
11-Jan-2019 15:50:03 by: Juergen Schuster
Connor McDonald  
ORDS 404 Error connecting to APEX
Error, ORDS
Link
11-Jan-2019 15:32:16 by: Juergen Schuster
Craig Sykes  
Creating an online leaderboard
Applications
Link
10-Jan-2019 19:58:16 by: Juergen Schuster
Patrick Wolf  Other
Webinar: Page Designer Deep Dive, Office Hours, January 10th
Webinar
Link
10-Jan-2019 03:14:08 by: Jackie Mcilroy
Joel Kallman    Other
New Podcast out: Joel Kallman, Make Oracle Cool Again ( MOCA )
Podcast
Link
09-Jan-2019 19:45:15 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #31 is out!
Newsletter
Link
07-Jan-2019 15:40:08 by: Juergen Schuster
Jackie Mcilroy    Other
New Podcast: Don't Delete the Package! #LowHighPodcast
Podcast, Press, apex.world
Link
06-Jan-2019 17:52:19 by: Jackie Mcilroy
Alexis Galdamez    Other
New Video Training in Spanish
Trainings
Link
05-Jan-2019 00:31:05 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Oracle, USA, San Francisco, permanent
Jobs
Link
04-Jan-2019 20:37:44 by: Juergen Schuster
Simon Boorsma    
New Plug-in: Post-it Stickers
Plug-ins
Link
03-Jan-2019 15:23:16 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20