Qaium's IT Demonstration: July 2020

Saturday, July 25, 2020

Split A String By Coma (,)

Step 1.
create or replace type split_tbl as table of varchar2(32767);

Step 2.
create or replace function split
(
p_list varchar2,
p_del varchar2 := ','
) return split_tbl pipelined
is
l_idx pls_integer;
l_list varchar2(32767) := p_list;
l_value varchar2(32767);
begin
loop
l_idx := instr(l_list,p_del);
if l_idx > 0 then
pipe row(substr(l_list,1,l_idx-1));
l_list := substr(l_list,l_idx+length(p_del));

else
pipe row(l_list);
exit;
end if;
end loop;
return;
end split;

Step 3.

SELECT COLUMN_VALUE my_string FROM TABLE (split('Muhammad,Abdul,Qaium'));

Tuesday, July 7, 2020

User Wise Application Color In Oracle Apex

1. Create Global Item AI_HDR_COLOR AI_SELECTOR_COLOR AI_SIDE_COLOR 2.Page Template Standerd For Header <div class="t-Header-branding" style="background: &AI_HDR_COLOR. !important;" role="banner"> 3. Side Navigation Menu Template For Navigation Menu <style> .t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-current, .t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-current--top.is-selected, .t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-selected { background-color: &AI_SELECTOR_COLOR. !important; } .t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-hover{ background-color: &AI_SELECTOR_COLOR. !important; } </style> <div class="t-TreeNav #COMPONENT_CSS_CLASSES#" id="t_TreeNav" style="background: &AI_SIDE_COLOR. !important;" data-id="#PARENT_STATIC_ID#_tree" aria-label="&APP_TITLE!ATTR."> <ul style="display:none">

1. Create Global Item

AI_HDR_COLOR
AI_SELECTOR_COLOR
AI_SIDE_COLOR

2.Page Template Standerd For Header

<div class="t-Header-branding" style="background: &AI_HDR_COLOR. !important;" role="banner">

3. Side Navigation Menu Template For Navigation Menu

<style>
.t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-current, .t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-current--top.is-selected, .t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-selected {
background-color: &AI_SELECTOR_COLOR. !important;
}
.t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-hover{
background-color: &AI_SELECTOR_COLOR. !important;
}
</style>

<div class="t-TreeNav #COMPONENT_CSS_CLASSES#" id="t_TreeNav"
style="background: &AI_SIDE_COLOR. !important;"
data-id="#PARENT_STATIC_ID#_tree" aria-label="&APP_TITLE!ATTR.">
<ul style="display:none">

Monday, July 6, 2020

Color Header and Navigation Manu

Oracle Apex Version 19.2

CSS:

<style>
.t-Header-branding{
background: rgb(200,86,98)!important;
background: radial-gradient(circle, rgba(200,86,98,1) 0%, rgba(130,20,32,1) 45%, rgba(102,9,19,1) 61%, rgba(84,7,16,1) 77%, rgba(51,2,7,1) 90%) !important;
}

.t-TreeNav {
background: rgb(200,86,98)!important;
background: radial-gradient(circle, rgba(200,86,98,1) 0%, rgba(130,20,32,1) 45%, rgba(102,9,19,1) 61%, rgba(84,7,16,1) 77%, rgba(51,2,7,1) 90%) !important;
}

.t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-current, .t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-current--top.is-selected, .t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-selected {
background-color: #2e0308 !important;
}

.t-TreeNav .a-TreeView-node--topLevel .a-TreeView-row.is-hover{
background-color: #2e0308 !important;
}

</style>

Friday, July 3, 2020

Add Music Into Oracle Apex

Add Music Into Oracle Apex 1. upload audio file into static application file 2. create region with static content and copy pest the below code into the region. 3. To automatically play the audio you have to use "autoplay" like <audio controls autoplay>

1. upload audio file into static application file

2. create region with static content and copy pest the below code into the region.

3. To automatically play the audio you have to use "autoplay" like <audio controls autoplay>

<!DOCTYPE html>
<html>
<body>

<h1>The audio autoplay attribute</h1>

<p>Click on the play button to play a sound: autoplay </p>

<audio controls >
<source src="#APP_IMAGES#5.mp3" type="audio/ogg">
<source src="#APP_IMAGES#5.mp3" type="audio/mpeg">
Your browser does not support the audio element.
</audio>

</body>
</html>

Qaium's IT Demonstration

Search This Blog