What You May Have Missed This Week: Geek Humor, Cool Developers, Database Design and More
- 11 Things every Software Developer should be doing in 2012
- BI Publisher Licensing Considerations with Oracle E-Business Suite
- Tom Kyte’s Resolutions for 2012
- 91 Ways to become the Coolest Developer in the World
- Do You Make These 5 Database Design Mistakes?
- This jaw-dropping rendering of an iPhone 4 was written completely in CSS3
- 10 programming languages that could shake up IT
- Nine Hot Skills for 2012
- 10 Really Geek Humor Cartoons
- Five Key Ingredients of Essential Test-Driven Development
Interesting Things You May Have Missed This Week
- 15 top quotes of 2011
- Coding standards: is consistency prettier than freedom?
- Vim: revisited
- How to Think About Estimating
- 30 free programming eBooks
- What is 1e100.net?
- Advanced Bash-Scripting Guide
- Top 50 Programming Quotes of All Time
- Correlation may not imply causation, but it sure can help us insinuate it
- Using the Oracle Developer Days VirtualBox Image
- Bitmap Index vs. B-tree Index: Which and When?
- Relational Databases and Complex Data Types
- BigData University – Learn Hadoop and other Big Data technologies
- Implementing the Enterprise Service Bus Pattern to Expose Database Backed Services
Interesting Things You May Have Missed This Week
- An Introduction To The Most Popular And Least Loved Data Language In The World
- It Is Not Necessary To Drink At Least Eight Glasses Of Water A Day To Stay Properly Hydrated
- What It Looks Like Inside Amazon.com
- 50 Problem Words and Phrases
- The 45 Most Powerful Images Of 2011
- 15 Most Massively Popular Websites You’ve Never Heard Of
- Half Life of a Tech Worker: 15 Years
- How to use Firebug on your iPad and iPhone
- Cloud Computing as a Threat to Older Tech Companies
- Nine things learned from reading The Clean Coder on how professional developers conduct themselves
- Why everyone hates the IT department
- DevOps is not an absolute. It’s a range [Video Presentation]
- Google Used To Ask These Interview Questions, But They Are So Hard They Were Banned
Interesting Things You May Have Missed Today
- Common Errors in English Usage
- Popular myths in software development
- Video and text tutorials for a variety of computer related topics
- REST Vs SOAP web services
- Interactive web based Vim tutorial
- Overview of the Oracle NoSQL Database
- Listening to Mozart Won’t Make You Smarter
- The Most Exciting Oracle OpenWorld and JavaOne Announcements all in One Place
What is the Oracle Learning Library?
It’s a really useful resource. The Oracle Learning Library allows you to search for free online learning content on the internet. The content comes from a variety of sources, including OTN, YouTube and Blogs.
Leave a comment | Filed in Links, Oracle, Tips | Tags: videoOracle EBS Customization and Extension – OAF vs ADF vs APEX vs Forms
The E-Business Suite Technology Group recently released a whitepaper: Extending E-Business Suite 12.1.3 using Oracle Application Express. In summary, “This new whitepaper outlines how to extend Oracle E-Business Suite 12.1.3 (and higher) functionality using Oracle Application Express. Recommended architecture and security considerations are discussed in detail.” For some time now EBS customers have used APEX to extend EBS, with the release of this whitepaper the EBS Tech group has acknowledged the growing use of APEX to extend EBS and have provide recommendations and guidelines for integration.Comments Off | Filed in Links, Oracle | Tags: adf, apex, EBS, oaf
What’s this all about some might ask, is Oracle moving to incorporate APEX as part of the standard EBS tech stack? What about OAF? Isn’t Fusion Applications build on ADF, so what’s up? Well when it comes to Oracle EBS extension and customization, OAF is till the top dog, the E-Business Suite Technology Group continues to recommend OAF for EBS extensions.
Oracle DB 11g Password Expiry Gotcha
Something I discovered recently is that the DEFAULT profile for Oracle 11g sets the PASSWORD_LIFE_TIME to 180 instead of UNLIMTED by default. Applications will encounter an “ORA-28002: the password will expire within X days” error message if you keep the default value.
To change the PASSWORD_LIFE_TIME, you:
ALTER PROFILE default LIMIT password_life_time UNLIMITED;
Read more about 11g new security related features here.
1 Comment | Filed in Links, Oracle, Tips | Tags: 11g, gotcha, password, SecurityNeat Oracle Database 11g Release 2 Feature: Preprocessing External Tables
External tables enable users to access data in text files, immediately eliminating the need to load input text files to intermediate tables for processing—saving both time and storage space. Now, with Oracle Database 11g Release 2, intermediate processing of any kind—such as decompression of compressed input files—is eliminated, further saving time and storage, not to mention a change to the existing code.
But the power of inline preprocessing is not limited to decompression alone. It can be applied to any type of prior processing required, as long as it produces an output that can be parsed by the external table. The directory listing is just one small demonstration of this rich capability of preprocessing in external tables. You can also use it to massage datafiles to fit a specific format, append or augment data from multiple sources dynamically—without creating any intermediate storage—or even send an e-mail when a specific text file is accessed by an external table. What you can do with inline preprocessing is limited only by your imagination.
1 Comment | Filed in Links, Oracle | Tags: 11g, sqlBefore External Tables existed in the Oracle database, loading from flat files was done via SQL*Loader. One option that some used was to have a compressed text file and load it with SQL*Loader via a named pipe. This allowed one not to have to extract the file, which could be several times the size of the compressed file. As of 11.1.0.7, a similar feature is now available for External Tables (and will be in 10.2.0.5). This enhancement is a result of Bug 6522622 which is mentioned in the Bugs fixed in the 11.1.0.7 Patch Set note.
Conventional (NOAPPEND) parallel inserts available in Oracle DB 11g
Oracle 11g obviously has added the capability to perform a conventional, non-direct-path insert in parallel.
Greg Rahn:
Parallel conventional (NOAPPEND) insert was an 11g new feature, though it seems to have escaped the new features list in the docs. It was added to support cases where parallel insert as select was desired, but the restrictions associated with direct path inserts were not desired.Comments Off | Filed in Links, Oracle | Tags: 11g, sql
ODTUG KScope 11 and Database Content
Comments Off | Filed in Links, Oracle | Tags: kscope, odtugMy plan was to build the conference around the life cycle that a database developer works with. Since we weren’t cherry picking the content we couldn’t force anything on the schedule but the overall goal was to present topics, from beginner to expert, on Design, Coding, Maintenance and Best Practices. You can get more on what I mean by those topics at the site. I really believe we met that goal. You can also see the schedule now.
