frankiechapson

Pinned Repositories

CRON-Next-Date
Oracle PL/SQL solution to get next date using CRON syntax
4 1 50
CryptoData
Oracle SQL and PL/SQL solution to hide sensitive data
Language:SQLPL3 1 04
CSV-Collection
Oracle PL/SQL solutions to manage delimited (CSV) data
Language:PLSQL4 2 04
Data-History-Manager-DHM
Oracle SQL and PL/SQL solution to log data changes
Language:PLSQL0 1 01
Differences
Oracle PL/SQL solution to compare data
Language:PLSQL5 1 00
DOCX_REPORT
Oracle PL/SQL solution to generate docx reports
Language:PLSQL3 1 03
EFC
Extract File/Folder Changes EFC
Language:Java1 1 00
ETL
General ETL solution for Oracle
Language:PLSQL0 2 01
Export-and-Import-LOB-values
Oracle PL/SQL solution to move LOB data with text files
Language:SQLPL2 1 04
FIO
Oracle SQL and PL/SQL solution to upload and write out interface files
Language:PLSQL2 1 01

frankiechapson's Repositories

frankiechapson/CRON-Next-Date
Oracle PL/SQL solution to get next date using CRON syntax
4 1 50
frankiechapson/DOCX_REPORT
Oracle PL/SQL solution to generate docx reports
Language:PLSQL3 1 03
frankiechapson/FIO
Oracle SQL and PL/SQL solution to upload and write out interface files
Language:PLSQL2 1 01
frankiechapson/Year-Planner-Calendar
Oracle APEX Plugin
Language:PLSQL2 1 23
frankiechapson/CommPass
Command Passer. Drag and drop commands wherever you need them
Language:Pascal1 2 0
frankiechapson/EVALUATE_EXPRESSION
An Oracle PL/SQL solution to get the value of an expression independently of its type
Language:PLSQL1 1 01
frankiechapson/EXPORT_DATA
Creates import scripts. For any special type of data (if you implement them)
Language:SQLPL1 2 0
frankiechapson/LCL
Oracle SQL and PL/SQL solution to controll logins
Language:PLSQL1 2 0
frankiechapson/Login
Oracle SQL and PL/SQL solution to manage logins
Language:PLSQL1 2 0
frankiechapson/MyEnv
Set and get my environment variables
Language:SQLPL1 2 0
frankiechapson/Reference-Resolver
Oracle SQL, PL/SQL solution to resolve Table References
Language:PLSQL1 1 0
frankiechapson/RIGHTS
How to manage users/user groups and their rights to the menus/functions
Language:PLSQL1 2 0
frankiechapson/T_DATA_RECORD
Oracle PL/SQL solution to handle tables and rows by general way
Language:PLSQL1 1 01
frankiechapson/TO_CHAR2
String normalizing function
Language:PLSQL1 1 0
frankiechapson/TO_STRING
Creates a string expression from a varchar2 value
Language:PLSQL1 2 0
frankiechapson/ToDos
Oracle SQL and PL/SQL solution to manage ToDo lists
Language:PLSQL1 1 0
frankiechapson/Validity2
How to manage data validity in case of joined tables
1 2 0
frankiechapson/VERSIONS
A method to check and to follow the version of Objects in the Schema
Language:PLSQL1 1 0
frankiechapson/VFD_VTD
Oracle SQL and PL/SQL solution for managing data changes in time
Language:PLSQL1 1 01
frankiechapson/Data-Dictionary-manager
Oracle SQL and PL/SQL solution to manage General Data (code/ID) Dictionaries
Language:PLSQL0 1 01
frankiechapson/Data-History-Manager-DHM
Oracle SQL and PL/SQL solution to log data changes
Language:PLSQL0 1 01
frankiechapson/ETL
General ETL solution for Oracle
Language:PLSQL0 2 01
frankiechapson/Aggregate-periods
How to compress continuous intervals
2 0
frankiechapson/DataSets
Tool to use query results as normal matrix data set
2 0
frankiechapson/DST
These functions returns with the start or end date and time of the DST in the specified year
Language:PLpgSQL2 0
frankiechapson/Emails
Manage eMails
Language:PLSQL2 0
frankiechapson/Exchange
Exchange
2 0
frankiechapson/SINGLE_RECORD_VIEW
Oracle PL/SQL function to display a single record
Language:PLSQL1 0
frankiechapson/Source_Code_Scan
Scan the pl/sql source code and manipulate it
2 0
frankiechapson/TimeMachine
Table data time machine in Oracle
Language:PLSQL1 0