Home/Vinish/Best Answers
  1. Asked:

    How to add CSS to navigation bar item in Oracle Apex

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    You will have to inspect the element containing the value. In my case, I found the below CSS classes, and it worked for me. Follow these steps: Create a CSS file name it notification.css and paste the following CSS in it: a.t-Button--navBar .t-Button-label { background-color: red; padding-left: 5px;Read more

    You will have to inspect the element containing the value. In my case, I found the below CSS classes, and it worked for me. Follow these steps:

    Create a CSS file name it notification.css and paste the following CSS in it:

    a.t-Button--navBar .t-Button-label {
background-color: red;
padding-left: 5px;
padding-right: 5px;
padding-top: 2px;
padding-bottom: 2px;
border-radius: 3px;
}

    Save the CSS file and close.

    In Oracle Apex, click on the Shared components > Application Static Files and upload this notification.css file. After uploading, it will show you the record. Copy the text from the reference column; it should be something like #APP_IMAGES#notification.css.

    Now click on the Shared Components > User Interface Attributes > Cascading Stylesheets, and in the File URLs field, paste the #APP_IMAGES#notification.css in the next line.

    Click on the Apply button and test your application.

    See less
    • 1
  2. Asked:

    Region header text not wrapping / responsive

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    Yes, you will have to apply the CSS to wrap heading text. Follow these steps: Assign a Static ID to your region, for example, Advanced > Static ID > MyReg. Then add the following CSS to Page > CSS > Inline section: h2#myReg_heading {width: 50%;} Actually, the standard CSS to wrap text isRead more

    Yes, you will have to apply the CSS to wrap heading text. Follow these steps:

    Assign a Static ID to your region, for example, Advanced > Static ID > MyReg.

    Then add the following CSS to Page > CSS > Inline section:

    h2#myReg_heading {width: 50%;}

    Actually, the standard CSS to wrap text is word-break: normal, white-space: normal, etc.; this was not working with the region title. Only width: 50%; worked for me. You can try it.

    See less
    • 0
  3. Asked:

    How to store varchar value as integer in another table?

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    If the student ids not containing any alphabet, you can directly store them into the column having integer data type. You don't even need any function for the conversion. If you are getting any specific error, then please give the details.

    If the student ids not containing any alphabet, you can directly store them into the column having integer data type. You don't even need any function for the conversion.

    If you are getting any specific error, then please give the details.

    See less
    • 0
  4. Asked:

    How to save data from rich text editor, without HTML tags

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    In a region, you can show the comment data as-is with HTML tags so that it can get the same formatting.

    In a region, you can show the comment data as-is with HTML tags so that it can get the same formatting.

    See less
    • 0
  5. Asked:

    HOW CAN THE GRAPHICS IN ORACLE APEX BE WIDER?

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    The better way to make images wider use CSS. For your Display Image item, try the following CSS in Advanced > Custom Attributes: style="display: block; margin-left: auto; margin-right: auto; width: 95%;" Also, you can try: style="max-width: 400px; max-height:150px;"

    The better way to make images wider use CSS. For your Display Image item, try the following CSS in Advanced > Custom Attributes:

    style="display: block; margin-left: auto; margin-right: auto; width: 95%;"

    Also, you can try:

    style="max-width: 400px; max-height:150px;"
    See less
    • 1
  6. Asked:

    Displaying image in modal window

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    You need to apply some CSS. Follow the below steps: Click on your Display Image item, then in the Advanced > Custom Attributes, paste the following style code: style="max-width: 400px; max-height:150px;" You can change the max-width and max-height according to your modal dialog size. It worked foRead more

    You need to apply some CSS. Follow the below steps:

    Click on your Display Image item, then in the Advanced > Custom Attributes, paste the following style code:

    style="max-width: 400px; max-height:150px;"

    You can change the max-width and max-height according to your modal dialog size.

    It worked for me. Please try and let me know.

    See less
    • 1
  7. Asked:

    adjust error column in data load results page in Oracle Apex

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    In Oracle Apex, upload data wizard logs error information in the collection and creates the report using the collection. So it is better to modify the query to replace the error column usually (c048) using the case statement. Below is an example: In the "Data Load Results" page, modify the failed reRead more

    In Oracle Apex, upload data wizard logs error information in the collection and creates the report using the collection.

    So it is better to modify the query to replace the error column usually (c048) using the case statement. Below is an example:

    In the "Data Load Results" page, modify the failed records region query as following:

    select n001 as row_num,
wwv_flow_lang.system_message( 'DATA_LOAD.' || c049 ) as action,
case when substr(c048, 1, 14) = '-1 : ORA-00001' then
'Duplicate row'
else 
c048
end error,
c001, c002, c003,
c004, c005, c006,
c007, c008, c009,
c010, c011, c012,
c013, c014, c015,
c016, c017, c018,
c019, c020, c021,
c022, c023, c024,
c025, c026, c027,
c028, c029, c030,
c031, c032, c033,
c034, c035, c036,
c037, c038, c039,
c040, c041, c042,
c043, c044, c045
from apex_collections
where collection_name = 'LOAD_CONTENT'
and c047 in ('FAILED') 
order by seq_id

    In the above query, you can see, I am checking the first 14 characters of the C048 column, that if the value is '-1 : ORA-00001', then replacing the error message with Duplicate Row. Similarly, you can replace any other errors too.

    The following is the output now:

    Oracle Apex: Data upload error.

    See less
    • 1
  8. Asked:

    APEX 20.2: Creating Karaoke screens

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    You can execute PL/SQL code to read the value from the database using JavaScript. Below is an example: Click on the process tab and then click on the Ajax Callback node and create a process. And add the PL/SQL code in it to get the song words, for example: Declare v_words varchar2(1000); Begin selecRead more

    You can execute PL/SQL code to read the value from the database using JavaScript. Below is an example:

    Click on the process tab and then click on the Ajax Callback node and create a process. And add the PL/SQL code in it to get the song words, for example:

    Declare
   v_words varchar2(1000);
Begin
   select song_words into v_words
      from song where song_id = :p1_song_id;
 
  htp.p(v_words);

exception 
   when others then 
    htp.p('ERROR');
End;

    Give any name to the above Ajax callback process, for example, AjxGetWords. Now call it using JavaScript below:

    apex.server.process('AjxGetWords',
{
pageItems : '#P1_SONG_ID' // page items to submit
}
,
{
dataType : 'text', success : function(data)
{
if(data != 'ERROR') apex.item('P1_SONG_WORDS').setValue(data);
}
}
)

    Try it.

    See less
    • 1
  9. Asked:

    ORA-00920 in SELECT clause when interrogating user role.

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    Some inbuilt packaged functions do not work with SQL queries. You can create a function and can use it in your query. Below is an example: create or replace function user_has_role (i_app_id in number, i_app_user in varchar2) return varchar2 is l_is_admin boolean := false; v_value varchar2(1); beginRead more

    Some inbuilt packaged functions do not work with SQL queries. You can create a function and can use it in your query. Below is an example:

    create or replace function user_has_role (i_app_id in number, i_app_user in varchar2)
return varchar2
is
l_is_admin boolean := false;
v_value varchar2(1);
begin
l_is_admin := APEX_ACL.HAS_USER_ROLE (
p_application_id => i_app_id,
p_user_name => i_app_user,
p_role_static_id => 'ADMINISTRATOR' );

if not l_is_admin then
v_value := 'N';
else
v_value := 'Y';
endif;

return v_value;

end;

    Then use the above function in your query:

    select ALBUM_TITLE,
YEAR_OF_RELEASE,
ALBUM_ID,
ARTIST_ID,
ALBUM_TYPE_ID,
COMMENTS,
COVER_ART_BLOB_CONTENT,
COVER_ART_MIME_TYPE
from MUSIC_ALBUMS
where 0=1 OR user_has_role(:APP_ID, :APP_USER) = 'Y'
    See less
    • 0
  10. Asked:

    How to print large clob data using htp.p method in oracle apex

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    Below is an example to print CLOB data using PL/SQL dynamic content in Oracle Apex. Create a region as PL/SQL dynamic content and add the following code in the PL/SQL code section: declare v_clob clob; n_amt INTEGER := 4000; n_pos INTEGER := 1; v_buf VARCHAR2(4000); begin Select yourClobColumn intoRead more

    Below is an example to print CLOB data using PL/SQL dynamic content in Oracle Apex.

    Create a region as PL/SQL dynamic content and add the following code in the PL/SQL code section:

    declare
v_clob clob;
n_amt INTEGER := 4000;
n_pos INTEGER := 1;
v_buf VARCHAR2(4000);
begin

Select yourClobColumn into v_clob
  from yourTable where col1 = :px_item;

loop
begin
 dbms_lob.read(v_clob, n_amt, n_pos, v_buf);
 n_pos := n_pos + n_amt;
 htp.p(v_buf); 
 exception
 when no_data_found then
   exit;
end;
end loop;
END;

     

    See less
    • 1