Top 10 Articles - User's Choice
Latest 50 Articles
Split List in to Multi-Column
2010-03-04 14:03:49Ooops, this turning out be an example needed for each query i get.
Neway, i enjoy answering them.
Consider this request, you have list, but you dont want to put in one below other.
Rather, 4 in a row, or consider X in a row and rest X of them in next line and goes on.
You can do it in many ways.
First simple one would be have multiple for-each stmt's in each column.
Add a filter on mod, 1,... [read more]
Split into multi-column
2010-03-04 14:03:09Ooops, this turning out be an example needed for each query i get.
Neway, i enjoy answering them.
Consider this request, you have list, but you dont want to put in one below other.
Rather, 4 in a row, or consider X in a row and rest X of them in next line and goes on.
You can do it in many ways.
First simple one would be have multiple for-each stmt's in each column.
Add a filter on mod, 1,... [read more]
How to build Excel Dashboards – 12
2010-03-04 13:26:58Previous – Excel Dashboard Tutorial – 11 How do you share your Excel Dashboard with users? Now that you have built the dashboard, you can share the dashboard in multiple ways. ” &l... [read more]
Design:: It’s a WhatchaMCallIt?
2010-03-04 13:14:57
That’s right its a WhatchaMCallIt…
Yes, yes wier... [read more] There’s No Pop Left In Big Bang
2010-03-04 13:07:03I have the opportunity to hear from lots of people in the ERP business: customers, ERP software vendors, service providers, consultants…the list goes on. All interesting people with interesting views on marketplace trends. Many of them are continually asking the same question: “When do you think the ERP implementation market is comi... [read more]
Deloitte Comments on SEC IFRS Announcement & Upcoming Webcast
2010-03-04 12:51:03Regarding the SEC announcement on the IFRS roadmap on Feb 24, 2010, Deloitte recently released its comments in its Heads Up document:
"SEC Publishes Work Plan for Moving Forward With IFRSs for U.S. Issuers". This Heads Up provides: A brief background of the SEC's 2... [read more]
How to build Excel Dashboards – 11
2010-03-04 12:25:02Previous – Excel Dashboard Tutorial
Summary
We buil... [read more] Hinting Dynamic Generated SQL in Application Engine
2010-03-04 12:22:00One of the clever things you can do in Application Engine is dynamically generate parts of a SQL statement. However, this can produce challenges should decide that you also need to add an optimiser hint to a SQL statement. In this post I want to demonstrate how you can also use the same techniques to dynamically generate valid Optimizer hints.
The following statement was generated by a step in a delivered Application Engine that had not been previous... [read more]
How to build Excel Dashboards – 10
2010-03-04 12:17:20Previous – Excel Dashboard Tutorial – 9 Cleanup – Resize and Organize Give appropriate names to each portlet.
During the chart creation if we did not provide names, now is the time to provide them.
Right click on each title and click on “Edit” ... [read more]
Java Memory Management
2010-03-04 12:13:08When writing programs it’s always good to know what’s happing in the core of the Framework you’re using. This allow you to get a better idea why things happen in a certain way or what to do in case you receive an error.
So if you’re a java programmer a good thing to read is this paper on memory management in the Virtual machine. It h... [read more]
How to build Excel Dashboards – 9
2010-03-04 12:04:25Previous – Excel Dashboard Tutorial – 8 Finish the Dashboard Design and Development By now, your dashboard is quite chaotic. You have objects all around your dashboard canvas with different sizes. We will st... [read more]
Andrew Dunstan: XSLT working properly in Postgres at last
2010-03-04 11:21:48Productive as ever, Tom Lane seems to have taken a break from making his head hurt on replication issues, and instead fixed some long-standing problems we've had with the xml2 contrib module's memory management. My small contribution was to get it building correctly on Windows.
This means (among other things) that we can now use xslt_process to transform XML in various useful ways. Examples could include generating HTML (or XHTML) from it, or preparing XSL-... [read more]
Overview Java Web Frameworks
2010-03-04 11:14:52This week I came across a good overview of Java Web Frameworks:
... [read more]
Real Time SQL Monitoring, A Goodie Of 11g….
2010-03-04 11:08:48Oracle’s newest database release 11g is having lots of goodies stored in it. Since now even the release 2 of it, (11.2.0.1) is also out, the number of goodies has just gone more higher! There are some things which are really very nice and are worth checking at least for once. This post is just about one of those goodies. The idea of this post is not about a new invention but about the introduction a worth-to-know kind of feature introduced with the Oracle 11g. Interes... [read more]
Use Oracle BI to Improve Project Performance with Primavera P6 EPPM
2010-03-04 11:03:44One of the best ways to drive performance of your projects in your organization is to publish the latest reports, trends, analysis and results on an internal website for your stakeholders, PMO and team members. One of the best ways that we have seen to do this since our acquisition by Oracle in 2008 is to publish your project portfolio data through Oracle BI (OBIEE) so that you do not require folks to log into a P6 client in order to gain visibility into... [read more]
Monitoring session for an Web Application in Weblogic
2010-03-04 11:01:27Make sure you have the following entry in weblogic.xml. <container-descriptor> <session-monitoring-enabled>true</session-monitoring-enabled> </container-descriptor>
The above entry enable the respective MBean in weblogic. You can override it i... [read more]
APEX 4.0 EA2 - Websheets
2010-03-04 10:35:00In APEX 4.0 EA2 the Websheet functionality is enabled. Websheets allow you to share information with others in a very quick, user friendly and secure way.
Let's have a look at an example. If you go to Application Builder in APEX 4.0 there is a new type there called "Websheet Applications".
... [read more]
SQL Server 2
2010-03-04 10:21:26Following on from my posting about the presentation (about Enterprise databases) that I did at a Microsoft event on SQL Server 2008, I’ve just had an article on how to design efficient SQL published on a website that’s strongly biased towards SQL Server developers – using an example of SQL written in the SQL Server dialect. It’s [...] ... [read more]
SQL Server 2
2010-03-04 10:21:26Following on from my posting about the presentation (about Enterprise databases) that I did at a Microsoft event on SQL Server 2008, I’ve just had an article on how to design efficient SQL published on a website that’s strongly biased towards SQL Server developers – using an example of SQL written in the SQL Server dialect. It’s [...]... [read more]
Escaping wildcard searches
2010-03-04 10:17:00
What if the character you want to search for is one of Oracle's wildcards?&... [read more]
Apex 4.0 - no more dummy branches required
2010-03-04 10:00:47How many times do you see this error page while building an Apex page?ERR-1777: Page 1 provided no page to branch to.Please report this error to your application administrator.To avoid that, I have a habit of creating an unconditional branch back to the same page in every page I build, with a sequence number higher than all the conditional branches. If I then add new conditional branches I have ... [read more]
Data Warehousing, ODTUG and the World Cup
2010-03-04 09:24:00It happens every four years and it happens when ODTUG is a guest in Washington DC. What is the fuss about, the FIFA World Cup is coming to ODTUG and so is data warehousing... The world cup of course starts on June 11 in South Africa, ODTUG starts on June 27 in Washington DC. The noise in the stadiums in South Africa will be deafening because of the many Vuzuvelas that will be tooted ove... [read more]
Don’t Assume – Transactions
2010-03-04 09:01:50MySQL by default is a NON transactional database. For the hobbyist (See The Hobbyist and the Professional), startup entrepreneur and website developer this may not appear foreign, however to the seasoned Oracle DBA who has only used Oracle the concept is very foreign. In MySQL you have to be concerned with two situations that will catch the unprepared out. The first is the default autocommit mo... [read more]
links for 2010-03-04
2010-03-04 09:01:19Event: Oracle at OpenFabrics Alliance (OFA) International Sonoma Workshop Oracle Session: "Infiniband- Enabling Massively Scalable Database" by Tim Shelter (VP Oracle Product Management), Monday March 15, 2010 at 8:30 a.m.... [read more]
How to build Excel Dashboards – 8
2010-03-04 08:56:13Previous – Excel Dashboard Tutorial – 7 Create Pie Chart We will now create a pie chart by product name
... [read more] 'Io exception: NL Exception was generated' running IRCA
2010-03-04 08:34:16Shahed pinged me about this during SOA installation:
$ sh irca.sh
Integration Repository Creation Assistant (IRCA) 10.1.3.1.0
(c) Copyright 2006 Oracle Corporation. All rights reserved.
Enter database "host port serviceName" [localhost 1521 orcl]: justanexample 1521 soa11g
Enter sys password:
Running IRCA for all product(s):
connection="justanexample 1521 soa11g", , orabpelUser=ORABPEL, esbUser=ORAES... [read more]
Absent Code attribute in method that is not native or abstract
2010-03-04 08:11:03I ran into the following problem yesterday while building a rest service using resteasy: the code would compile ok, but the unit tests wouldn’t run. I got the following exception in the output of the unit tests: java.lang.ClassFormatError: Absent Code attribute in method that is not native or abstract in class file javax/ws/rs/ext/RuntimeD... [read more]
How many fsync / sec FusionIO can handle
2010-03-04 08:09:44I recently was asked how many fsync / sec ( and therefore durable transactions / sec) we can get on FusionIO card. It should be easy to test, let's take sysbench fileio benchmark and run, the next command should make it:
./sysbench --test=fileio --file-num=1 --file-total-size=50G --file-fsync-all=on --file-test-mode=seqrewr --max-time=100 --file-block-size=4096 --max-requests=0 run
... [read more]
Evidence Based Medicine - Textual ETL Makes It Possible
2010-03-04 08:05:54I have been researching on this subject for the past few months. It is becoming clear that to control errors in diagnosis and treatment of medical conditions, Evidence Based Medicine can be defined as "the conscientious, explicit and judicious use of current best evidence in making decisions about the care of the individual patient. It means integrating individual clinical expertise with the best available ext... [read more]
HUGmn techday2010 - March 11 in Minneapolis
2010-03-04 07:46:28I will be presenting next week at the Hyperion User Group - Minnesota 'TechDay 2010' event next week in Minneapolis. The user group has lined up a number of great speakers including fellow Oracle ACE Directors Edward Roske from interRel Consulting and Eric Helmer from The Hackett Group. Oracle Essbase product managers Alan Lee and Karen Zubetz and HFM product manager Mike Malwitz will also be doing presentations along with a number of other consultants.&n... [read more]
Issues in WebLogic Portal integration with Oracle Entitlement Server
2010-03-04 07:17:21In previous posts I have specified the supported and working WebLogic JDK versions for Oracle Entitlement Server. I have tested protecting the WebLogic Server application where OES Admin is installed on WLS 10.3.1 and it went fine. However, when I used WLS 10.3.1 for Admin server and tried to install the WebLogic Portal sample application (SimplePortalExample present in ales32-ssm/wls-ssm/examples) , I am stuck... [read more]
Dan Langille: PGCon 2010 - schedule
2010-03-04 06:17:49The PGCon 2010 schedule has been announced. Have a read of our outstanding lineup, see where people come from to PGCon, and get your registration started.... [read more]
Why Doesn’t this Trigger Code Work?
2010-03-04 06:00:06March 4, 2010 A couple of days ago I received an interesting email from an ERP mailing list. That email contained an Oracle trigger that looked like it would be helpful, but the author of the trigger was struggling a bit with the PL/SQL code and asked for some assistance with the trigger code. The trigger code contained in the email looked like this: CREATE OR REPLACE ... [read more]
SMS Coupons
2010-03-04 05:49:35I text on my phone on rare occasions, usually when I need an immediate response like, "where are you?" It seems like a crude way to do advertising, unless its contextual as in the case of Placecast and the like. But its one advantage is that every mobile phone supports SMS/texting, so it has maximum customer reach. <... [read more]
Live RAC SIG Web-cast Today: Oracle ASM 11g — The Evolution
2010-03-04 05:38:23Just a quick announcements… If you didn’t manage to attend my presentation, Oracle 11g ASM — The Evolution, during RMOUG or other conferences, you have a chance to see it online today. I’m doing it a ... [read more]
Live RAC SIG Web-cast Today: Oracle ASM 11g — The Evolution
2010-03-04 05:38:23Just a quick announcements… If you didn’t manage to attend my presentation, Oracle 11g ASM — The Evolution, during RMOUG or other conferences, you have a chance to see it online today. I’m doing it a ... [read more]
Design:: It’s a WhatchaMCallIt?
2010-03-04 05:14:57That’s right its a WhatchaMCallIt…
Yes, yes wierd random blog post - I was playing with photoshop last night and randomly ... [read more] Predictions from Financial Executives
2010-03-04 05:00:00I read something this week that merits sharing and reinforces why business performance management is so critical during challenging economic times. In February of this year, a poll - the Business Volatility and Variables Survey - was conducted by Adaptive Planning and the Business Performance Management Forum. Financial executives were polled, and here are some of the survey findings.
Fifty-one percent of these financial executives predic... [read more]
Google apps and iGoogle widgets. Dear Google - I Love You But You Don't Communicate
2010-03-04 04:15:13The silence is deafening... [read more]
The NoSQL That Must Not Be Named!
2010-03-04 04:00:03I would have named it the DB Horcrux. Think about it.... [read more]
The NoSQL That Must Not Be Named!
2010-03-04 04:00:03I would have named it the DB Horcrux. Think about it.
The NoSQL That Must Not Be Named!
2010-03-04 04:00:03I would have named it the DB Horcrux. Think about it.... [read more]
APEX 4.0 EA2 - Websheets
2010-03-04 03:27:05In APEX 4.0 EA2 the Websheet functionality is enabled. Websheets allow you to share information with others in a very quick, user friendly and secure way.
Let's have a look at an example. If you go to Application Builder in APEX 4.0 there is a new type there called "Websheet Applications".
... [read more]
Overview Java Web Frameworks
2010-03-04 03:14:52This week I came across a good overview of Java Web Frameworks:
... [read more]
Congratulations Amy on an outstanding TEDTalk
2010-03-04 02:33:07
While I didn’t get to go to the talk I did get to hear people raving to Amy about how i... [read more] 
Subscribe to relationalnews.com