Skip to content

Instantly share code, notes, and snippets.

View S-Koell's full-sized avatar
😎

Sebastian Köll S-Koell

😎
0 followers · 5 following
View GitHub Profile
@S-Koell
S-Koell / APEX_Connect_2022.md
Last active January 30, 2022 19:41

Regeln

  • Titel max 90 Zeichen
  • Text 500-1800 Zeichen

git entmystifiziert - Basics anschaulich erklärt

-- vortrag lasse ich weg

Ein System kann man am besten benutzen, wenn man ein Verständnis dafür hat, wie es funktioniert.

@S-Koell
S-Koell / vscode_tasks.json
Last active March 16, 2020 08:51 — forked from mortenbra/vscode_tasks.json
VS Code task runner configuration for PL/SQL
{
"version": "2.0.0",
"tasks": [{
"label": "Compile PLSQL",
"type": "shell",
"command": "echo 'set termout off; \nset feedback off; \nSET SQLFORMAT LOADER; \n@${file}; \nselect lower(attribute) || '' '' || MESSAGE_NUMBER || '' '' || line || ''/'' || position || '' '' || case when type = ''PACKAGE BODY'' then ''PACKAGES/'' else type || ''S/'' end ||upper(name) || case when type = ''PACKAGE'' then ''.pks'' when type = ''PACKAGE BODY'' then ''.pkb'' when type = ''FUNCTION'' then ''.pls'' when type = ''PROCEDURE'' then ''.pls'' else ''.sql'' end || '' '' || replace(text, chr(10), '' '') as user_errors from user_errors where attribute in (''ERROR'', ''WARNING'') order by type, name, line, position;' | sql ${config:plsql-language.connection.activeInfos}",
"group": {
"kind": "build",
"isDefault": true
},
@S-Koell
S-Koell / _cypress_for_APEX_stuff
Last active March 23, 2024 17:01
cypress.io stuff to work with Oracle APEX
GISTs for CYPRESS.io to work better with Oracle APEX
@S-Koell
S-Koell / ora_folder_structure.md
Last active March 5, 2020 10:24
Oracle db repo folder structure

Folder structure

For this repository we have the following folder structure (with descriptions in parentheses):

  • Repository (Parent Folder. Is the root of the versioning system)
    • Tools (Tool specific settings/configs/help/etc)
      • VSCode
      • git
      • SQLcl
  • [ ... ]
@S-Koell
S-Koell / exportDDL.js
Last active April 30, 2024 16:33 — forked from DominiqueComte/exportDDL.sql
export an Oracle schema DDL with SQLcl
var CopyOption = Java.type("java.nio.file.StandardCopyOption");
// put all files here >>>
var rootPathString = 'C:/Users/dump';
var pathString;
//Create Root Folder for instance.
//var instance = util.executeReturnOneCol('SELECT sys_context(\'USERENV\',\'INSTANCE_NAME\') AS Instance FROM dual');
//rootPathString = rootPathString + "/" + instance;