Skip to content

Instantly share code, notes, and snippets.

CREATE OR REPLACE
PACKAGE BODY SPSYSTEM AS
procedure SP_SPSYSTEM_DROP_ALL_TABLE(cursor_ out sys_refcursor) AS
BEGIN
FOR i IN (SELECT * FROM tabs) LOOP
EXECUTE IMMEDIATE ('DROP TABLE ' || i.table_name || ' CASCADE CONSTRAINS');
END LOOP;
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
useradd -u 54321 -g oinstall -G dba,oper -m -s binbash oracle
passwd oracle
1. Download maven: https://maven.apache.org/download.cgi
2. Download ojdbc7.jar: http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html
3. Open CMD: /path/to/mvn install:install-file -Dfile=Path/to/your/ojdbc7.jar -DgroupId=com.oracle -DartifactId=ojdbc7 -Dversion=12.1.0 -Dpackaging=jar
These install instructions are adapted from Me and My Ubuntu blog.
1. Download VirtualBox
Download the VirtualBox application for your host machine type from the virtual box download site.
2. Install VirtualBox
Doubleclick on the downloaded installer and follow the instructions.
3. Download Ubuntu
Download Ubuntu Desktop Edition (14.04 64 bit version). Note the directory where you downloaded it.
var _ = require("lodash");
var path = require("path");
var env = process.env.NODE_ENV || "development";
var debug = ["development", "test"].indexOf(env) !== -1;
var defaults = {
cache: debug,
debug: debug,
@1242035
1242035 / queue-main.service
Created September 30, 2017 13:29 — forked from p34eu/queue-main.service
Laravel queue worker using systemd
# Laravel queue worker using systemd
# ----------------------------------
#
# /lib/systemd/system/queue-main.service
#
# run this command to enable service:
# systemctl enable queue-main.service
[Unit]
Description=Laravel queue worker
@1242035
1242035 / laravel-queue.service
Created September 30, 2017 13:28 — forked from thomasjsn/laravel-queue.service
Laravel queue worker using systemd.
# Laravel queue worker using systemd
# ----------------------------------
#
# /lib/systemd/system/queue.service
#
# run this command to enable service:
# systemctl enable queue.service
[Unit]
Description=Laravel queue worker
@1242035
1242035 / tinymce-4-email-plugin.js
Created August 30, 2017 04:34 — forked from Melros/tinymce-4-email-plugin.js
This plugin will insert a mailto: link by providing an email address within tinymce 4.
/*
1. Create a folder named "email" within "tinymce/plugins".
2. Create a file called "plugin.min.js" within the folder.
2. Paste the below code inside "tinymce/plugins/email/plugin.min.js"
3. Extend your tiny.init like:
tinymce.init({
plugins: "email",
toolbar: "email"
echo fs.inotify.max_user_watches=524288 | sudo tee -a /etc/sysctl.conf && sudo sysctl -p
https://github.com/paulmillr/chokidar/issues/294
https://stackoverflow.com/questions/16748737/grunt-watch-error-waiting-fatal-error-watch-enospc
@1242035
1242035 / laravel-ums.markdown
Created August 18, 2017 09:35 — forked from anchetaWern/laravel-ums.markdown
Building a User Management System in Laravel

There's no shortage of good resources for learning laravel. So instead of the usual introductory tutorial were just gonna learn Laravel by building a project from scratch and that's gonna be a User Management System.

I don't know if my definition of a User Management System is correct but here's my idea of what's it's capable of doing:

  • Register Roles
  • Register Users
  • Update Users