Trainings Links

Unix

• UNIX Essentials Featuring the Solaris 9 Operating System (SA-119)
  
• Shell Programming for System Programmers :: [SL-120] Source:Sun Microsystem
• Shell Programming for System Administrators (SA-245)
  
• Perl Programming
  

Java

• Fundamentals of the Java Programming Language (SL-110-SE6)
• Object-Oriented Analysis and Design Using UML (OO-226)
• Java Programming Language Workshop (SL-285)
• Developing Applications for the Java EE Platform (FJ-310-EE5)
• Web Component Development with Servlet and JSP Technologies (SL-314-EE5) (Optional)
• Business Component Development with Enterprise JavaBeans Technology (SL-351-EE5)
• Java Programming Language Workshop (SL-285)
• Architecting and Designing J2EE Applications (SL-425)
• J2EE Patterns (SL-500)

Where in the World are Oracle ACEs?

View Larger Map

Participating in Oracle Certified Database SQL Expert Beta Exam

As mentioned in my previous post, I participated in Oracle Certified Database SQL Expert Beta Exam. In the past weeks, Lauren Schneider, Jaffar and Jochen Van de Voorde have taken this exam.

The exam has 139 questions for 190 minutes. The areas covered both in 1Z1-047 and 1Z0-007 are easy for me because it was fresh to my memories all the things that I reviewed in preparation to the exam 1z0-007 Introduction to SQL which I have taken last August 27, 2007.

The new things that I studied are

• Performing Flashback Operation - This is really cool which allows you to trace back the previous values of the records in the table. Now, Windows is not the only one who got a Recycle bin, Oracle 10g database has it.
• External Tables
• Multitable INSERT(Unconditional, Conditional and Pivot)
• ROLLUP
• CUBE
• GROUPINGS
• WITH Clause
• Hierarchical Query
• Regular Expressions
• Advanced Queries(Correlated, Noncorrelated) - I’d been using this technique for the past years but not I have no idea that there is a term for this type of queries.

I posted a comment for this exam that they should provide a more deeper questions on Regular Expresions and Flashback operation to their exam. The questions for regular expression is too basic. For the Flashback operation, they need to cover other aspects of Flashback operations.

Oracle 10g Regular Expressions

This is a three-part tutorial in Oracle Forums.

Part 1
Part 2
Part 3

ZDebug - Oracle Forms Debugging Tool

Here is the link for ZDebug. This is useful for debugging Oracle Forms.

Oracle Forum Link

 Zdebug Homepage

TKPROF Links

Here are the usefu links for TKPROF

Oracle Documentation

PSOUG Information Page

Work and Preparing for Oracle Database SQL Expert Exam

Last month I filed a 1 week vacation to prepare for my Oracle Database SQL Expert exam. The original schedule is on August 27 - 31. But since my project has a deadline on completing the change request data conversion modules on August 31, I rescheduled it on Sept 10 - 14. It’s fine with me because the accredited Prometric testing site I called has no schedule at that period. Last week, I called them again and scheduled my exam on Sept 12.

Unfortunately, last Friday, my project is on Assembly Test period and logged a couple of defects. I need to work on weekends which makes my time to review shorter. The project lacks resources to work on the development and fixing tasks. As the project lead, I need to oversee the things to be done. One of my developer, didn’t come to work so I need to help in fixing the defects. I requested my manager for a resource to help use but there is no reply yet. I worked whole day of Saturday till 5am next day. I slept for 7 hours and then went back to work again. My manager replied and informed me the name of the developer who can help. I called this developer and fortunately she is free to help us.

I completed fixing the two defects and have it for retest around 8pm. I sent my status report and then time for me to review. I hope I can focus now in my preparation for Oracle Database SQL Expert Exam.

My Oracle 1Z0-007 Result

I took the exam for 1Z0-007 Introduction to SQL yesterday (August 27). The some questions are very easy to answer as long as you know to concepts of Oracle SQL 9i. Some questions are tricky so I need to mark the questions to revisit after I completed answer all of the questions. All in all, I marked 17 questions out of 52 for review. To think the passing percentage is 71%, that means I need to have at least 37 correct answers. With 17 questions mark for review that means I only answered 35 questions correctly so I need to review the 17 marked questions so that at least I answered 2 questions correctly to passed.

In the end, after revisiting the 17 questions, I passed the exam with 47 correct answers out of 52 questions. That means I got 5 incorrect answers. My percentage is 90.4% for 1Z0-007. Now, my next step is preparation is for 1Z0-147 PL/SQL to achieve the Oracle Certified Associate.

Restrict User From Entering More Than 100 Records

You can write following code at WHEN-CREATE-RECORD trigger of that block to restrict user entering upto 100 records.

IF to_number(:system.cursor_record) > 99 THEN
raise form_trigger_failure;
END IF;

Generating Spool File Layout

Use this simple SQL script–lay.sql–to generate the layout for the spooled file. Run the script before spooling the table to get the layout

Link

« Previous Page — Next Page »