Meet The Author: Steve O'Hearn

Author Steve O'Hearn discusses his book, "OCA Oracle Database SQL Certified Expert Exam Guide".

Steve O'Hearn has been an Oracle Certified Application Developer since 1999. He has designed databases for 23 years for clients such as the U.S. Army, U.S. Navy, the FAA, the World Bank, NASA, and others. He has served as a Chief Technology Officer, a consultant, and Instructor, and is the author of several computer books, including the "Oracle OCP Developer PL/SQL Program Units Exam Guide" and "OCA Oracle Database SQL Certified Expert Exam Guide" from Oracle Press.

Comments:

Great Book Steve, not sure I could have put the time in to the get the SQL OCE without it and I've probably would have needed a retake without it. Some of the things learned have really helped me at times.

.... And apologies for getting all 6 of your posts promoting this on the oracle certification forum deleted .... I had asked for one to be retained .... but the Alpha Sagittarius moderator who superbly cleans spam like dragons flame thread on Pern took no prisioners!

Posted by bigdelboy on January 09, 2013 at 01:14 PM PST #

p308 - Q9: "There is no HAVING clause in an INSERT statement".
Well, that's at best ambiguous and misleading; at worst not correct:

HR@XE> CREATE TABLE X(X NUMBER);

Table created.

HR@XE> INSERT INTO X (SELECT MAX(SALARY) FROM EMPLOYEES GROUP BY DEPARTMENT_ID HAVING MAX(SALARY) > 0);

12 rows created.

It is very much not the case that an INSERT cannot use HAVING.
I very much hope I don't encounter such deathtraps such as these in the exam. All possible answers given should be unambiguously true or not true.

Posted by Jason on January 29, 2013 at 04:20 PM PST #

Hi Jason,
If you have a question about this item, feel free to post it on one of our OTN forums http://bit.ly/MCuiCP.

Regards,
Brandye Barrington

Posted by Brandye Barrington on January 30, 2013 at 09:27 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Official blog of the Oracle Certification Program

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
4
5
6
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today