--- a/oracle.rst	Sat Mar 04 23:23:47 2017 +0200
+++ b/oracle.rst	Sun Mar 05 21:20:37 2017 +0200
@@ -41,6 +41,15 @@
   end;
   /
 
+Using variables::
+
+  declare
+    x number;
+  begin
+    select 1 into x from dual;
+  end;
+  /
+
 Database info.
 ==============
 
@@ -159,6 +168,20 @@
 https://erikwramner.wordpress.com/2014/03/23/stop-oracle-xe-from-listening-on-port-8080/
   Stop Oracle XE from listening on port 8080.
 
+Creating user
+-------------
+
+From ``system`` account::
+
+  create user BOB identified by 123456;
+  alter user BOB account unlock;
+  alter user BOB default tablespace USERS;
+  alter user BOB temporary tablespace TEMP;
+  alter user BOB quota 100M on USERS;
+  grant CREATE SESSION, ALTER SESSION to BOB;
+  grant CREATE PROCEDURE, CREATE TRIGGER to BOB;
+  grant CREATE TABLE, CREATE SEQUENCE, CREATE VIEW, CREATE SYNONYM to BOB;
+
 Profiling.
 ==========