Table with pagination, sorting and search in a PL/SQL Dynamic Content

189 views Asked by At

i have a table that basically looks like this:

begin
htp.p('
<table id="example" class="table table-striped table-bordered" style="width:100%">
    <thead>
        <tr> 
            <th>ID</th> 
            <th>First Name</th> 
            <th>Last Name</th>
            <th>Email</th>
            <th>Country</th>
        </tr>
    </thead>
    <tbody>'); 

    for i in(select * from exampleTable)
    loop

        htp.p('
        <tr>
            <td>'||i.id||'</td>
            <td>'||i.first_Name||'</td>
            <td>'||i.last_name||'</td>
            <td>'||i.email||'</td>
            <td>'||i.Coubtry||'</td>
        </tr>');
    end loop;
    htp.p('
    <tbody>
</table>');
end;

is it possible to use the Apex's built in functions to do this (and how) or do I have to build my own functions. also is Bootstrap integrated with Apex (meaning I can use it without importing it) because I have found some solutions with Bootstrap that i can use after some tweaks of course. also is it possible to merge the rows where the country is the same into 1 row while leaving the other columns separated

0

There are 0 answers