Valentine Nikitsky nikitsky
nikitsky
/ tooltip.css
Created
April 14, 2021 19:10
A simple Tooltip css: <span data-tooltip="Tooltip text">Main text</span>
This file contains 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
| [data-tooltip] { | |
| position: relative; | |
| z-index: 2; | |
| cursor: pointer; | |
| } | |
| /* Hide the tooltip content by default */ | |
| [data-tooltip]:before, | |
| [data-tooltip]:after { | |
| visibility: hidden; |
nikitsky
/ dashing_apex201js.json
Last active
March 13, 2021 19:41
Dashing.json to create Dash docset for Oracle APEX JavaScript API
This file contains 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
| { | |
| "name": "Oracle APEX 20.1 JavaScript API", | |
| "package": "apex201js", | |
| "index": "aexjs/index.html", | |
| "icon32x32": "apex-icon.png", | |
| "allowJS": true, | |
| "ExternalURL": "https://docs.oracle.com/en/database/oracle/application-express/20.1/apxjs/index.html", | |
| "selectors": { | |
| "body h1.page-title": [ | |
| { |
nikitsky
/ dashing_apex201api.json
Last active
March 13, 2021 19:07
Dashing.json to create Dash docset for Oracle APEX PL\SQL API
This file contains 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
| { | |
| "name": "Oracle APEX 20.1 PL\\SQL API", | |
| "package": "apex201api", | |
| "index": "buildapplications.html", | |
| "icon32x32": "apex-icon.png", | |
| "allowJS": true, | |
| "ExternalURL": "https://docs.oracle.com/en/database/oracle/application-express/20.1/", | |
| "selectors": { | |
| "article>header>ol.breadcrumb>li.active": [ | |
| { |
nikitsky
/ get_ldap_data.sql
Created
September 21, 2015 11:27
get list of Windows Active Directory users thought LDAP using ORACLE DBMS_LDAP
This file contains 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 | |
| retval PLS_INTEGER; | |
| my_session DBMS_LDAP.session; | |
| my_attrs DBMS_LDAP.string_collection; | |
| my_message DBMS_LDAP.message; | |
| my_entry DBMS_LDAP.message; | |
| entry_index PLS_INTEGER; | |
| my_dn VARCHAR2(256); | |
| my_attr_name VARCHAR2(256); | |
| my_ber_elmt DBMS_LDAP.ber_element; |
This file contains 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 regexp_substr('5,6,7', '[^'||','||',]+', 1, LEVEL) | |
| FROM dual | |
| CONNECT BY regexp_substr('5,6,7', '[^'||','||',]+', 1, LEVEL) IS NOT NULL |