equal
deleted
inserted
replaced
39 begin |
39 begin |
40 null; |
40 null; |
41 end; |
41 end; |
42 / |
42 / |
43 |
43 |
|
44 Using variables:: |
|
45 |
|
46 declare |
|
47 x number; |
|
48 begin |
|
49 select 1 into x from dual; |
|
50 end; |
|
51 / |
|
52 |
44 Database info. |
53 Database info. |
45 ============== |
54 ============== |
46 |
55 |
47 List of users:: |
56 List of users:: |
48 |
57 |
157 http://daust.blogspot.co.il/2006/01/xe-changing-default-http-port.html |
166 http://daust.blogspot.co.il/2006/01/xe-changing-default-http-port.html |
158 XE: Changing the default http port. |
167 XE: Changing the default http port. |
159 https://erikwramner.wordpress.com/2014/03/23/stop-oracle-xe-from-listening-on-port-8080/ |
168 https://erikwramner.wordpress.com/2014/03/23/stop-oracle-xe-from-listening-on-port-8080/ |
160 Stop Oracle XE from listening on port 8080. |
169 Stop Oracle XE from listening on port 8080. |
161 |
170 |
|
171 Creating user |
|
172 ------------- |
|
173 |
|
174 From ``system`` account:: |
|
175 |
|
176 create user BOB identified by 123456; |
|
177 alter user BOB account unlock; |
|
178 alter user BOB default tablespace USERS; |
|
179 alter user BOB temporary tablespace TEMP; |
|
180 alter user BOB quota 100M on USERS; |
|
181 grant CREATE SESSION, ALTER SESSION to BOB; |
|
182 grant CREATE PROCEDURE, CREATE TRIGGER to BOB; |
|
183 grant CREATE TABLE, CREATE SEQUENCE, CREATE VIEW, CREATE SYNONYM to BOB; |
|
184 |
162 Profiling. |
185 Profiling. |
163 ========== |
186 ========== |
164 |
187 |
165 Timing info about last queries:: |
188 Timing info about last queries:: |
166 |
189 |