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:
- You can’t control what you can’t measure
- Peopleware
- Incrementalism
- Iteration
- Repair costs increase
- Tradeoffs are non-linear
- Reuse is important
- Risk management provides insights
- Consistency trumps brillance + death march
- 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
Customized Query in Wordpress
September 18, 2007
-
<?php
-
$get_children = $wpdb->get_results('SELECT * FROM your category table WHERE category_parent = "The cat_ID of the parent that you want"');
-
foreach ($get_children as $child) {
-
}
-
?>
-
</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.
ZDebug - Oracle Forms Debugging Tool
September 11, 2007
Here is the link for ZDebug. This is useful for debugging Oracle Forms.
TKPROF Links
September 11, 2007
Here are the usefu links for TKPROF
Recent Comments