Skip to content

Instantly share code, notes, and snippets.

create or replace
PROCEDURE zoekAdres (
postcodeIn IN VARCHAR2,
huisnummer IN NUMBER,
toevoeging IN VARCHAR2,
-- Out
id OUT NUMBER,
straat OUT VARCHAR2,
houseNumber OUT NUMBER,
addition OUT VARCHAR2,
-- Zet de server output aan
SET SERVEROUTPUT ON
-- Maak de landen tabel
CREATE TABLE Country
(
ID NUMBER PRIMARY KEY,
Code VARCHAR2(3) UNIQUE NOT NULL,
Name VARCHAR2(50) UNIQUE NOT NULL
);
create or replace
PROCEDURE importWinkel
IS
file UTL_FILE.FILE_TYPE;
counter INT := 0;
name VARCHAR2(128);
street VARCHAR2(128);
create or replace
PROCEDURE zoekWinkelsInProvincie (
provincie IN VARCHAR,
stores OUT SYS_REFCURSOR
)
IS
BEGIN
OPEN stores FOR
SELECT *
FROM winkel w
@yooouuri
yooouuri / Route.php
Created February 1, 2016 17:28
Routing class
<?php
class Route
{
private $routes = array();
public function init()
{
$match = $this->match();
$controller = '\\app\\Controllers\\' . $match['controller'];
package com.nielyouri.pluff.ui.activities;
import android.app.ProgressDialog;
import android.content.Intent;
import android.support.annotation.NonNull;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.TextUtils;
import android.util.Log;
import android.view.View;
<?php
namespace App\Http;
use Illuminate\Foundation\Http\Kernel as HttpKernel;
class Kernel extends HttpKernel
{
/**
* The application's global HTTP middleware stack.
/**
* @param $id
* @param int $page
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function category($id, $page = 1)
{
$maxItems = 9;
$skip = ($page - 1) * $maxItems;
package edu.fontys.stayconnected.ui.activities;
import android.content.DialogInterface;
import android.content.Intent;
import android.provider.Settings;
import android.support.v4.app.NotificationManagerCompat;
import android.support.v4.view.ViewPager;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
<?php
namespace App\Http\Controllers\admin;
use App\User;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Auth;
class UserController extends Controller