Zhengshuai PENG

A Small Developer

oracle_db

ยป oracle_db

Articles by category: oracle_db


others linux clojure cpp java leetcode cs-fundamental algorithm regex data_structure design_pattern network web spring python mysql sword_to_offer git mac elk
2016
02 Jul 2016

[Oracle Database] Oracle 11g xe tutorial 7: PL/SQL Advance

Oracle 11g xe Tutorial 7. PL/SQL Cursor, Procedure, Function, Trigger I.Cursor Because DML statement in PL/SQL just allow return one...

01 Jul 2016

[Oracle Database] Oracle 11g xe tutorial 6: PL/SQL Fundamental

Oracle 11g xe Tutorial 6. PL/SQL Grammar I. Block Structure DECLARE Declaration BEGIN Executable code EXCEPTION Exceptional handler END; II....

30 Jun 2016

[Oracle Database] Oracle 11g xe tutorial 5: How to design a database and normalization

Oracle 11g xe Tutorial 5 I. How to design a database & Database Normalization Database normalization, or simply normalization, is...

29 Jun 2016

[Oracle Database] Oracle 11g xe tutorial 4: Table, Create, Constraint, Drop, Alter, Index, View

Oracle 11g xe Tutorial 4 I. DDL Statement Tutorial DDL: Data Definition Language A. Create Table To create a table:...

28 Jun 2016

[Oracle Database] Oracle 11g xe tutorial 3: Export/Import, Insert, Update, Delete, Transaction Control

Oracle 11g xe Tutorial 3 I. DML Statement Tutorial DML: Data Manipulation Language Backup user and new user Export Open...

27 Jun 2016

[Oracle Database] Oracle 11g xe tutorial 2: Subquery, Join, View

Oracle 11g xe Tutorial 2 I.Subquery 1.Subquery Select statement inside a select statement, the result of inner select statement just...

26 Jun 2016

[Oracle Database] Oracle 11g xe tutorial 1: Select query

Oracle 11g xe Tutorial 1 I.Default Oracle Database Schema 1.HR schema In oracle 11g xe, there is a default db...