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'));
Saturday, July 25, 2020
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">
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
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>
Subscribe to:
Posts (Atom)
-
1. Make a Region with PL/SQL Dynamic Content type . ========== 2. Assign ID to the region using HTP.p ( <span id="TEST_ID...
-
Create Excel File From Classic Report in Oracle Apex Using Java Script 1. Upload File Download File 2. Copy Pest the Code <!DO...
