How to create function return table or cursor in oracle

database

In this article, we research how to create a function return a table or a cursor in oracle. We will have some way to do this. Example: we have one

Wednesday, July 26th, 2017

Create group user class by using object oriented plsql

database

We often use object oriented programming in java or donet. In this article, we will create class by using object oriented plsql. We have example: one Group object has many

Thursday, June 1st, 2017

Functions encrypt decrypt and checksum oracle

database

In this article, we will have function create xml file with our key and we have to checksum oracle for this xml file. At first, we need to research some

Tuesday, May 30th, 2017

Create stored procedure pl/sql in oracle

database

We will practice to create stored procedure pl sql in oracle to manage create/update/delete or select data in database tier. We can create function create/update/delete or select data in application

Monday, May 29th, 2017

Check tablespace usage percent in oracle

database

If you are database administrator, sometime you need check tablespace usage percent in oracle In this article,  we have some script to check size of tablespace in oracle and crease

Thursday, May 25th, 2017

Multiple join sql statement examples

database

Sometime, we need query which result between table A and table B then we will use many way join sql statement In this example: we have two table_a and table_b

Wednesday, May 24th, 2017

Some ways to check bad sql in oracle

database

Sometime, we have some systems use oracle database and these system query data very slowly, we need dba check bad sql in oracle if any. After dba check bad sql

Monday, May 22nd, 2017

Some ways to update table oracle sql

database

Sometime, we need to update some table in database and we have some ways to update table oracle sql, update directly or from other tables. Example: we have two tables,

Wednesday, April 19th, 2017

Overview about permissions Oracle basic for Developer Database

database

In this Oracle, we will summary about some privileges/permissions Oracle basic before we want manage database. We need to know about as create user (schema), grant privilege login, create object

Wednesday, August 10th, 2016

MessageDigest-Salt Hash MD5 in Java and Oracle

database

We have function generate password use MessageDigest class and algorithm Salt Hash MD5 in java. We want to use this function in Oracle, we have two ways: compile java directly

Friday, July 1st, 2016