Archive for March, 2012

Things I Learned in February

March 1, 2012 Leave a comment


  1. Demo of DataMasker
  2. Oracle’s DBMS_APPLICATION_INFO Package
  3. select * from user_procedures where object_type in (‘PROCEDURE’, ‘FUNCTION’)
    1. This table/view also contains triggers, types, and packages.
  4. Learned how to make Chicken Flautas.  Easy and Tasty.
  5. Made my own Calzones.
  6. DBMS_XMLGEN Package
    1. It seems I cannot grant permissions to other users on Index Organized Tables.  (select * from user_tables where iot_name is null)
    2. It’s not Chicago Department Of Health, It’s Chicago Department of Public Health
  8. Oracle Types: “When you call the default constructor to fill in all attribute values, you must supply a parameter for every attribute; unlike constants and variables, attributes cannot have default values.”
  10. Hidden feature of DataBee to allow Table-to-Table rules to have an additional WHERE clause.  Clever.
  11. Ticket to Ride for the iPhone is awesome.
    1. Made Challah French Toast… mmmm
  12. Been learning about Sender Policy Framework (SPF) records and how mail servers check/treat them.
    1. Google Apps/GMail is a lot pickier than Yahoo.
    2. DNS Text Record (TXT) record specifies the SPF details.
  13. Learned a bit about the limitations of science with regard to Cosmology and Physics.  Learned the Big Bang theory is based on some pretty flawed theories and reasoning.
  14. Got schooled on the specifics of simple vs complex variable parsing within strings with PHP. I thought I knew it all but it turns out I did not.
    1. Valid: “Print $this->variable works”
    2. Valid: “Print $ar[0] and $ar[index] works”
    3. Invalid “Quoted $ar[‘index’] does not work” (Parse Error)
    4. I still prefer to wrap {} around any variable inside a double quoted string though.
    5. Discovered register_argc_argv is hardcoded to On for the CLI SAPI. Even if you specify Off, it’s On.
  15. Oracle Analytic Functions: RANK, DENSE_RANK, FIRST and LAST.  – Courtesy of ryocum
    1. Keyword KEEP also involved here.
    2. LAG and LEAD Analytic Functions
  16. Learned how our Sales people use the demo system, what they care about and what they don’t.
  17. DataBee/DataMasker work MUCH better when closest to the data center. Going over my VPN connection was causing extracts/imports to be 4x slower.
  18. Made a tasty chicken alfredo dish with homemade breadsticks.
  19. Made pound cake for the first time.
  20. Learned how to find missing values in a sequence using SQL. Used a clever self join technique to identify the ranges.
  21. Check permissions (grants) that exist for a table use select * from all_tab_privs where table_name = X;
  22. Unix iotop – Shows top IO consumers.
  23. Learned that Oracle now supports Perl regexes.  Also brushed up on Oracle’s four REGEXP functions.
    1. select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null;
    2. sqlnet.ora is a client side configuration file that will let you do all kinds of tracing in the client library
  25. Learned how to make mini-cheesecake (cream cheese + sugar + eggs).
    1. Learned the secret to great fried rice is to use 1-2 day old rice. It’s dryer and separates better.
  26. Eiffel Tower is 1,063 feet tall, designed by Gustave Eiffel, built as the entrance arch to the 1889 World’s Fair.
  29. Oracle Streams