Hi Sir, Good Evening i want to create ADD button in the form whenever i click on add button same to same all rows to come at last when i click on create button all data to insert into table
Discy Latest Questions
SwarupProfessional
Hi Sir, I am creating alphanumeric sequence number in the id field by using this create sequence VID1 start with 1 increment by 1 ------in Sql Commands (IF :P2_VOLUNTEER_ID IS NULL THEN SELECT 'A' || VID1.NEXTVAL INTO :P2_VOLUNTEER_ID FROM DUAL; END IF;)----Process in Application But the issues was that when i am creating something continuously its working fine if i leave for sometime or logout and login after some time or next day then the sequence number start from different number. Eg: continues A41,A42,A42 After logout and login or sometime A81,A82 But i need continues where i left from the next number onwards
SwarupProfessional
Hi Sir, I want to create Reset Password or Forgot Password link in the login screen,when should i click on that it should redirect to a form where i can provide my username and new password and confirm password. But i need without custom authentication schema.Please help me with steps.
VARSHAProfessional
Hi everyone, I'm using below code for Logo in Print Screen htp.p(' <img src="C:\Users\tec\Pictures\img.jpg" alt="test" width="50" height="50"></div> '); But the image is displaying Any help would be appreciated..
How to set page item to null, when browser is reloaded. I tried with DA after refresh but, it works only when I change page inside application not for reload page on browser button.
I have created a master detail form by Item & Grid. Qty * Rate = amount. I want the sum of the amount to be in total amount. before pressing the save button. how can i do this? https://apex.oracle.com/pls/apex/saidul_abc/r/master-detail10/login?session=107768956176789 User/Pass: demo/123
Hi, When I select a value in LOV, the page is submitted and the shuttle is sorted. I want to get results in the shuttle when I select a value in LOV without submit page. I tried with dynamic action to refresh the shuttle item. But, I didn't get any value on the right side of the shuttle. Thanks in advance!
Hi, I have created DEPT and EMP form as master-detail. Now based on Deptno# i want to print data in HTML Based. In this regard have following query if you please advise. Where to Write HTML Code How to call it at Button so above code Print the Report Is there any tool where i can execute the report data before printing, like for report result first we develop query in sql, is there any tool for testing. Thanks.
Hi Sir, I am using Apex 19.1 and i want to upgrade it to 20.1 please guide me the steps for that Thanx in advance
SwarupProfessional
Hi Sir, Can we generate barcode in oracle apex when we click on the field then a barcode should be generated for particular records
SM HasemContributor
How to add one column data to another column in same row in Interactive Grid on oracle apex? How to add one column data to another column in same row in Interactive Grid on oracle apex?
Hi! I'm trying to update flag column when dialog is closed, column is 1 or 0 when column is 1 it means that another user edit record (pessimistic locking). I tried with dynamic action, event: dialog closed, which is JavaScript expression contain "window", true action is pl/sql code. But, it wont update column 🙁 I hope I explained problem well. Thanks in advance!
BhavinProfessional
Hello Sir, I have a requirement to create a Wizard style form in Apex. It is exactly the same as the Order Processing in Sample Database Application. The change I need is, instead of using APEX_COLLECTION method for the Order Items I need to use Interactive Grid and save the data at the end in the Confirmation page. So process would be something like Customer Details -> Order Items -> Order Summary -> Confirm Order. Customer Details = to enter new customer details (Cust_Id is PK - auto generate on Seq) Order Items = to enter order details (Order_Id is PK, Order_Item_Id is PK - auto generated on Seq) Order Summary = to view/review current order Order Confirm = to confirm the current order and To Save data in Customers and Orders/Orders_Details tables respectively. Would it be possible for you to guide me and provide me the steps ? Your help is greatly appreciated.
SwarupProfessional
Hi Sir, I have created a lov with Approve All,Reject All. If i select approve all then all the status field should be approved vice versa dynamically
Hi! I use nested report with two Classic Reports, how can I use highlight based on column value for both?. Thanks in advance!
For example: I’m having an item :P1_SALES And I want to enter 1000+2000-1000 And it will give me 2,000 on the same item :P1_SALES Note I’m using a plug-in(AutoNumeric) for my input format
We need to insert and update BLOB Images in Oracle Apex through PL/SQL process without using default Create and Apply Changes buttons. Step by step Help and guidance is required P.S. 1. We do not want to add directory 2. We use row id as Primary Key.
I tried to make 2 buttons in one columns so to do this I create them using html code but I want to get the current row items value I tried to use data-id="#ROWID#" to get the rowid that I have in sql query and I used javascript dynamic action to get the value but I get the value as #ROWID# is there is anyway to get current row item value without using URL as column type Thanks
SupriyaJainContributor
Ihave below javascript code in , button click dynamic action :- var model = apex.region("DETAIL_GRID_ID").widget().interactiveGrid("getViews", "grid").model; var v_data_type, v_col1; v_data_type = model.getFieldKey("DATA_TYPE"); v_col1 = model.getFieldKey("COL1"); model.forEach(function(r) { console.log(r[v_data_type] +" "+ r[v_col1]); if(r[v_data_type] == 'Change_color') { console.log('In Change_color'); //Here I want to change color of that cell text //apex.item( "COL1" ).setStyle( "color", "red" ); } });
Hi! I want to display column "Last User Login" to IR(on that report I use database table) and display date and time for this column. Is there an apex table to track user logins? If exist, could I display this column on existing IR? Thanks in advance!