Working Notes

"It's the first responsibility of every citizen to question authority" - Benjamin Franklin or to be more succinct "Think for your self and question authority." - Timothy Leary What is a 'Best Practice'? A best practice is not a standard, nor is it a policy. It's a specific activity, performed performed under specific circumstances which will presumably result in a favorable outcome. A best practice is well documented, it's well researched and it's is well documented. Best practice documentation is not only on the execution of the practice itself, but also on the researched alternatives with rational as to why these practices were not considered the 'best'. A best practice is not a notion, theory, or whim. It is not a half-baked idea of something that SHOULD be. A best practice is definitely NOT a shield to prevent others from exploring other means of accomplishing the same task. The previous two paragraphs are very dire...

Patrick Cimolini SkillBuilders, Inc SWOT -- Strength, Weakness, Opportunities, Threats Inside the box development declarative sql or pl/sql Fast delivers more than CRUD operations relies on Oracle testing Outside the box development Programatic results that can't be achieved declaratively Advanced: PL/SQL, html, CSS and javascript increased time,cost,risk Apex Strengths Rapid Application Development  Pages data loading charts trees Components web services security Declarative environment wizards do 80% of work 20% customizable no compilations necessary Few Moving Parts easy to install Stable and reliable pl/sql based as stable as your database Supports Desktop, Responsive and Mobile Interfaces Community Support http://www.odtug.com/apexblogroll APEX Weakness Declarative Environment Property inter-relationships can be confusing refactoring can be hard/painful One datasource per declarative tabular form One Intera...

Using DDL trigger to call the DBMS_METADATA package to get source code of object, or use Oracle Dictionary Versions Compare between versions Use DIFF java class, deployed as Stored Procedure Developed by Stuart D Garthman  API to query the objects versions are just SQL queries, pipeline function, etc to return the differences - could use APEX front end DDL triggers are a bit risky, use appropriate error handling [Author note: formating is crappy here because my laptop ran out of battery. Need to charge. Also, not the best presntation]

So, you step a test database on another server, and you don't want to wait for PUPPET 1 to push out an update to your managed TNSNAMES.ora file with the database connection information. So how to you create a database link? The short answer can be summed up like so: " Don't overthink the problem. " Normally we create database links like so: SQL> create database link devdb connect to scott identified by tiger using 'DEVDB';   where DEVDB is an entry in your TNSNAMES.ora file. In the absence of such entries, a close approximation of the TNSNAMES.ora entry so we have this instead: SQL> create database link devdb connect to scott identified by tiger using '(DESCRIPTION = (ADDRESS= (PROTOCOL=TCP)(HOST=devhost.domain.com)(PORT=1521))(CONNECT_DATA=(SID=DEVDB)))'; 1 because you manage TNSNAMES files with a configuration tool, like Puppet, right? RIGHT!

So I wanted to play with some Python on my Mac, but need a little tutoral on how to do it. This helped me...a LOT http://www.cs.utexas.edu/~mitra/csSpring2012/cs327/cx_mac.html I should mirror it so it doesn't disappear.