Category: Databases

Installing Oracle Database 10g Express Edition and Changing the Default HTTP Port

In this article I will write about installing the Oracle Database 10g XE on Windows and changing the default port number for HTTP and optionally for FTP. The installer does not provide any customization option and you end up with the DB server instantly up and running reserving the port 1521 (a default for Oracle… Continue reading Installing Oracle Database 10g Express Edition and Changing the Default HTTP Port

Quest Software – Database Development Best Practices Workflow

www.ToadWorld.com – In this episode of the Quest on the Board whiteboard series, Quest Manager of Systems Consulting Amit Parikh describes how development teams can meet the objectives of productivity and collaboration through a best practices workflow that builds quality, performance and maintainbility into their code.

Avoiding Common Pain Points When Migrating to Business Objects XI

Avoiding Common Pain Points When Migrating to XI — Vol 5 A 2007 user conference presentation by Tim Nightingale, Strategic Technology Architect Are you experiencing little tribulations with your migration project, or are you trying to discover all the “gotchas” before you dive in? Overwhelmed by the differences between versions and don’t know where to… Continue reading Avoiding Common Pain Points When Migrating to Business Objects XI

High Concurrency MySQL

Domas Mituzas (Facebook) speaks at the 2010 O’Reilly MySQL User Conference & Expo. Slides – assets.en.oreilly.com From the official conference description at en.oreilly.com War and peace stories from Facebook how to detect, analyze and fix problems below, inside and above overloaded MySQL servers. This covers concurrecy problems that appear in real world environments, beyond labs… Continue reading High Concurrency MySQL

Jaspersoft At a Glance (Video webcast)

ワークブレイン・ジャパン株式会社 ジャスパーソフト設立準備室: Jaspersoft Business Intelligence Suite製品は、包括的なビジネスインテリジェンスファミリーとして、世界でもっとも使用されているオープンソースJavaレポーティング・ライブラリー（JasperReport）とレポートデザイナー(i-Report)、インメモリー分析・OLAP分析そしてデータ統合のETLが統合されたスイート製品。CognosやBusiness Objects（SAP)の代わりに定価で機能いっぱい。

How to set MySQL date from a result set to a PHP datetime object?

i am trying to set the date and time (DateTime stored in mysql database) to a php DateTime object, one way is to override the class some how to make that happen, but is there any easier way than that?e. g. $date = new DateTime();$date->setDate($mysql_resultset[‘date_time’]);and then format that date according and display it.

Starting Oracle ASM Instance & Database

This is basic step on how to start Oracle 11g ASM instance and then starting the Oracle 11g Database. You can see there was some errors so I updated the init file and fixed it because I had copied the init file from another box. Hope this helps. I will soon be uploading instructions step… Continue reading Starting Oracle ASM Instance & Database

Advanced Oracle PL/Sql: Programming With Packages

Product DescriptionSteven Feuerstein’s first book, Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle’s procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language — the package. The use of packages can dramatically improve your programming productivity and code quality, while… Continue reading Advanced Oracle PL/Sql: Programming With Packages

Crystal Reports Tutorial Using Running Totals Business Objects Training Lesson 13.1

Learn how to use a running total in Crystal Reports by Business Objects at www.teachUcomp.com. Get the complete tutorial at www.teachUcomp.com – the most comprehensive Crystal Reports tutorial available.

Modeling Business Objects with XML Schema

Product DescriptionXML Schema is the new language standard from the W3C and the new foundation for defining data in Web-based systems. There is a wealth of information available about Schemas but very little understanding of how to use this highly formal specification for creating documents. Grasping the power of Schemas means going back to the… Continue reading Modeling Business Objects with XML Schema

Special Report: Can that guy in Ironman 2 whip IBM in real life?

Special Report: Can that guy in Ironman 2 whip IBM in real life? In the movie “Ironman 2,” Larry Ellison makes a cameo appearance as a billionaire, playboy software magnate. It is a role he knows well. He is playing himself — chief executive of Oracle Corp, one of Silicon Valley’s most enduring, successful and… Continue reading Special Report: Can that guy in Ironman 2 whip IBM in real life?

Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples

Product DescriptionDesigned for any Oracle professional who must quickly implement Oracle reporting, this indispensable guide offers new tips and tricks that make Oracle reporting simple. The basics of PL/SQL are introduced using multiple examples that include code snippets and sample code results. The example-driven methodology teaches PL/SQL language structures, anonymous blocks, and stored procedures so… Continue reading Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples

Oracle Web Application Programming for PL/SQL Developers

Product DescriptionThis book covers everything you need to know to master Web application development in an Oracle environment – using PL/SQL. It is packed with practical tips that save the reader time, effort and frustration while developing and deploying Internet-ready, e-commerce applications using Oracle 9i. The book also provides important information on core topics such… Continue reading Oracle Web Application Programming for PL/SQL Developers