Pkjubaer
Pkjubaer
/ Image restriction oracle apex
Created
February 15, 2019 11:50
Image restriction oracle apex
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function ValidateFileUpload() { | |
| var fuData = document.getElementById('P_IMAGE1'); | |
| var FileUploadPath = fuData.value; | |
| //To check if user upload any file | |
| if (FileUploadPath == '') { | |
| alert("Please upload an image"); | |
| } else { | |
| var Extension = FileUploadPath.substring( |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT distinct TZ_OFFSET(tzname) || ' ' || tzname TIME_ZONE | |
| FROM V$TIMEZONE_NAMES | |
| order by 1 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function myFunctionp() { | |
| document.getElementById("P392_SR_TREE").placeholder = "Search"; | |
| } | |
| /*jquery*/ | |
| $('#P370_SEARCH').attr('placeholder', 'Search'); |
Pkjubaer
/ Tree region hover in oracle apex
Created
February 11, 2019 05:32
Tree region hover in oracle apex
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| .t-Region .a-TreeView-node--topLevel .a-TreeView-row.is-hover{ background-color:#E0FAFE !important; } | |
| .t-Region .a-TreeView-node--topLevel .a-TreeView-content.is-hover{ color: #056abf !important; font-weight: 700; } | |
| .t-Region .a-TreeView-node--topLevel .a-TreeView-row.is-selected{ background-color: #E0FAFE !important; } | |
| .t-Region .a-TreeView-node--topLevel .a-TreeView-content.is-selected{ color: #056abf !important; font-weight: 700;} |
Pkjubaer
/ css on header and level in oracle apex
Last active
February 11, 2019 05:33
css on header and level in oracle apex
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*css on header and level*/ | |
| .t-Report-cell[headers="DEL"]{ | |
| width: 20px; | |
| } | |
| /*radio_group*/ | |
| .t-Form-inputContainer .checkbox_group input+label, .t-Form-inputContainer .radio_group input+label { | |
| padding-right: 0px; | |
| } | |
| /*Customize header*/ | |
| .t-Region-headerItems{ |
Pkjubaer
/ Restriction image formate and image length in oracle apex
Created
February 9, 2019 09:50
Restriction image formate and image length in oracle apex
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*Restriction image formate and image length such as jpg,png,jpeg and image length like kb,mb*/ | |
| function ValidateFileUpload() { | |
| var fuData = document.getElementById('P58_PIC'); | |
| var FileUploadPath = fuData.value; | |
| //To check if user upload any file | |
| if (FileUploadPath == '') { | |
| alert("Please upload an image"); | |
| } else { |
Pkjubaer
/ Interactive report common css
Last active
March 25, 2019 11:35
Interactive report common css
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| .a-IRR-table td { | |
| padding: 5px; | |
| } | |
| .a-IRR-table tr td{ | |
| border-color: #ccc5c5 !important; | |
| } | |
| .a-IRR-paginationWrap--bottom { | |
| border-top: 1px solid #ccc5c5; | |
| } |
Pkjubaer
/ Insert value from multiple select list
Created
February 7, 2019 06:09
Insert value from multiple select list
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DECLARE | |
| l_selected APEX_APPLICATION_GLOBAL.VC_ARR2; | |
| BEGIN | |
| -- | |
| -- Convert the colon separated string of values into | |
| -- a PL/SQL array | |
| l_selected := APEX_UTIL.STRING_TO_TABLE(:P1_DEPTNO); | |
| -- |
Pkjubaer
/ Nested Report Multiple Value Pass
Last active
January 31, 2019 08:16
Nested Report Multiple Value Pass
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| '<a href="javascript: void(0)" class="NR"><span><b>'||b.PROD_CATEGORY||'</b></span><span class="PROD_CAT" style="display:none">'||a.PROD_CAT||'</span><span class="PROD_GROUP" style="display:none">'|| a.PROD_GROUP ||'</span></a>' end | |
| ---- | |
| after creating link in report --> create dynamic action for pretius plugin report --> | |
| 1. Action event > click | |
| 2.Selection Type > jQuery selector | |
| 3.jQuery Selector > Class name with (.) sign which is created in link as .NR (This class name has already created in url link) | |
| 4.Event Scope > Dynamic | |
| 5.Static Container (jQuery Selector) > body |
Pkjubaer
/ PLSQL Dynamic Content Highlight
Created
January 31, 2019 05:51
PLSQL Dynamic Content Highlight
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #css tr:hover { background-color: #ffa; } | |
| table { overflow: hidden; } | |
| #css td, th { position: relative; } | |
| #css td:hover::after, | |
| #css th:hover::after { | |
| content: ""; | |
| position: absolute; | |
| background-color: #ffa; | |
| left: 0; | |
| top: -5000px; |