{"repo":"andorei/atop-plsql","free":true,"listed":false,"github":"https://github.com/andorei/atop-plsql","clone":"git clone https://github.com/andorei/atop-plsql.git","description":"PL/SQL utilities that make it easier to develop routine solutions in Oracle DBMS.","language":"PLSQL","stars":10,"topics":["cdc","change-data-capture","database","ldap","oracle","oracle-11g","plsql","plsql-logging","sheduler","utility-library"],"license":"MIT","category":"databases-storage","readme_excerpt":"atop-plsql PL/SQL utilities that make it easier to develop routine solutions in Oracle DBMS. atop-plsql is a collection of types, tables, PL/SQL packages and some other schema objects that has been used as a basis for developing custom solutions on Oracle 11g databases. atop-plsql provides: at env package specification (there is no package body) with constants to set configuration parameters used by other atop-plsql utilities. You are expected to modify constants in at env specification to suit your needs. Few types used by atop-plsql itself, including (nested) table of varchar2(4000), table of number, table of date and PL/SQL associative arrays in at type package, as well as functions to convert between these types. Few exceptions used by atop-plsql itself, including assertion error , invalid argument and some others defined in at exc package, as well as procedures to test a given condition that raise exceptions when failed. Utility routines to split varchar2 strings into elements, to join elements into varchar2 string, to zip blob, associative array of varchar2's or external file (available through Oracle directory object); see package at util . File utilities in at file package to create, write to, read from and rename external files using default encoding and default directory objects as defined in at env package specification. Pipeline functions that read .csv file (either external or blob/clob) and return its lines row by row; see csv table functions in package at file ","default_branch":null,"files":null,"tree":[],"storefront":"/r/andorei","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/andorei/atop-plsql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}