You are here:

Oracle/Expert Profile

Elliot Mak

Canada

Available

Expertise

I can answer questions with regarding to Oracle DB (8i, 9i, 10g, 11g) installation, configuration, administration, Data Guard, SQL, and PL/SQL (Procedures, triggers, functions).

Experience in the area

I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.

Education/Credentials

Bachelor of Science in Management System

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
Maz	02/11/12	10	10	10	Thanks well spotted!
Ravindra SIngh	01/24/12	10	10	10
ritesh	12/03/11	10	10	10
Dee'Dee Wells	11/06/11	10	8	10	Thank you, that was very helpful
hafsa	10/08/11	10	10	10

Recent Answers from Elliot Mak

2012-02-03 Extra error messages while execution of trigger:

Good day Prashant To my best knowledge, if you are using it from SQLPLUS (or development tools), this is the way it is designed to do. If you have an application that calls, then it is up to your application

2012-01-20 Audit Trail using Triggers:

Good day Ravindra, Sorry for the late reply. I was on vacation after my initial reply. With regarding to triggers, unfortunately trigger must associate to an individual table. There is not really

2012-01-19 Audit Trail using Triggers:

Good day Ravindra There are other ways to perform audit trail on Oracle RDBMS. I am not too sure exactly the intention of the audit trail. I assume that you want to know who did what, and when. But

2011-12-02 confusion in views:

Hi Ritesh The reason why you got this error is because Oracle requires direct grant to the user. that means, the privilege of selecting scott.emp table must be grant to the user, and it cannot inherit

2011-12-01 confusion in views:

Good day Ritesh I recreated your scenario on my laptop. Here is what I have done. -- Script Start -- create user snow identified by snow; grant create session to snow; grant create table, create

Oracle

Answers by Expert:

Browse Answers: