Network Tweaking Links

September 27, 2007

Free Software Links

September 27, 2007

Software Best Practices Conference

September 23, 2007

I want to share ideas from Youdon. His presentation for Software Best Practices Conference is about Ten Most Important Ideas in Software Engineering.  Here is what he talks about:

  1. You can’t control what you can’t measure
  2. Peopleware
  3. Incrementalism
  4. Iteration
  5. Repair costs increase
  6. Tradeoffs are non-linear
  7. Reuse is important
  8. Risk management provides insights
  9. Consistency trumps brillance + death march
  10. Don’t reinvent the wheel

You can download the pdf here.

Displaying Posts Using a Custom Select Query

September 22, 2007

The practical example, outlined below, demonstrates a process of selecting all posts with a particular Custom Field value stored, and displaying them in a Page based on a Page Template.

http://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query

Where in the World are Oracle ACEs?

September 19, 2007


View Larger Map

Customized Query in Wordpress

September 18, 2007

HTML:
  1. <?php
  2. $get_children = $wpdb->get_results('SELECT * FROM your category table WHERE category_parent = "The cat_ID of the parent that you want"');
  3. foreach ($get_children as $child) {
  4. echo '<li><a href="./?cat='.$child->cat_ID.'" title="View all posts filed under '.$child->cat_name.'">'.$child->cat_name.'</a></li>';
  5. }
  6. ?>
  7. </ul>

Participating in Oracle Certified Database SQL Expert Beta Exam

September 13, 2007

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

September 11, 2007

This is a three-part tutorial in Oracle Forums.

Part 1
Part 2
Part 3

ZDebug - Oracle Forms Debugging Tool

September 11, 2007

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

Oracle Forum Link

 Zdebug Homepage

TKPROF Links

September 11, 2007

Here are the usefu links for TKPROF

Oracle Documentation

PSOUG Information Page

Next Page »