Video Link : https://youtu.be/M_6xK130_A8
Table
CREATE TABLE PROFILE(
ID NUMBER,
NAME VARCHAR2(50),
YOUTUBE_LINK VARCHAR2(100),
FACEBOOK_LINK VARCHAR2(100),
TWITTER_LINK VARCHAR2(100),
IMAGE BLOB);
Query
select ID,
NAME NAME,
YOUTUBE_LINK,
FACEBOOK_LINK,
TWITTER_LINK,
decode(nvl(dbms_lob.getlength(IMAGE),0),0,null,
'<img class="fancybox" alt="'||apex_escape.html_attribute(ID)||'" title="'||apex_escape.html_attribute(ID)
||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '
||'src="'||apex_util.get_blob_file_src('P17_IMAGE',ROWID)||'" height="75" width="75" />
') IMAGE
from PROFILE
HTML
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.8.1/css/all.css">
<div class="image-area">
<div class="img-wrapper">
#IMAGE#
<h2>#NAME#</h2>
<ul>
<li><a href=#GIT#><i class="fab fa-github"></i></a></li>
<li><a href=#INS#><i class="fab fa-instagram"></i></a></li>
<li><a href=#TWITTER_LINK#><i class="fab fa-twitter"></i></a></li>
<li><a href=#YOUTUBE_LINK#><i class="fab fa-youtube"></i></a></li>
<li><a href=#FACEBOOK_LINK#><i class="fab fa-facebook"></i></a></li>
<li><a href=#INS#><i class="fab fa-instagram"></i></a></li>
<li><a href=#TWITTER_LINK#><i class="fab fa-twitter"></i></a></li>
<li><a href=#YOUTUBE_LINK#><i class="fab fa-youtube"></i></a></li>
<li><a href=#FACEBOOK_LINK#><i class="fab fa-facebook"></i></a></li>
</ul>
</div>
</div>
I Apply It and It Is Wonder full .. But I Face Issue With Pagination
ReplyDeleteIt Show One Row Only
Please I Need YR Help