October 2016 - Learning Database by Example

Implementation Of DML Basic Function (Built In Function) On Oracle Database

October 30, 2016

Function is a special syntax in DML (Data Manipulation Language) queries to perform data processing in accordance with user needs. There are...

Basic User Role Management Example on Oracle Database

October 25, 2016

On previous post explained that before user able to manage objects, user must possessed some privileges. Minimum privileges for a user are ...

Basic User Privilege Management Example On Oracle Database

October 23, 2016

In case we will create user schemes namely MI123, Tamu1 and Tamu2. User MI123 have two tables namely T1 and T2. Here are some examples for m...

Subscribe to: Posts ( Atom )