Monthly Archives: April 2015

Introduction to Cloud Storage using Google Drive

Google Drive Intro

Google Drive is a Google Cloud Platform which can store folders & files in the internet.
Google Drive has its own UI on https://drive.google.com so that users can manage their files on the internet i.e upload, download, share, setup access permission, work with files etc.
As default google drive is free with 15 gb storage size quota per google account. if you want more then you have to pay for google drive for work.
There are others cloud drive platform similar to google drive like dropbox but google have many more platform besides drive such as gmail, google+, cloud storage, cloud database etc.
So that work with google drive can interactively connect from many google products.

There is a platform called ‘google cloud storage’. Both of them are storage on the cloud but the difference between google drive and google cloud storage is user can manage and work interactive with folders & files directly from google drive UI whereas google cloud storage mainly for storing files needed by an application such as game files, backup files, etc.

Google Drive as File Server

Google Drive can be alternative as your file server in cloud. Migrating on premise file server to Google Drive is a good option since you take advantage of Google’s own reliable and fast networking infrastructure.
Continue reading

Advertisements

Returning Recordset From Oracle Function Under Package Using PHP

Brief

This post shows example of returning recordset from oracle function. The oracle function is stored under Packages folder.
Oracle used version is 11g Express Edition.
This is a simple example. I have a ItemMaster table and then return its records by oracle function and view it on web page.

Example

ItemMaster Table Creation SQL:

CREATE TABLE "HR"."ITEMMASTER" 
   (	"ITEMCODE" VARCHAR2(15 BYTE), 
	"ITEMDESC" VARCHAR2(150 BYTE), 
	"ITEMGROUP" VARCHAR2(15 BYTE), 
	"ITEMTYPE" VARCHAR2(2 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;

I used default HR sample schema.

Create a package in oracle:

create or replace PACKAGE PCKG_MASTER AS 
FUNCTION LIST_ITEMMASTER RETURN SYS_REFCURSOR;
END PCKG_MASTER;

Continue reading