Is there any possibility replicating the excel formatting to represent negative number in parenthesis of red color similr to the excel sheet. Currently i am using the autonumeric.js but there is not corresponding support format in Oracle DB. Current Format: FML999G999G999G999G990D00 Desired Format: ($123,345.02)
Discy Latest Questions
Hi I have a requirement to highlight the selected item or focused item label when there is a huge gap between the label and input box in a horizontal line bar items. I would like to mix both css styles, otherwise i have to write code for each item such as on focus or lost focus. Please find sample css code below. .apex-item-select:focus, .apex-item-text:focus, .apex-item-textarea:focus { background-color:#EFEAFC!important; border-color:#926BFA!important; } .t-Form-label { font-weight:bold; font-size:11.5px; font-family: sans-serif; color:#132436; text-transform: capiralize; /* Make text all uppercase */ }
How add new schema on online APEX workplace provided by oracle ?
mans605Contributor
hello every hope everyone is doing well so it happened that i work with oracle form 6 what i want to do is i have a coulmn called work place have the whole name of the work plave in the company what i did is divided it as the following select regexp_substr(work_place,'[^/]+', 1, 1) as "dep1" ,regexp_substr(work_place,'[^/]+', 1, 2) as "dep2" ,regexp_substr(work_place,'[^/]+', 1, 3) what i want to do now is to make a form with three item list dept1 dept2 dept3 where each one wholds its own dept so when the user whatever dept1 the list change depands on that partucler dept1 what should i do
Hi Sir, I have a question about a function that I call in a before-header process to redirect to the appropriate page. create or replace function redirect_page(p_user_name in varchar2) return varchar2 as v_redirect_url varchar2(100); branch_page table_1.PAGE%type; v_state table_1.STATE%type; v_finalpaper_id table_1.fpid%type; begin begin select fp.state, fp.page,fp.id into v_state, branch_page,v_id from table_1 fp left outer join users u on u.uuid=fp.uuid where lower(u.username)=lower(p_user_name); if v_state ='REQUESTED'then v_redirect_url:='f?p=100:95:&APP_SESSION.::NO::P95_ID:'||v_id; elsif v_state ='APPROVED'then v_redirect_url:='f?p=100:92:&APP_SESSION.::NO::P92_ID:'||v_id; end if; exception when no_data_found then v_redirect_url:='f?p=100:1:&APP_SESSION.::NO::'; end; return v_redirect_url; end; Now, when I call the function in the page, I get the 500 Internal Server Error DECLARE v_redirect_url VARCHAR2(100); BEGIN v_redirect_url:=redirect_page_finalpapers(:session_user_name); htp.init(); owa_util.redirect_url(v_redirect_url); apex_application.g_unrecoverable_error := true; END; I don't quite understand why this happening and would appreciate some help on here?
I have Classic Report in my oracle apex application I want to display name and image according to Page item selected only at the header part.
ChaitanyaProfessional
I have a form in my Oracle Forms application for Developing form i'm using Oracle Form Builder 10G,Now user has to write login id and password(authentication) to use the form i want to keep a button in the form so when user presses the button he is directly moved to oracle apex application without Writing login id and password(authentication) What i want to do is Once user does authecation in oracle forms application he doesnot have to authticate again in oracle apex
ShimulProfessional
create or replace FUNCTION base64encode(p_blob IN BLOB) RETURN CLOB IS l_clob CLOB; l_step PLS_INTEGER := 12000; -- make sure you set a multiple of 3 not higher than 24573 BEGIN FOR i IN 0 .. TRUNC((DBMS_LOB.getlength(p_blob) - 1 )/l_step) LOOP l_clob := l_clob || UTL_RAW.cast_to_varchar2(UTL_ENCODE.base64_encode(DBMS_LOB.substr(p_blob, l_step, i * l_step + 1))); END LOOP; RETURN l_clob; END; Please Explain this Function.
CREATE TABLE EMP (ID NUMBER, EMP_NAME VARCHAR2(50), ADDRESS VARCHAR2(500)); CREATE TABLE PROJECT (ID NUMBER, EMP_ID NUMBER, PROJECT_NAME VARCHAR2(50), LOCATION VARCHAR2(500))
Hi Everyone, The below image is the Employee Attendance details in a table , How do i count the number of Present(P), Absent(A) and Week off(WO) days for a particular Employee using SQL Thanks in advance...